Edit CSV files in a table, not a text editor
A CSV file is easy to break in a plain text editor: one missing quote around “Rossi, Mia” and every column after it shifts. This online CSV editor reads the file properly, shows it as a grid, and writes valid CSV back out, quoting fields only where needed. It runs in your browser, so the file is not uploaded, and there is nothing to install.
Opening CSV and TSV files
- Delimiter: comma, semicolon, tab and pipe are detected automatically. If a file is read the wrong way, pick the delimiter under Read as and it is read again.
- Encoding: UTF-8 with or without a BOM and UTF-16 with a BOM are recognised; a file that is not valid UTF-8 is read as Windows-1252, which is what older Excel exports use.
- Quoted fields with commas, double quotes (
"") and line breaks inside a cell are kept as one cell. - Rows shorter than the widest row are padded with empty cells, and the editor tells you if quotes are unbalanced.
Keyboard editing
The table works like a spreadsheet:
| Key | Action |
|---|---|
| Arrow keys, Home, End | Move between cells (Ctrl+Home / Ctrl+End jump to the first or last row) |
| Enter or F2, or just type | Edit the cell; typing replaces its content |
| Enter / Tab | Save and move down / right |
| Shift+Enter | New line inside the cell |
| Esc | Cancel the edit |
| Delete | Clear the cell |
| Ctrl+Z, Ctrl+Y | Undo and redo |
Tick or untick First row is a header to decide whether the first row holds column names. Header cells are edited the same way as other cells.
Rows, columns, sorting and filtering
The toolbar inserts a row above or below the selected one, moves it up or down, and deletes it; columns can be inserted left or right, moved and deleted the same way. Sorting looks at the whole column: if every non-empty value is a number (including 1,234.50, $12 or 15%), it sorts by value, so 9 comes before 10. Otherwise it sorts text in natural order, ignoring case, so “file2” comes before “file10”. Empty cells always go last, and a second click on the header arrow reverses the order.
The filter box shows only rows that contain your text, in any column or in one you choose. Edits, find and replace, and exports can then work on just those rows.
Find and replace
Find next walks through matching cells, Replace changes the current one, and Replace all changes every match in the visible rows in one step that a single Undo reverses. Options: Match case, Whole cell (the cell must equal the search text) and Regex, where $1 in the replacement inserts a captured group. For example, find ^(\d{4})-(\d{2})-(\d{2})$ and replace with $3/$2/$1 to turn 2026-03-14 into 14/03/2026.
Large files and undo
Big files are shown one page at a time (50 to 500 rows per page), so tens of thousands of rows stay responsive; arrow keys move across page boundaries. Every change, including a sort or a replace all, can be undone, up to the last 300 steps. If you try to load another file while you have unsaved edits, the editor asks first, and even after you confirm, Undo brings the edited table back. It also warns before you leave the page with unsaved edits.
Saving your CSV
Choose comma, semicolon, tab or pipe as the delimiter and how fields are quoted: only when needed, every field, or everything except numbers. Tick UTF-8 BOM if Excel shows accented letters incorrectly. Rows end with CRLF line breaks, the CSV standard. Values are written exactly as they appear, so leading zeros, dates and long numbers are not changed. Download as CSV or TSV, or copy the text.
To just look at a file, the CSV viewer is lighter. Related tools: merge CSV files, split a large CSV and convert CSV to JSON.