🔄 CSV to XML Converter: Turn Spreadsheet Rows into Valid XML
By Shihab Mia · Updated 2026-08-01
Paste CSV above, then press Convert to XML.
This CSV to XML converter turns comma-separated rows into well-formed, pretty-printed XML in a single click, entirely inside your browser. Paste a CSV with a header row, and each column name becomes an XML tag while each data row becomes a repeated element, with special characters escaped automatically so the output is always valid. It handles quoted fields, embedded commas, and messy header names without any setup, and nothing you paste ever leaves your device.
What is the CSV to XML Converter?
A CSV to XML converter takes flat, comma-separated data and reshapes it into a tree of nested elements, which is the format many legacy systems, SOAP APIs, RSS-adjacent feeds, and enterprise data pipelines still expect. Where a CSV row is just a line of values separated by commas, an XML row becomes a self-describing block: an opening item tag, one child element per column carrying that column's header as its own tag name, and a closing item tag. This tool reads the first line of your CSV as the header, and every column in every row after that gets wrapped in a matching child tag, so the structure of the spreadsheet is preserved rather than flattened into a single blob of text.
The conversion logic has to solve a few problems that a naive split-on-comma approach cannot. First, CSV fields can contain commas inside quotes, so "Lovelace, Ada" has to be read as one field, not two. This converter parses character by character, tracking whether it is inside a quoted field, so embedded commas, doubled quote escapes, and both CRLF and LF line endings are all handled correctly before anything is turned into XML. Second, not every CSV header is a legal XML tag name. XML element names cannot start with a digit, cannot contain spaces, and cannot contain most punctuation. So when you convert CSV to XML with this tool, any header like "2024 Sales" or "unit price" is sanitized: spaces and invalid characters become underscores, and a name that starts with a digit gets a "col" prefix, giving you 2024_Sales becoming col2024_Sales and unit price becoming unit_price, both valid immediately.
The third problem is escaping. XML treats five characters as structurally significant: ampersand, less-than, greater-than, double quote, and single quote. If a cell in your CSV contains any of these, for example a company name like "Smith & Sons" or a note with a stray less-than sign, dropping that text straight into an XML tag would produce broken, unparseable markup. This CSV to XML converter escapes every value automatically, turning & into &, < into <, and so on, so the resulting XML is always well-formed no matter what your source data contains. The output is also pretty-printed with two-space indentation by convention, one item block per row, because readable XML is easier to diff, debug, and hand off to another engineer than a single unbroken line.
People reach for a csv to xml converter most often when moving data between systems that speak different formats: exporting a spreadsheet report into an XML feed a partner API expects, converting a product catalog CSV into the XML structure an old e-commerce platform requires, or preparing test fixtures for an XML-based integration test. Because this tool runs entirely client-side, with no upload and no server round trip, it is also a reasonable choice for CSV that contains sensitive or internal data you do not want to send to a third-party service just to reformat it.
When to use it
- Exporting a product or inventory CSV into the XML format a legacy e-commerce or ERP system expects for import.
- Converting a spreadsheet report into an XML feed for a partner API, SOAP endpoint, or B2B data exchange.
- Preparing XML test fixtures or sample data for an integration test suite from a quick CSV you typed by hand.
- Migrating configuration or reference data out of a spreadsheet and into an XML-based application config file.
How to use the CSV to XML Converter
- Paste your CSV into the input box. The first row should be the column headers (name, age, city, and so on).
- Set the root element name and the per-row element name if you want something other than the defaults, items and item.
- Leave "First row is a header" checked so column names become XML tags, or uncheck it to auto-name columns col1, col2, and so on.
- Press Convert to XML, then copy the result or press Download .xml to save it as a file.
Formula & method
Worked examples
A 3-row CSV with a header, one quoted field containing a comma, and an ampersand in a value.
- Input: name,role\nAda,"Engineer, Lead"\nSmith & Sons,Vendor
- The header row becomes column tags: name and role, both already valid XML names.
- Row 1 field "Engineer, Lead" is parsed as one field because it is quoted, so the embedded comma is preserved rather than splitting the row.
- Row 2 field "Smith & Sons" is escaped so & becomes & inside the XML tag.
- The converter wraps both rows in <item> elements inside a single <items> root.
Result: The output is <items><item><name>Ada</name><role>Engineer, Lead</role></item><item><name>Smith & Sons</name><role>Vendor</role></item></items>, pretty-printed with 2-space indentation.
A CSV where one header starts with a digit and another has a space, converted with default settings.
- Input header row: 2024 Sales,unit price
- sanitize("2024 Sales") first replaces the space with an underscore, giving 2024_Sales, then sees it starts with a digit and prefixes it, giving col2024_Sales.
- sanitize("unit price") replaces the space with an underscore, giving unit_price, which is already a valid first character so no prefix is added.
- Every data row now uses <col2024_Sales> and <unit_price> as its child tags.
Result: Both originally invalid headers become legal, parseable XML tag names without losing which column they came from.
XML characters that must be escaped, and what they become
| Character | Meaning in XML | Escaped as |
|---|---|---|
| & | Starts an entity reference | & |
| < | Opens a tag | < |
| > | Closes a tag | > |
| " | Delimits attribute values | " |
| ' | Delimits attribute values | ' |
How this converter handles common header problems
| Header as typed | Problem | Sanitized XML tag |
|---|---|---|
| 2024 Sales | Starts with a digit and has a space | col2024_Sales |
| unit price | Contains a space | unit_price |
| % change | Starts with punctuation and has a space | __change |
| (blank) | Empty header cell | col3 (col + column position) |
| name | Duplicate header appears twice | name, then name_2 |
Common mistakes to avoid
- Forgetting the header row is required by default. With "First row is a header" checked, the converter treats your first line as column names, not data. If your CSV has no header, uncheck that box first, otherwise your first real data row will vanish into the tag names instead of appearing as an item.
- Leaving a quoted field unclosed. A stray, unmatched double quote in a CSV field (an odd total count of quote characters) breaks the parser's notion of where a field starts and ends. The tool flags this with a friendly error instead of guessing, so check for a missing closing quote around any field with a comma or quote inside it.
- Assuming special characters will just work. Values containing &, <, >, or quote characters are not valid inside XML text as-is. This converter escapes them automatically, so the raw output will show & where your CSV had a plain &. That is correct XML, not a bug, and any XML parser will read it back as the original character.
- Expecting duplicate or reused column names to collide silently. If two columns share the same header text, using them unmodified would produce two same-named child tags per row with no way to tell which value belongs to which column. The converter appends _2, _3, and so on to repeats so every column keeps a distinct, addressable tag.
Glossary
- CSV
- Comma-separated values, a plain-text format where each line is a row and commas separate the columns, optionally with quoted fields for values that contain a comma.
- XML
- Extensible Markup Language, a text format that represents data as nested elements with opening and closing tags, used widely in enterprise data exchange and legacy APIs.
- Element (tag)
- An XML building block written as <name>value</name>; in this converter, one element is created per CSV column inside each row's item element.
- Root element
- The single outermost element that wraps an entire XML document; every other element is nested inside it. This tool defaults to <items>.
- Escaping
- Replacing characters that have special meaning in XML (like & or <) with a safe entity reference so the text is not mistaken for markup.
- Well-formed XML
- XML that follows the syntax rules exactly: every tag is closed, names are valid, and special characters are escaped, so any standard XML parser can read it without error.
Frequently asked questions
How does this tool decide the XML tag name for each column?
It takes each header cell from your CSV's first row, replaces spaces and invalid characters with underscores, and adds a "col" prefix if the result would start with a digit. Duplicate headers get a numeric suffix so every tag stays unique.
Will special characters like & or < break the XML output?
No. Every value is escaped before it is placed inside a tag, so an ampersand becomes & and a less-than sign becomes <. The result is always valid, parseable XML regardless of what characters your CSV contains.
Can I convert a CSV that has no header row?
Yes. Uncheck "First row is a header" and the converter will name columns col1, col2, col3, and so on automatically, treating every row including the first as data.
Does this csv to xml converter upload my data anywhere?
No. All parsing and conversion happens locally in your browser using JavaScript. Nothing you paste is sent to a server, which makes it safe for internal or sensitive spreadsheets.
What happens if a CSV cell is empty?
An empty cell becomes a self-closing XML element, like <notes />, rather than an empty pair of tags. This is standard, valid XML and clearly signals that the field had no value.
Can I rename the root and row elements?
Yes. The Root element field controls the outer wrapper (items by default) and the Row element field controls the tag repeated for every data row (item by default). Both are sanitized the same way as column headers.