- To extract all data from your xml file.
- To store and view the data extracted in excel.
- To ease and facilitate better visualization of data.
- Clone or Download my github repository
- Paste your .xml inside the cloned repository.
- OPEN parsing_xml.py file.
- Edit parsing_xml.py file by changing the name of input .xml file to your .xml file name.
- Also change the name of the ecxel file created as your requirement.
- Now everything is done and run the python file in terminal to get your desired output.
- Python 3.5 or higher (Python)
- If you have followed the above steps then the output might be like this.
- If you see some links in your (title) do the following steps or else enjoy!!!....
- In order to remove the links before your title delete the xmlns as shown here.
- If you could not see the xmlns link then search for the link that is in your excel file and delete it in your xml file and run the python file again.
- Hopefully everything is solved. ENJOY!!!...
- If there are some issues let me know yours and I will guide you.
Short visualization of this project
- Extracting Data
- In my case I have converted 50K lines of my xml data into xlsx.