CSV to XML Converter

Many systems — older web services, accounting and ERP imports, product feeds — accept XML but not CSV. Paste CSV, TSV or cells copied from Excel and get well-formed XML: each row becomes an element named as you choose, and each column becomes a child element or an attribute named after its header. Header names are turned into valid XML names, and every value is escaped so ampersands, angle brackets and quotes cannot break the document.

How to use this tool

1. Paste the data with the column names in the first row.
2. Name the root element and the row element.
3. Choose child elements or attributes for the columns, and what happens to empty cells.
4. Pick the indentation and whether to include the XML declaration.
5. Copy the XML.

Formula

<root> → one <row> per data row → one <column>value</column> (or column="value") per cell

XML names cannot contain spaces or most punctuation, cannot start with a digit, and names beginning with "xml" are reserved, so headers are adjusted: spaces and other characters become _, a leading digit or "xml" gets an _ in front, and duplicates are numbered. Text escapes & < >; attribute values also escape " and line breaks (&#10;) so they survive attribute-value normalization. Control characters XML 1.0 forbids are removed.

Example

The sample customer list becomes <customers> with three <customer> elements. The second one contains <name>O'Brien &amp; Sons</name> — the & is escaped — and the third has an empty <email/> because Lin has no address. With "Attributes" the first row becomes <customer id="1" name="Ada Lovelace" email="ada@example.com" joined="2024-02-29"/>.