Convert XML to CSV
Convert XML records into a spreadsheet-ready CSV. The repeating element becomes the rows, and its children and attributes become columns. Nothing leaves your browser.
- No sign-up
- Processed locally
- Row element auto-found
- Attributes become columns
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
XML to CSV in three steps
No account, no email, no waiting for an upload.
- STEP 01
Drop in your XML
Use an .xml file or text from an export, feed or API.
- STEP 02
Name the row element, if needed
Leave it blank and the first repeated element is used. Or type its name, such as book or item.
- STEP 03
Copy or download the CSV
The note says how many rows were found and which element they came from.
What XML to CSV does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Automatic row detectionThe tool looks for the first repeating element, such as the many item elements in a feed.
- Attributes as columnsAttributes are included with your chosen prefix, such as @id.
- Nested elementsFlatten nested children into dotted columns, keep lists as JSON text, or keep nested parts as text.
- CSV optionsPick the separator and optionally guard against spreadsheet formulas.
- Syntax checked firstMalformed XML is reported with its line and column.
Good to know
- Works best on regular dataIf records have very different children, you get many sparse columns.
- One record type at a timeA file with several kinds of repeating elements gives rows for one of them. Name the element you want.
- Everything is textValues are written as plain cell text. Format dates and numbers in your spreadsheet.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use XML to CSV
Open a data export in Excel
Move XML records into a spreadsheet.
Review an RSS feed
Turn feed items into rows.
Analyze a legacy system dump
Get tabular data from an older XML export.
Inspect API output
See repeated records as a table.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How rows are chosen
XML does not say which element is a record, so the tool searches for the first element that repeats, in document order. In a catalog with many book elements, that is book. In a feed, it is item or entry.
If that is not what you want, type the element name in the Row element box.
What becomes a column
Child elements and attributes of a row element are columns. Nested elements are flattened to names such as author.name, unless you choose another option.
- Attributes are named with your prefix, @ by default.
- Text and attributes on the same element give an extra #text column.
- Repeated children inside a row are numbered, like tag.0 and tag.1.
- For hierarchical output use XML to JSON. Reverse the process with CSV to XML.
A small example: XML to CSV
A catalog with many book elements, each with an id attribute, a title and an author, becomes a CSV with the columns @id, title and author, one row per book. If each book also had a list of tags, you would get columns like tags.0 and tags.1, or one JSON text column if you chose that option.
Questions, answered
How do I convert XML to CSV?
Paste the XML. The repeating element becomes rows, and its children and attributes become columns.
How does it know which element is a row?
It uses the first element that repeats. You can override that by typing the element name.
Is the XML I convert uploaded anywhere?
No. The file is parsed and flattened by script in this tab, so the data stays on your device.
What about attributes?
They become columns, named with the prefix you choose, such as @id.
Can I open the CSV in Excel?
Yes. Semicolon separators are available for regions that use a decimal comma.
Can I convert XML to CSV on a phone?
Yes. Phones and tablets with a current browser can run it. The CSV can be saved to Files or Drive.