Data & Formats

CSV & TSV tools

An export from a spreadsheet or database rarely arrives in the shape you need — wrong delimiter, duplicate rows, or a whole different format entirely. These tools handle the everyday CSV and TSV work: editing cells directly, cleaning and deduplicating rows, converting to JSON, SQL inserts or a Markdown table, joining two files by a shared column, and splitting large exports into smaller pieces.

CSV / TSV editor preserves leading zeros and exact cell values instead of treating everything as a number, which matters for ZIP codes and IDs. CSV cleaner shows each cleaning step before you apply it, so you can undo a bad filter before it touches the whole file. CSV join works by matching key column or by simple append, and CSV split can divide files by record count, file size or a column value.

10 tools

Edit and clean CSV

Convert CSV to other formats

Join and split CSV files

CSV / TSV Tabular Data tools FAQ

How do I keep leading zeros when editing a CSV file?

Most spreadsheet apps strip leading zeros because they treat every column as a number. CSV / TSV editor keeps cell values as text by default, so ZIP codes, phone extensions and IDs like 00042 print back exactly as entered instead of turning into 42.

What's the easiest way to turn CSV data into SQL insert statements?

JSON to SQL accepts CSV directly and generates INSERT statements for a table you name, using your header row as column names. It's faster than writing INSERT syntax by hand for anything more than a few rows, and works the same way for JSON input.

How do I join two CSV files that share a column?

CSV join matches rows between two files by a key column you choose, similar to a SQL join, or appends one file's rows to another when the column names already match. Preview the result before exporting, since mismatched key formatting between the two files is the most common cause of missing matches.