About the CSV to XML Converter
Every CSV row becomes one row element, and every column becomes a child element named after the header, so city,country produces <row><city>Lisbon</city><country>PT</country></row>. You choose the root and row element names to match the schema the receiving system expects. Header names that are not valid XML names are made safe by replacing invalid characters with underscores.
Text is escaped, so ampersands, angle brackets and quotes in cells cannot break the document, and the result starts with an XML declaration. Empty cells become empty elements rather than being dropped, which keeps every row the same shape.
Attributes are not generated because a CSV column carries no hint about whether it should be an attribute. If you need attributes, convert and then restructure in the XML Formatter. For the reverse direction use XML to CSV.
How to use
- Paste or upload the CSV.
- Set the root and row element names.
- Copy the XML or download it.
Common questions
- Can headers with spaces be used as element names?
- Spaces are replaced with underscores so the element names are valid.
- Are values typed?
- XML has no types; every value is text content, written exactly as it appeared in the cell.
- What if the CSV has no header row?
- Untick the header option and the columns are named column1, column2, and so on.