A tidier table, a useful format

CSV Cleaner & Converter

Prepare a table for its next destination. Clean up rows, keep the columns you need, rename headers and set their order, then preview your CSV, TSV or JSON before exporting.

Start with your data

Paste or upload a table.

CSV or delimited textUTF-8 text, up to 2 MiB. Quoted separators, line breaks and escaped quotes are supported. Uploaded files replace the text above.

Keep the changes intentional

Choose your cleanup.

Input separatorIf more than one separator fits, choose one explicitly.

First row contains headers

Optional changesTrim spaces around valuesIncludes headers; keeps spaces inside each value.Remove blank rowsRemoves data rows containing only empty values or whitespace.Remove duplicate rowsMatches every cell after trimming, when selected. Keeps the first occurrence.

Numbers, dates and IDs stay as text. Nothing is trimmed or removed until you select that option.

Keep your data predictable

Small changes, clearly counted.

Choose only the cleanup your file needs. Trimming removes whitespace around values and headers. Duplicate removal compares every cell, keeps the first matching row and preserves the order of the remaining rows. Header names are never silently renamed.

After cleanup, choose the columns to keep, rename their headers and set their order. Reset columns restores the original selection, names and order. Excluding a column does not remove any more rows, even when two rows then look identical.

Export comma, tab, semicolon or pipe-separated text, or JSON for an application. JSON arrays preserve every prepared row, including a selected header. JSON objects use your header names as keys and require a unique, nonempty name for each included column.

Values stay as strings here, including leading zeros, dates and long IDs. A spreadsheet may still change them when opening delimited text; use its text-import options to control column types. The optional UTF-8 BOM helps Excel recognize Unicode text, but does not control column types. Quoted tabs or line breaks also depend on the receiving application's import support.

Processing stays in this browser tab. Files and pasted data are not uploaded or saved by this tool. Work with up to 2 MiB of UTF-8 input, 10,000 data rows, 100 columns and 200,000 cells including headers. Exports are limited to 8 MiB. Excel workbooks, compressed files and JSON input are not supported.

Follow a worked CSV cleanup with downloadable examples.

CSV format reference ↗ · Spreadsheet formula guidance ↗ · How these tools work