A tidier table, a useful format

CSV Cleaner & Converter

Tidy up a table without rebuilding it by hand. Trim extra spaces, remove blank or duplicate rows, and convert CSV data to CSV, TSV or JSON with a preview before you export.

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.

Use CSV for comma-separated data, TSV for tab-separated data, or JSON for an application. JSON arrays preserve every row, including a selected header. JSON objects use your header names as keys and require a unique, nonempty name for each column.

Values stay as strings here, including leading zeros, dates and long IDs. A spreadsheet may still change them when opening CSV or TSV; use its text-import options to 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.

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