CSV to XML Converter

Paste CSV/TSV data to convert it into XML, where each row becomes a element (format: value...).

What this CSV to XML conversion does

There are still plenty of situations that call for tabular data in XML: intake specifications for long-established business systems, input for reporting engines, and a number of APIs. Paste CSV or TSV here and this tool turns it into XML with one record per row. The output uses the straightforward shape `value...`, ready to hand to XSLT or a parser.

The first line is read as a header and each column heading becomes a tag name. XML restricts what a tag name may look like, so **headings that begin with a digit, are empty, or contain disallowed characters are replaced automatically with a numbered name such as `column1` or `column2`.** Ampersands, less-than and greater-than signs in values are escaped into entity references. Everything runs in your browser, so data you would rather not send anywhere — customer records, for instance — stays with you.

How to convert CSV into XML

  1. Paste CSV or TSV The first line is treated as headings and the rest as data. Tab-separated input works too.
  2. Check the tag names Headings become tag names directly. Note that a heading which cannot legally be a tag name is replaced with a numbered one.
  3. Review the generated XML `` sits at the top with each record below it as a ``.
  4. Copy it for the next step Use it directly as input to an XML-consuming system, or as the source for an XSLT transformation.

Tips for getting more out of it

  • Enable "Treat first line as header" to use the header row's column names directly as XML tag names (headers that aren't valid XML tag names — such as those starting with a digit or containing symbols — automatically fall back to `column1`, `column2`, etc.).
  • If you don't use headers, every row is treated as data, and each column becomes a `column1`, `column2`, ... tag.
  • Use this tool whenever a legacy XML-based API, a SOAP integration, or certain enterprise systems require XML instead of CSV for data import.
  • The generated XML safely escapes special characters using character entity references (&, <, >), so you can import it directly into external systems.

Where this conversion helps

Loading into a system that only accepts XML

Shapes data prepared in a spreadsheet into something a core business system expecting XML will take.

Producing a data source for a reporting engine

Many reporting engines take XML as their data source, and this gets you from a CSV to a prototype quickly.

Preparing practice data for XSLT

When writing a transformation stylesheet, you can produce sample XML from a table you already have.

Seeing the structure with your own eyes

Viewing the column-to-value relationship as XML nesting sometimes makes the structure easier to grasp than the flat CSV.

CSV to XML terms explained

Tag name restrictions
An XML tag name must start with a letter or an underscore and cannot contain spaces or most punctuation. **Headings that do not satisfy this are replaced automatically with names like `column1`.**
Entity reference
Rewriting `&`, `<` and `>` as `&`, `<` and `>`. **The ampersand has to be converted first, or the result is double-escaped.**
The row element
The element representing one record. This tool nests `` elements inside a single ``.
TSV
Tab-separated tabular data. Copying out of a spreadsheet usually produces this format.
Header row
The column headings on the first line. Because tag names come from them, writing them with letters, digits and underscores keeps the output readable.

Frequently Asked Questions

Many SOAP-based web services, along with numerous long-running enterprise and core systems, adopted XML as their standard data format long before JSON became widespread, and they still rely on XML for data exchange. As a result, there's still a real-world need to convert CSV to XML when integrating with these systems.

XML tag names must follow naming rules, such as not starting with a digit and not containing certain symbols. If a header name violates these rules (for example, a column name starting with a digit, or one containing spaces or symbols), it can't be parsed as valid XML. In that case, this tool automatically falls back to a safe tag name like `column1`, `column2`, and so on.

They all use the same CSV parsing logic but produce different output formats. We offer a series of CSV conversion tools — JSON, SQL, Markdown, HTML, and XML — so you can pick the output format that best matches your destination system or use case.

This tool automatically escapes XML special characters such as &, <, and > into character entity references (&amp;, &lt;, &gt;) before output, so even if your cell values contain these characters, the result is generated as valid, parseable XML.
Tool-kun

Side Note — Why XML Came to Be Called "Verbose"

XML (Extensible Markup Language) was standardized by the W3C in 1998, and by the early 2000s it held an overwhelming position in the web industry as "the standard format for exchanging data between systems." It was used everywhere — from communication protocols like SOAP and XML-RPC, to RSS and Atom feed syndication, to configuration files such as Maven's pom.xml.

However, because XML requires an explicit opening and closing tag for every element, it tends to produce larger data sizes than JSON (which became popular from the mid-2000s onward) when representing the same data, earning it a reputation as "verbose." For instance, the JSON `{"name":"Alice"}` corresponds to XML like <name>Alice</name>, where the tags themselves can easily take up more characters than the actual data.

Even so, XML offers a mature set of specifications that JSON lacks, including strict type and structure validation via XML Schema, collision avoidance through namespaces, and transformation via XSLT. This rich validation and transformation ecosystem is one reason XML continues to be chosen for mission-critical system integration in finance, healthcare, and government today.

Read related trivia

Browse all trivia

People who viewed this tool also viewed

CSV Viewer | Open and View CSV Files as a Table (Free, No Upload)

Open and instantly view any CSV file as a formatted table right in your browser — no upload, no installation, no sign-up. Choose the character encoding and delimiter, and your file never leaves your device.

Convert JSON to CSV

Convert array of object in JSON format to CSV.

CSV to JSON Converter

Convert a CSV file into a JSON array of objects. Choose the delimiter and whether the first row is a header, then copy or download the result. Everything runs in your browser — nothing is sent to a server.

CSV to SQL Converter (INSERT Statement Generator)

Convert CSV files into SQL INSERT and CREATE TABLE statements. Supports MySQL, PostgreSQL, and SQLite dialects with automatic column type detection (integer, decimal, string). Conversion runs entirely in your browser; no...

CSV to Markdown Table Converter

Convert CSV files into Markdown table syntax (`| col1 | col2 |`). Choose the delimiter, whether to use the first line as a header, and column alignment (left, center, right). The result can be copied or downloaded. Conve...

Markdown Table to CSV Converter

Convert a Markdown table (`| col1 | col2 |`) into CSV or TSV. Handy for pulling tables exported from GitHub Wiki, Notion, or Confluence into Excel or a spreadsheet. Conversion runs entirely in your browser; no data is se...