Skip to content

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

Uploading…

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.

How it works

  1. 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. 2/3

    Perform .xml to .csv conversion

    After successful file upload, click to convert when you are ready.

  3. 3/3

    Download converted .csv file

    Conversion result is ready to download.

Conversion statistics: XML to CSV

XML files are most often converted to SRT 40% VCF 16% PLIST 16% CSV 10%

Updated November 15, 2026, from conversions on 101convert.com

How to convert xml to csv file

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:

  1. Open the XML-to-CSV converter on 101convert.com.
  2. Select the source .xml file.
  3. If structure-selection options are available, choose the repeating XML element that should become one CSV row.
  4. Review the detected fields, column mapping, delimiter, and text encoding.
  5. Start the conversion and save the resulting .csv file.

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.csv and order_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:item are 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.

Comparison of the XML and CSV file formats
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

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.

Additional formats for
xml file conversion

Reverse conversion

Convert to csv from
other formats

Share on social media:

Already downloaded

This file has already been downloaded. For your privacy it was deleted from our server right after the download, so it cannot be downloaded again. To get it once more, convert the file again.