How to Convert CSV to XML (Online and With Code)

Why Convert CSV to XML?

CSV is how analysts and spreadsheets store tabular data. Many enterprise systems still expect XML imports—product catalogs, EDI-style feeds, government portals, and legacy ERP modules. Converting CSV to XML bridges those worlds without rewriting the source spreadsheet.

What Good CSV → XML Looks Like

A clean conversion maps each CSV row to a repeating record element under a single root. Column headers become child element names (or attributes). Cell values become text content. Special characters must be escaped so the XML stays well-formed.

<?xml version="1.0" encoding="UTF-8"?>
<records>
  <record>
    <order_id>1001</order_id>
    <email>ada@example.com</email>
    <amount>42.50</amount>
  </record>
  <record>
    <order_id>1002</order_id>
    <email>grace@example.com</email>
    <amount>19.00</amount>
  </record>
</records>

Step-by-Step: In the Browser

The fastest path for one-off jobs.

• Clean the CSV in the Online CSV Editor (headers, blank rows, encoding).
• Open the CSV to XML Converter.
• Upload or paste the CSV.
• Confirm the root and record element names if the tool exposes them.
• Download the .xml and open it in a text editor to spot-check structure.

Step-by-Step: With Python

ElementTree builds well-formed XML from DictReader rows.

import csv
import xml.etree.ElementTree as ET

root = ET.Element("records")

with open("orders.csv", newline="", encoding="utf-8") as f:
    for row in csv.DictReader(f):
        record = ET.SubElement(root, "record")
        for key, value in row.items():
            child = ET.SubElement(record, key)
            child.text = value or ""

tree = ET.ElementTree(root)
tree.write("orders.xml", encoding="utf-8", xml_declaration=True)

ET.indent(tree, space="  ")
tree.write("orders.xml", encoding="utf-8", xml_declaration=True)

Step-by-Step: With Node.js

Parse CSV, then build XML with a small builder or template.

import fs from "node:fs";
import { parse } from "csv-parse/sync";

const rows = parse(fs.readFileSync("orders.csv", "utf8"), {
  columns: true,
  skip_empty_lines: true,
  bom: true,
});

const escape = (s) =>
  String(s)
    .replace(/&/g, "&")
    .replace(/</g, "&lt;")
    .replace(/>/g, "&gt;")
    .replace(/"/g, "&quot;");

const body = rows
  .map((row) => {
    const fields = Object.entries(row)
      .map(([k, v]) => `    <${k}>${escape(v ?? "")}</${k}>`)
      .join("\n");
    return `  <record>\n${fields}\n  </record>`;
  })
  .join("\n");

fs.writeFileSync(
  "orders.xml",
  `<?xml version="1.0" encoding="UTF-8"?>\n<records>\n${body}\n</records>\n`,
);

Elements vs Attributes

Both are valid. Elements are easier to scan and extend. Attributes work well for short identifiers (id, sku, qty) when a partner schema demands them.

Escaping and Encoding

Invalid XML is worse than ugly XML. Escape &, <, >, and quotes in text. Use UTF-8 with an XML declaration. Strip or replace characters that are illegal in element names.

• & → &amp;
• < → &lt;
• > → &gt;
• " → &quot; (in attributes)
• ' → &apos; (in attributes)

Real-World Examples

Where CSV → XML shows up weekly.

Common Mistakes

These break partner imports more often than anything else.

• Leaving spaces or special characters in column headers used as element names.
• Forgetting to escape &, <, and > in cell values.
• Mixing encodings so non-ASCII names corrupt.
• Generating one giant document when the partner expects one file per batch size limit.
• Skipping XSD validation after conversion.

Best Practices

Small habits keep feeds accepted.

• Normalize headers to valid XML names first.
• Always declare encoding="UTF-8".
• Escape text content and attributes.
• Match the partner’s root and record element names exactly.
• Validate against XSD before upload when a schema exists.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Clean the table in the Online CSV Editor, convert with CSV to XML, and reverse-check with XML to CSV if you need a spreadsheet preview. Client-side workflows work on Windows, macOS, and Linux browsers.

Conclusion

CSV to XML is a naming, escaping, and structure problem—not a mystery. Clean headers, escape content, match the partner schema, and validate before you upload.