XML to CSV

Convert repeated XML elements to CSV rows for Excel and analysis

XML Input

CSV Output

What is XML to CSV Converter?

Spreadsheets and BI tools want rows and columns, but a lot of source data still arrives as XML — a CDR export, a SIM-provisioning batch, a product catalogue from a vendor. Opening an XML file in Excel is clunky, and writing a one-off parser for a quick analysis is overkill. This converter takes the repeated elements in your XML (the <subscriber> in a list of subscribers, say) and turns each one into a CSV row, with every child element becoming a column. Paste, copy the CSV, and open it in Excel, Google Sheets, or pandas.

Under the hood it parses your XML with the browser's DOMParser — the engine described in the W3C's XML specification — finds the first repeating set of elements, and writes them out as comma-separated values that follow the quoting rules in RFC 4180. Everything runs in your browser; the XML never leaves your machine.

How to Use XML to CSV Converter

  1. Paste Your XML – Drop a well-formed XML document into the left panel. It should contain a list of similar elements — that repeating element is what becomes your rows.
  2. Watch It Convert – CSV appears in the right panel as you type. There is no Convert button; a short debounce keeps it responsive.
  3. Check the Columns – The converter unions the child-element names across every row, so even if some records are missing a field, the header still lists every column it found.
  4. Mind the Quoting – Values containing commas, quotes, or newlines are wrapped in double quotes and internal quotes are doubled, per RFC 4180 — so the CSV opens cleanly in any spreadsheet.
  5. Copy or Download – Use Copy to grab the CSV text, or Download to save a .csv file ready for Excel, Sheets, or a data pipeline.

Pro Tip: The converter looks for the first repeating set of elements to use as rows. If your XML wraps the list a few levels deep (e.g. <response><data><subscriber>...</subscriber></data></response>), it still finds the <subscriber> list. If you have several unrelated lists, keep only the one you want to export in the input.

Example

A subscriber roster: each repeated <subscriber> element becomes a CSV row, and its child elements (subscriberId, msisdn, plan, dataUsage) become the columns.

XML → CSV Convert
subscribers.xmlXML
<subscribers>
  <subscriber>
    <subscriberId>SUB-1001</subscriberId>
    <msisdn>447700900142</msisdn>
    <plan>Unlimited 5G</plan>
    <dataUsage>45.2</dataUsage>
  </subscriber>
  <subscriber>
    <subscriberId>SUB-1002</subscriberId>
    <msisdn>447700900458</msisdn>
    <plan>Business 200GB</plan>
    <dataUsage>120.5</dataUsage>
  </subscriber>
</subscribers>
subscribers.csvCSV
subscriberId,msisdn,plan,dataUsage
SUB-1001,447700900142,Unlimited 5G,45.2
SUB-1002,447700900458,Business 200GB,120.5

Common Use Cases

Loading Telecom Exports Into a Spreadsheet

CDRs, SIM-provisioning batches, and HSS lookups often land as XML. Analysts who live in Excel or Google Sheets don't want raw XML — they want a grid they can pivot and chart. Converting to CSV first gets the data into a familiar tool in seconds, no scripting required.

Feeding XML Into pandas or R

Data scientists usually reach for pandas.read_csv or R's read.csv to start an analysis. When the source is XML, a quick conversion to CSV is the path of least resistance — far simpler than wrangling an XML tree in code for a one-off exploration.

Migrating Catalogue or Inventory Data

Vendor product feeds and inventory dumps frequently come as XML with one element per item. To bulk-import them into a database or an e-commerce platform that takes CSV uploads, convert here first. The W3Schools XML tutorial is a useful refresher if you need to tweak the source structure first.

Key Features

  • Real-Time Conversion – CSV updates as you type; no Convert button to click.
  • Automatic Row Detection – Finds the first repeating set of elements and turns each into a row, even when it is nested a level or two deep.
  • Union of Columns – Headers cover every child-element name seen across all rows, so records missing a field still line up.
  • RFC 4180 Quoting – Values with commas, quotes, or line breaks are escaped correctly so spreadsheets parse them cleanly.
  • Privacy First – Parsing runs entirely in your browser with DOMParser; nothing is uploaded.

Frequently Asked Questions

Which XML elements become rows?

The converter looks for the first set of repeated sibling elements and uses each occurrence as a row. In a document like <subscribers><subscriber>...</subscriber>...</subscribers>, the repeated <subscriber> elements become the rows and their children become the columns.

What if records have different fields?

The header is built from the union of all child-element names across every row. If one record is missing a column that others have, that cell is left blank rather than shifting the row. This keeps the CSV rectangular and safe to open in any spreadsheet.

How are XML attributes handled?

Attributes are gathered internally under an @attributes key, which is skipped when building the columns — so the CSV columns come from the child elements, not from attributes. If you need an attribute as a column, promote it to a child element in the XML first.

How are commas and quotes inside values escaped?

Per RFC 4180, any value containing a comma, a double quote, or a newline is wrapped in double quotes, and any double quote inside the value is doubled (" becomes ""). That is the convention Excel and most CSV readers expect.

Is my data safe?

Yes. The conversion uses the browser's DOMParser and runs entirely client-side. Neither the input XML nor the output CSV is sent over the network, cached, or logged.

Related Tools

  • XML to JSON – Convert the same XML to JSON instead, for code rather than spreadsheets.
  • JSON to CSV – Already have JSON? Flatten it straight to CSV.
  • JSON to XML – Going the other way — build XML from JSON.
  • JSON to Table – Preview structured data as an interactive table before exporting.

Useful Resources

  • RFC 4180 – The Common Format and MIME Type for CSV Files — the quoting rules this tool follows.
  • W3C XML – The official home of the XML specification and related standards.
  • MDN DOMParser – Documentation for the browser API that powers the parsing step.
  • pandas read_csv – Load the resulting CSV straight into a DataFrame for analysis.
  • W3Schools XML Tutorial – Step-by-step XML introduction including XPath and XSD basics.
  • Stack Overflow XML – Community answers for XML parsing and flattening edge cases.