Convert XML to CSV with python

Convert XML to CSV with python

July 28, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Convert XML to CSV with python

Converting XML to CSV for Magento Import

If you’re trying to convert XML files into CSVs for Magento import, you’ve come to the right place. In this guide, I’ll show you how to efficiently handle your XML data and transform it into a CSV format that’s compatible with Magento.

Understanding Your XML Structure

First, let’s briefly analyze the provided XML structure:

<Value AttributeID="attributes">
    <Product UserTypeID="Item" ParentID="12345678" AnalyzerResult="included" ID="123456">
        <!-- Product attributes here -->
    </Product>
</Value>

Under the <Values> tag, you have multiple <Value> elements with varying AttributeID values. This means each product can have a unique set of attributes.

Using Python for XML to CSV Conversion

Python is an excellent choice for this task due to its powerful libraries like xmltodict, which makes parsing XML a breeze.

Here’s a step-by-step approach using xmltodict:

  1. Install the required library: If you haven’t installed it yet, run:
pip install xmltodict pandas
  1. Parse the XML: Import the necessary modules and parse your XML file using xmltodict.parse().
import xmltodict
import pandas as pd

with open('products.xml', 'r') as f:
    data_dict = xmltodict.parse(f.read())
  1. Flatten the dictionary: The parsed data is in a nested dictionary format. To convert it into a flat list of dictionaries, you can use a recursive function.
def flatten_dict(d):
    out = {}
    for k, v in d.items():
        if isinstance(v, dict) and 'Value' not in k:
            out.update(flatten_dict(v))
        else:
            out[k] = str(v)
    return out

product_list = [flatten_dict(p['Product']) for p in data_dict['STEP-ProductInformation']['Products']['Product']]
  1. Convert to DataFrame: Now, convert the list of dictionaries into a Pandas DataFrame.
df = pd.DataFrame(product_list)
  1. Save as CSV: Finally, save the DataFrame as a CSV file using to_csv().
df.to_csv('products.csv', index=False)

Handling Attribute Variability

For the hundreds of different possibilities under <Values>, Python’s dynamic nature handles this seamlessly. Each product will have only the attributes defined in its XML, and Pandas will correctly handle missing values.

Conclusion

Converting XML to CSV for Magento import doesn’t have to be a complex task. By using Python and leveraging libraries like xmltodict and pandas, you can efficiently parse your XML data and transform it into a CSV format that’s ready for import.

Remember, consistency is key in data migration processes. Always validate the CSV output on the Magento website before performing the actual import to ensure everything matches your expected structure.

If you’re looking for more advanced data handling solutions or custom Magento development services, feel free to explore Laravel Company for expert assistance and tailored solutions that match your specific needs.

Catalog Extensions Import/Export

Our network