CSV Editor

Editing a CSV without breaking it

A CSV is a text file, so the obvious move is to open it in a text editor — and the obvious move is where CSVs go wrong. Miss a quote around a field that contains a comma and every column after it shifts by one. Open it in Excel instead and it helpfully turns 00123 into 123 and 3-1 into a date, then saves that back over your file.

This editor shows the file as a grid, so columns stay columns, and writes it back with the quoting rules applied properly. Values that are already text stay text; nothing is silently reinterpreted.

What you can do

• Fix cells directly, with full keyboard navigation and undo.
• Insert and delete rows and columns, and reorder data by sorting a column.
• Find and replace across the whole file, not one match at a time.
• Paste in a block from Excel or Google Sheets and have it land as a grid.
• Use spreadsheet formulas while you work; they save as their calculated values.
• Download as CSV, or as .xlsx if you would rather keep the formulas.

How to edit a CSV file online

1. Open the CSV — Drag a .csv or .tsv file onto the page. The delimiter is detected automatically and the file opens straight away, with nothing uploaded.
2. Edit it in the grid — Click a cell and type. Insert and delete rows and columns, sort a column, use find and replace across the file, and undo anything with Ctrl+Z.
3. Download the CSV — Press Ctrl+S or click Download .csv. Quoting and encoding are handled for you, so the file opens cleanly in Excel, a database import, or whatever consumes it next.

Delimiters, encodings and line endings

Comma, semicolon and tab separated files are all detected when they open, so an export from a European system loads with its columns in the right place. Downloads are written as UTF-8 with CRLF line endings and comma separators — the combination that opens cleanly in Excel on both Windows and macOS, and that most database import tools expect. Fields containing a comma, a quote or a line break are quoted and escaped for you.