CSV and Data Tools
Six tools for the jobs that come up whenever you work with exported data: tidying a messy CSV, combining or splitting files, removing duplicates, and moving between CSV and JSON. Files are parsed in your browser, up to 50MB each.
Fix and reshape CSV files
Start with the cleaner if a file came from a spreadsheet export or another system — the other tools work best on tidy input.
CSV Cleaner
Removes empty rows and columns, trims whitespace and flags malformed rows. Output: a cleaned CSV.CSV Deduplicator
Removes rows that match exactly, comparing whole rows or only the columns you pick. Shows how many rows were removed. No fuzzy matching.CSV Merger
Combines several CSVs into one, matching columns by header name. Columns missing from a file are left empty for its rows.CSV Splitter
Splits one CSV by rows per file or number of files. Every part keeps the header row; several parts download as a ZIP.Convert between CSV and JSON
For moving data between spreadsheets and APIs or code.
CSV or JSON?
CSV suits flat tables that people open in spreadsheets. JSON suits nested data and APIs. Converting nested JSON to CSV always means flattening, so check the column names in the preview before you rely on the output.
Large files
Files over 2MB are parsed in a background Web Worker so the page stays responsive. The 50MB limit per file keeps memory use reasonable on typical laptops and phones.
Working with JSON directly
To check or tidy JSON before converting it, use the JSON Formatter. To switch between JSON and YAML, use the Format Converter.