CSV Editor

A table editor for CSV files — right in the browser

The CSV Editor opens, edits, and exports CSV files in a full spreadsheet interface. You load a file, click through the cells like in a spreadsheet, and save the result back out as CSV or JSON. The catch nobody minds: the delimiter is detected automatically, and none of it ever leaves your browser.

CSV sounds simple but rarely is in practice. Sometimes a comma separates fields, sometimes a semicolon (typical for German Excel exports), sometimes a tab. Fields with commas sit inside quotes, quotes get doubled, and in the end nobody knows what the file is actually built with. The CSV Editor takes the guessing off your hands: it detects the delimiter, parses the file cleanly per RFC 4180, and lays the result out as an editable table.

The tool is built for everyone who handles CSV files occasionally or regularly: developers who want to inspect a dataset quickly or convert it to JSON; editorial and marketing people who need to fix an export from a shop or newsletter tool; and anyone who just wants to make a foreign, "broken" CSV file readable again. No account, no installation, no upload to someone else's server.

Import: file, drag-and-drop, or clipboard

There are three ways to get data in:

Open brings up the file dialog (accepts .csv, .tsv, and .txt).
Drag-and-drop: pull a file straight onto the editor area.
Paste reads tabular data from the clipboard — handy for dropping in a selection from Excel, Google Sheets, or Numbers.

All three use the same delimiter detection and the same parser. If First row is header is enabled in Settings, the first row becomes the column headers instead of a data row.

The table editor

The table itself is a full spreadsheet editor (built on Jspreadsheet CE). You can edit cells directly; insert, delete, move, and resize rows and columns; rename columns; and sort by column. A right-click opens a context menu with the relevant actions, Undo and Redo (also via Ctrl+Z / Ctrl+Y) step back and forward, and a Transpose function swaps rows and columns. A search box filters the table live, and a fullscreen mode hides everything but the editor.

The status bar below the table shows the current size (rows × columns), the active cell, and — for a multi-cell selection of numeric cells — automatic sum, average, and count.

Automatic delimiter detection

By default the delimiter is set to Auto-detect. The editor inspects the file and picks, from comma, semicolon, tab, and pipe (|), whichever character occurs most often — delimiters inside quotes are correctly ignored. If you know the format or detection gets it wrong, set the delimiter to one of the four fixed values in Settings. That same setting also determines the delimiter used for the CSV export later.

Export: CSV, JSON, or clipboard

Three ways back out:

CSV downloads the table as data.csv — using the delimiter chosen in Settings, cleanly RFC 4180-compliant with correctly placed quotes.
JSON downloads the table as data.json. With header mode on you get an array of objects (column header as key); otherwise an array of row arrays.
Copy copies the entire table tab-separated to the clipboard — ideal for pasting straight into Excel or Google Sheets.

Everything stays in the browser

The CSV Editor is a purely client-side application: no server upload, no account, no transfer of your data. The file is read locally in the browser, edited, and downloaded again. That matters especially for CSV files, which often hold sensitive data — customer lists, orders, exports from internal systems. That data stays on your machine.

So your work survives a reload, the tool automatically saves the table to your browser's LocalStorage (and there are Store and Restore buttons too). That, too, is purely local — the storage lives in your browser, not in a cloud. Reset clears the table and the saved data again.

Try it now

→ Open the CSV Editor — load a file via Open or drop it in, edit, export as CSV or JSON. No account, free, right in the browser.

CSV is rarely the final format — these tools pick up from here:

JSON Editor — format, validate, and further reshape the data produced by the JSON export.
Convertor PRO — convert between JSON, YAML, TOML, XML, and more when CSV/JSON isn't the target.
Source Viewer — review an exported file with syntax highlighting.

There's more on the subpages: the manual with every function and option in detail, hands-on examples, and a collection of tips & tricks.