CSV (Comma-Separated Values) is a simple file format used to store tabular data. This tool converts XML data to RFC 4180 compliant CSV with customizable delimiters, quote characters, and line endings.

Features

Multiple Delimiters: Comma, semicolon, tab, pipe, or custom character
RFC 4180 Compliant: Proper escaping and quoting of special characters
Custom Quote Character: Choose your preferred quote character
Line Endings: Support for both Unix (LF) and Windows (CRLF) line endings
Header Row: Optional header row with field names
Proper Escaping: Handles commas, quotes, and newlines in data

Delimiter Options

Comma (,) - Standard CSV format
Semicolon (;) - Common in European locales
Tab (\t) - Tab-separated values (TSV)
Pipe (|) - Alternative delimiter
Custom - Any single character

RFC 4180 Compliance

This tool follows RFC 4180 standards for CSV formatting:

Fields containing delimiters are quoted
Fields containing quotes are quoted, with quotes doubled
Fields containing line breaks are quoted
Optional header row as first line
Consistent line endings throughout file

Example

Input XML:

<products>
  <product>
    <name>Laptop</name>
    <price>999.99</price>
  </product>
</products>

Output CSV:

name,price
Laptop,999.99

Use Cases

Excel and Google Sheets import
Database bulk imports
Data analysis and reporting
ETL (Extract, Transform, Load) pipelines
Data migration between systems
Machine learning datasets

FAQ

What XML structure does this tool expect?: The converter expects a root element that contains repeating child elements (rows). Each child element should contain child elements that act as columns. Attributes on those elements are also supported and become additional columns.
How are special characters handled in CSV?: Values that contain delimiters, quotes, or newlines are automatically quoted according to RFC 4180. Quote characters inside fields are doubled so that most CSV readers (including Excel) can import them correctly.
Why do I see an error instead of CSV output?: If the XML cannot be parsed, or if the tool cannot detect a repeating table-like structure, an error message is shown instead of CSV. Make sure your XML is well-formed and that it contains multiple similar child elements under a single root.
Can I change the delimiter later in Excel?: Yes. Many spreadsheet tools let you choose the delimiter at import time. However, generating CSV with your preferred delimiter here usually makes import simpler and more reliable.