This is a simple tool to convert your xml file to csv file. This scripts uses ElementTree. The medium post cooresponding to this library is also available.
- Fatemeh Rahimi, Sep 2020
- link to medium (coming soon)
You can either use the python command itself for running the script or use the CLI tool.
- clone the repo
git clone giturlchange your directory to the convertXMLtoCSV directory.
Usage:
Sample1:
python3 xmlutils/convert_xml_to_csv.py samples/sample1.xml -c attr -v text -a name -o samples/
sample2:
python3 xmlutils/convert_xml_to_csv.py samples/sample2.xml -c tag -v text -o samples/
sample3:
python3 xmlutils/convert_xml_to_csv.py samples/sample3.xml -c tag -v text -o samples/
- using pip
after cloning the repo, install it with pip
pip install .
Now you can use this CLI tool through your command line.
Usage:
Usage: convertxmltocsv [OPTIONS] XML_FILE
Options:
-o, --output-dir PATH Path to the output directory.
-c, --column-based TEXT 'attr' for setting attributes as columns,
'tag' for setting tags as columns.
-v, --value TEXT 'tag' for settting tag as a column value,
'text' for setting text as the column value,
'attr' for settting attrib for a column value
-a, --attr TEXT The attribute name that its value is going to be
the column names or values.
--help Show this message and exit.
Running the samples:
sample1:
convertxmltocsv samples/sample1.xml -c attr -v text -a name -o samples/
sample2:
convertxmltocsv samples/sample2.xml -c tag -v text -o samples/
sample3:
convertxmltocsv samples/sample3.xml -c tag -v text -o samples/