Free online XML to CSV converter
Convert structured XML records into a flat CSV table for spreadsheets, databases, and reporting tools.
Convert XML to CSV online - free
Column separator
Excel in many European languages expects a semicolon; with commas it puts everything into one column.
Character encoding
If Excel shows broken accents, choose UTF-8 with BOM or the Windows code page.
Your file is processed automatically and deleted right after you download the result, or after 3 hours at the latest.
Import a file from a URL
Paste a direct link to the file. We download it to our server and it is converted exactly like an upload.
How it works
-
1/3
Upload your .xml file
Click to browse to select your file you want to convert or simply drag & drop your file into selected area.
-
2/3
Perform .xml to .csv conversion
After successful file upload, click to convert when you are ready.
-
3/3
Download converted .csv file
Conversion result is ready to download.
Conversion statistics: XML to CSV
Updated November 15, 2026, from conversions on 101convert.com
How to convert xml to csv file
- Text files
- No ratings yet.
A spreadsheet, database importer, reporting system, or older business application may accept CSV but not XML. Converting the data creates a flat table that is easier to filter, analyze, share, or archive, provided the XML hierarchy can be mapped to rows and columns.
What the XML format is
XML (Extensible Markup Language) is a text format for structured data. It represents values with nested elements and attributes, and may use namespaces to distinguish vocabularies. Applications use XML for configuration files, invoices, product catalogs, accounting exports, content-management systems, web-service responses, and document interchange.
Common producers include Microsoft Office, accounting software, enterprise systems, custom applications, and government data services. A file usually has the .xml extension and may begin with a declaration such as <?xml version="1.0" encoding="UTF-8"?>. XML can describe one record, a collection of records, or a hierarchy such as an order containing a customer, payments, and multiple line items.
What the CSV format is
CSV (Comma-Separated Values) stores a table as records and fields. The first row often contains column names; later rows contain values separated by a delimiter, usually a comma. A field containing the delimiter, quotation marks, or a line break must be enclosed in double quotation marks, with embedded quotation marks represented by two quotation marks.
CSV is supported by Microsoft Excel, LibreOffice Calc, Google Sheets, database import tools, statistical software, and programming libraries. It is compact and convenient for sorting, filtering, analysis, and bulk import. Unlike XML, ordinary CSV has no standard way to preserve nested elements, attributes, comments, mixed text, element order, or several child records inside one parent row. CSV is a family of delimiter and quoting conventions rather than one completely uniform specification.
How to convert the data
Use the 101convert.com converter
You can convert the file for free on 101convert.com without installing software:
- Open the XML-to-CSV converter on 101convert.com.
- Select the source
.xmlfile. - If structure-selection options are available, choose the repeating XML element that should become one CSV row.
- Review the detected fields, column mapping, delimiter, and text encoding.
- Start the conversion and save the resulting
.csvfile.
Do not upload customer, financial, medical, credential, or other confidential data unless the service satisfies your organization’s security and retention requirements.
Use spreadsheet software for a simple table
Spreadsheet applications are suitable when the XML already contains a regular list of records and the file is small enough to inspect manually. In LibreOffice Calc, choose File → Open and select the XML file. If Calc does not expose the required XML elements as tabular data, use a dedicated XML import or transformation step instead of assuming that opening the file will produce a correct table.
After importing the records, inspect the columns and several rows, then choose File → Save As and select Text CSV (.csv). Set the delimiter, quote character, and character encoding explicitly. UTF-8 is generally the safest choice; use a semicolon or tab only when the destination system requires it.
Use Python for repeatable conversions
When the XML structure is known, select the repeating element and fields explicitly rather than flattening every node automatically:
import csv
import xml.etree.ElementTree as ET
root = ET.parse("input.xml").getroot()
with open("output.csv", "w", newline="", encoding="utf-8") as f:
writer = csv.DictWriter(f, fieldnames=["id", "name", "price"])
writer.writeheader()
for item in root.findall(".//item"):
writer.writerow({
"id": item.get("id", ""),
"name": item.findtext("name", default=""),
"price": item.findtext("price", default="")
})
Replace .//item and the field names with paths from the actual document. Namespace prefixes are not part of ElementTree search names; use the namespace URI, for example {urn:example}item, or pass a namespace mapping to the search method. For very large files, use ET.iterparse() and clear processed elements so the entire document does not remain in memory.
Quality and compatibility limits
- Nested records: An order with several line items cannot be represented faithfully in one ordinary row. Export separate files such as
orders.csvandorder_items.csv, or repeat the parent values on each item row. - Attributes and missing elements: Decide which attributes become columns and whether absent values should be empty, marked as null, or replaced with defaults.
- Namespaces: Elements displayed as
inv:itemare identified by their namespace URI, not just by the visible prefix. - Mixed content and order: Text interleaved with child elements, comments, processing instructions, and significant element order may be lost when the data becomes a table.
- Encoding and quoting: Verify UTF-8 handling for accented letters and non-Latin scripts. Check fields containing commas, quotation marks, or line breaks; incorrect quoting can shift values into the wrong columns.
- Spreadsheet interpretation: Excel and similar programs may convert identifiers, long numbers, dates, and values with leading zeros. Import columns with explicit text or numeric types when their original representation must remain unchanged.
- Validation: Compare the number of selected XML records with the CSV row count, inspect representative nested and empty values, and open the output in a plain-text editor to verify its delimiter, quoting, and encoding.
XML vs CSV: format comparison
How the XML and CSV formats compare on the properties that matter most for this conversion.
| Property | .XML Extensible Markup Language | .CSV Comma-Separated Values |
|---|---|---|
| Plain-text readable | Yes | Yes |
| Data types | Typed | Typed |
| Nested structures | Yes | No |
| Formulas | No | No |
| Multiple tables or sheets | — | No |
| Typical file size | Small | Small |
| Open standard | Yes | Yes |
| Best used for | Data exchange | Data exchange |
| Introduced | 1998 | — |
| Developer | W3C | — |
| MIME type | application/xml | text/csv |
Information about file extensions and file types is provided by File-Extensions.org
Suggested software and links: xml to csv converters
Frequently asked questions
Is the XML to CSV converter free?
Yes, converting XML to CSV on 101convert.com is completely free. No registration, email address or installation is required. If you need a higher file size limit or want to convert more files at once, see our plans.
How large can my XML file be?
You can upload XML files up to 10 MB and convert up to 3 files at once in a single batch. With a paid plan the limit is up to 300 MB per file and 100 files at once, see our plans.
What happens to my uploaded files?
Files are processed automatically. Your upload is deleted from our servers right after you download the result, or after 3 hours at the latest. We never view or share your files.
Do I need to install any software to convert XML to CSV?
No. The XML to CSV conversion runs entirely online in your browser and works on Windows, Mac, Linux, Android and iPhone.
Did the conversion fail?
In most cases, the cause is an incorrect file format. Please upload a valid XML file for this XML to CSV conversion. Occasionally, the issue may be on our side. We analyze recurring conversion failures and disable or fix the converter if we detect a defect.