18 tools
CSV Tools and Converters
CSV is the format every spreadsheet, database and analytics tool can read, which is why data keeps arriving in it. It is a row per line and fields separated by commas, until a field contains a comma, a quote or a newline, at which point the quoting rules of RFC 4180 apply and naive parsing breaks.
Those cases are not rare. Address fields contain commas, description fields contain newlines, and any field with an apostrophe eventually meets a tool that escapes quotes differently. Splitting on commas works on sample data and corrupts real exports.
CSV has no intrinsic value types or schema. Turning fields into JSON numbers or booleans requires inference, so identifiers and leading zeros need care. RFC 4180 describes an optional header row, not a mandatory one: choose whether the first row contains column names before converting. Producer-specific delimiters, encodings and quoting conventions still need to be checked.
CSV tools
Converters
- CSV to JSON
Turn a CSV table into a JSON array of objects.
- JSON to CSV
Turn JSON records into a spreadsheet-ready CSV table.
- CSV to TSV
Switch a CSV file to tab separators.
- TSV to CSV
Turn tab-separated data into properly quoted CSV.
- CSV Delimiter Converter
Switch a CSV file between comma, semicolon, tab and pipe.
- CSV to XML
Turn CSV rows into XML elements.
- CSV to YAML
Turn CSV rows into a YAML list of records.
- Markdown Table to CSV
Turn a Markdown table into CSV.
- XML to CSV
Extract a table from repeated XML elements.
- YAML to CSV
Flatten a YAML list into a CSV table.
Formatters
- CSV Formatter
Clean up and normalise a CSV file.
- CSV Column Extractor
Select, reorder or drop CSV columns.
- CSV Deduplicator
Remove duplicate rows from a CSV file.
- CSV Row Filter
Keep only the CSV rows matching a condition.
- CSV Sorter
Sort CSV rows by a chosen column.
- CSV Transposer
Swap rows and columns in a CSV file.
Working with CSV
Practical guides for the tools above, including the checks to make before relying on the result.
- How to convert CSV to JSON
Convert CSV to JSON reliably: trimmed headers, type inference, empty cells, quoted fields, ragged rows and why dotted column names stay flat.
- How to convert JSON to CSV
Convert JSON to CSV correctly: flattening nested objects, handling arrays and missing keys, choosing a delimiter, and the cases where CSV cannot represent the data.
- How to review CSV to SQL INSERT statements
Generate and review CSV-to-SQL INSERT statements: headers, inference, NULL, booleans, dialect-specific identifier quoting, and MySQL escaping limits.
Worth understanding first
The concepts that come up most often when working with CSV.