CSV & tables

Clean, reshape, and convert tabular data.

CSV column picker

Select CSV columns and rearrange their export order with a live table preview.

Remove duplicate CSV rows

Remove duplicate CSV rows using selected key columns while keeping the first or last match.

Filter CSV rows

Keep CSV rows matching a text or numeric condition and preview the matching rows immediately.

Sort CSV

Sort CSV rows by text or numbers, with clickable column headings and a live table preview.

CSV to JSON

Convert CSV rows into JSON objects or arrays with explicit headers and optional value conversion.

Transpose CSV

Swap CSV rows and columns, with optional header inclusion and a live shape preview.

Spreadsheet editor

Edit CSV and Excel workbooks locally in a full browser spreadsheet with formulas, sheets and formatting.

JSON to CSV

Convert JSON objects, rows or primitive arrays into CSV with a live table preview.

Select columns, remove duplicates, filter rows, sort, transpose, and convert to and from JSON, with a full spreadsheet editor for CSV and Excel workbooks. The workspace previews live and exports exactly what you see.

Files are processed in the browser, and the limits are explicit: 10,000 rows, 100 columns, and bounded export sizes.

A typical cleanup workflow

Most CSV work follows the same path. Open the file in the spreadsheet editor to see what you are dealing with. Keep only the columns you need with the column picker. Remove duplicate rows by a key column such as email. Filter to the rows that matter. Sort for readability. Each tool previews the result live and exports exactly what you see, and the output of one step can be pasted straight into the next.

For moving data between systems, CSV to JSON and JSON to CSV handle the conversion with explicit rules for headers, empty cells, nested values, and types. Transpose swaps rows and columns when a report is laid out the wrong way for charting or import.

CSV pitfalls to watch for

CSV looks simple, but real files break simple tools. Fields that contain commas, quotes, or line breaks must be quoted. European exports often use semicolons, because the comma is the decimal separator. Files saved from Excel may start with an invisible byte-order mark. All the CSV tools parse quoted fields correctly and let you choose the delimiter.

Spreadsheet programs also change data when opening CSV files: they drop leading zeros from postal codes and IDs, turn long numbers into scientific notation, and convert text like 3-4 into dates. Inspecting and cleaning the file here first, then importing it with explicit column types, avoids those silent changes. When exporting CSV that others will open in Excel, enable formula escaping to prevent CSV injection.