CSV Editor
Open a CSV in a real spreadsheet grid, fix what you need, and save it back as a clean CSV. No signup, and the file never leaves your browser.
Drop your file here or click to upload
Supports .csv, .tsv, .txt, .xlsx · up to 50MB · or paste a file from your clipboard
Only need to read the file? Open it in the CSV Viewer.
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
- 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.
- 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.
- 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.
If CSV is your main format, CSVTool is our dedicated CSV suite — 45+ viewers, editors, and converters that also run entirely in your browser.
Frequently Asked Questions
No. The file is read, edited and written back by JavaScript in your own browser. There is no upload and no server copy — which is why it also works on networks that block file-upload sites. Turn your wi-fi off after the page loads and you can carry on editing.
No. Fields containing commas, quotes or line breaks are re-quoted correctly on save, and the file is written with standard CRLF line endings and UTF-8 encoding. Text that looks like a number but must stay text — a leading-zero product code, for instance — is left as text rather than silently converted.
Yes, while you are editing. The grid includes 169 spreadsheet functions, so you can add a SUM or an IF to work something out. CSV has no way to store a formula, so on download each formula is written as its calculated value — which is what a CSV consumer expects. Download as .xlsx instead if you want the formulas kept.
There is no imposed limit; the practical ceiling is your device's memory. The grid only renders the rows on screen, so a file with tens of thousands of rows scrolls smoothly. Very large files are slower to open because the whole file is parsed up front.
Yes. The delimiter is detected when the file opens, so European semicolon-separated exports and .tsv files load correctly. Downloads are written as standard comma-separated CSV.
The file is saved into this browser's local storage as you edit, on your device only. Return to this page and it offers to pick up where you left off.