Tutorial

How to convert XML to CSV (3 methods)

Pick the workflow that matches your skillset: browser-based, Excel-based, or scripting.

Drop XML here or click to upload.

Waiting for XML upload …

Selected file: None

Method 1 – Browser

  1. Open this page, upload XML, pick CSV, click convert.
  2. Download the CSV and open it in Excel/Sheets.
  3. Clean up headers if necessary.

Method 2 – Excel

  1. Data → Get Data → From File → From XML.
  2. Excel builds a table. Export as CSV.
  3. Use Power Query to transform complex nodes.

Method 3 – Code

  • Python: xmltodict + pandas (see developer page).
  • Node.js: xml2js + json2csv.

FAQs

Common how-to questions

What if my XML has nested nodes?

The converter flattens nested structures. In Excel, use Power Query’s expand feature.

How do I clean header names?

Rename columns manually or run a find/replace to remove dot notation.

Does CSV support UTF-8?

Yes—our converter exports UTF-8 by default. In Excel, choose UTF-8 during save.