Converting all XML files to JSON files in a folder in python?

Question

I have a folder with 1000's of XML files. Now I would like to read each xml file and create a json file for that respective xml file without deleting the xml file.

For example: if I have a file named abc.xml I want that xml file to be converted into json and stored as abc.json so the folder should have abc.xml, abc.json and it should be the same for all the files.

Currently, I am using the below code chunk to convert the xml to json but the issue is it is not creating a new json file.

for filename in os.listdir(path):
    if not filename.endswith('.xml'): continue
    fullname = os.path.join(path, filename)
    with open(fullname, 'r') as f:
        xmlString = f.read()
    jsonString = json.dumps(xmltodict.parse(xmlString), indent=4)
    with open(fullname, 'w') as x:
        x.write(jsonString)

Any kind of relevant suggestions would be really appreciated.

looks that you're overwriting your xml file, you're not changing the file name — Jean-François Fabre
– Jean-François Fabre ♦, Commented Oct 25, 2018 at 19:32
Yes, that's exactly what's happening which I don't want. I want to create a new json file for that xml file. — Akash Bachu
– Akash Bachu, Commented Oct 25, 2018 at 19:34

Jean-François Fabre · Accepted Answer · 2018-10-25 19:49:57Z

2

fullname is the name of your input xml file. You want to change it to "same thing but json" else you'll create a file with xml extension but json data (destroying your original xml file, not that I care about xml much but...)

with open(fullname, 'r') as f:
    xmlString = f.read()
json_output = os.path.splitext(fullname)[0]+".json"

now write your file directly (no need to create a string first)

with open(json_output, 'w') as f:
    json.dump(xmltodict.parse(xmlString), f, indent=4)

note that you could use glob.glob directly like this so you get the full, xml filtered path:

for fullname in glob.glob(os.path.join(path,"*.xml"):

edited Oct 25, 2018 at 19:49

answered Oct 25, 2018 at 19:37

Jean-François Fabre♦

141k24 gold badges179 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akash Bachu Over a year ago

Thanks Jean. Working perfectly. Appreciate your help.

user3148225 · Accepted Answer · 2018-10-25 19:53:34Z

0

This should work.

import xmltodict

for filename in os.listdir(path):
    if not filename.endswith('.xml'):
        continue

    fullname = os.path.join(path, filename)

    with open(fullname, 'r') as f:
        xmlString = f.read()

    jsonString = json.dumps(xmltodict.parse(xmlString), indent=4)

    with open(fullname[:-4] + ".json", 'w') as f:
        f.write(jsonString)

answered Oct 25, 2018 at 19:53

user3148225

4251 gold badge7 silver badges17 bronze badges

Collectives™ on Stack Overflow

Converting all XML files to JSON files in a folder in python?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related