CSV Editor & Viewer
Open, fix and save CSV files in a spreadsheet grid — large files included.
Paste CSV text instead
Drafts saved in this browser
Drafts are kept in this browser only (the last 5). Delete one when you no longer need it.
Table
Sort rows
Rows are sorted by the first level, ties by the next. Empty cells go last. Undo restores the previous order.
Show only rows where
Every condition must hold. Rows you add or edit stay visible until you apply the filters again.
Find and replace
Searches the rows shown. With a regular expression, $1 inserts the first group. Replace all is one undo step.
Save
About the CSV Editor & Viewer
Open a CSV or TSV file and edit it like a spreadsheet, without the changes Excel makes behind your back: no codes losing their leading zeros, no long numbers turning into 1.23E+15, no dates rewritten. Every cell stays exactly the text in the file until you change it. The delimiter (comma, semicolon, tab, pipe) and the encoding (UTF-8, UTF-16, Windows-1252, Windows-1251, Shift_JIS, GB18030 and more) are detected, and the grid only draws the rows on screen, so files with hundreds of thousands of rows scroll smoothly.
Edit cells, add, delete and move rows and columns, sort by several columns, filter rows, and find and replace — with regular expressions if you like. Every change can be undone. Save as CSV or TSV with the delimiter, quoting, line endings and byte-order mark you need, or as an Excel workbook. While you work, a draft is saved in this browser, so closing the tab by mistake loses nothing.
How to use it
- Drop a CSV, TSV or TXT file on the box (or choose it), paste CSV text, or start a blank table. Drafts you saved before are listed under the box.
- Check the first line above the grid: rows, columns, delimiter and encoding. If the text looks wrong, open Read the file again and pick the delimiter or encoding.
- Click a cell and type to replace it, or press Enter (or double-click) to edit it; Alt+Enter adds a line break. The cell box above the grid edits the selected cell too — handy on a phone.
- Use Insert above/below, the arrows and the bin for rows and columns; Sort for one or more columns; Filter to show only matching rows; Find & replace to change many cells at once. Ctrl+Z undoes.
- Under Save, pick CSV, TSV or Excel and the options, then download. Untick Autosave a draft if you do not want a copy kept in this browser.
Examples
Name;Price Notebook;45,00 Pen;12,50
Name,Price Notebook,"45,00" Pen,"12,50"
Open the file (semicolons are detected), choose CSV with the comma delimiter under Save. Values containing a comma are quoted, as RFC 4180 requires.
City, then Amount descending
All Delhi rows first (largest amount at the top), then Pune …
Numbers sort as numbers (2 before 10), text ignores case and accents, and empty cells go last. Choose Date, day first for 28/09/2026-style dates.
Find: (\d{2})/(\d{2})/(\d{4}) Replace with: $3-$2-$128/09/2026 → 2026-09-28
Tick Regular expression. Replace all is one step, so one Ctrl+Z undoes it.
Common uses
- Fixing a few values in an export before uploading it to a bank, GST portal, CRM, marketplace or database.
- Viewing a large CSV that is slow to open, or opens wrongly, in Excel.
- Changing the delimiter or encoding of a CSV (for example semicolons to commas, Windows-1252 to UTF-8).
- Sorting and filtering a CSV to check or extract the rows you need.
- Cleaning data with find and replace before importing it elsewhere.
Why edit CSV here instead of in Excel
Excel converts CSV values as it opens them: leading zeros of PIN codes and employee numbers disappear, numbers with more than 15 digits lose their last digits, and text such as 03-04 or 1/2 becomes a date. Saving the file then writes those changed values back. This editor treats every cell as text, so a value only changes when you change it. Saving as Excel (.xlsx) turns a column into numbers only when every value in it is a number that converts exactly; codes with leading zeros, phone numbers with + and IDs longer than 15 digits stay text. In a semicolon- or tab-separated file, decimal commas such as 12,5 are recognised, and a column whose values could be read either way (1,250: 1250 or 1.25?) stays text.
Reading and writing CSV
Files are read per RFC 4180: fields may be quoted, quotes inside are doubled, and quoted fields can hold delimiters and line breaks. Line breaks may be CRLF, LF or CR, and an Excel sep=; first line is honoured. The encoding comes from a byte-order mark, the UTF-16 byte pattern or a valid UTF-8 check; other files are matched against common code pages (Windows-1250 to 1258, KOI8-R, Shift_JIS, EUC-JP, GB18030, Big5, EUC-KR), falling back to Windows-1252.
When you save, a field is quoted when it contains the delimiter, a quote, a line break or spaces at either end (or every field, or every non-number, if you choose). Files are written as UTF-8; the byte-order mark helps Excel on Windows show ₹, accents and non-Latin text. Protect against formulas puts an apostrophe before text starting with =, +, -, @, a tab or a line break (or the full-width ＝, ＋, －, ＠), as the OWASP guidance on CSV injection recommends, leaving plain numbers such as -12.5 alone.
Keyboard
- Arrows move; Shift+arrows select; Ctrl+arrows jump to the edge; Ctrl+A selects everything; PageUp/PageDown scroll. Tab and Shift+Tab move along the row; past the last (or first) column they move on to the next control, as everywhere on the page.
- Typing replaces a cell; Enter, F2 or a double-click edits it; Alt+Enter adds a line break; Tab and Enter commit and move; Escape cancels.
- Delete clears the selection; Ctrl+C, Ctrl+X and Ctrl+V copy, cut and paste tab-separated cells, which work with Excel and Google Sheets.
- Ctrl+Z undoes and Ctrl+Y (or Ctrl+Shift+Z) redoes; Ctrl+F opens Find & replace.
- Click a column letter or row number to select the column or row; Shift+click extends; drag a column edge to resize it, double-click the edge to fit it.
Drafts in this browser
A moment after each change, the table is saved as a draft in this browser’s IndexedDB storage on your device — never on a server. Drafts are listed when you open the page, with their size and when they were saved; the last 5 are kept. Delete a draft with Delete draft or Delete in the list, or untick Autosave a draft to stop saving (which also deletes the draft of the open table). Clearing your browser’s site data removes them too.
Limitations
- CSV and TSV files up to 100 MB and 10 million cells; larger files can be cut up first with the CSV & Excel Splitter. Very large files need a computer with plenty of memory; on phones keep to a few hundred thousand cells.
- Excel workbooks (.xlsx, .xls) are not opened here — convert them with Excel to CSV first, or view them in the Excel Viewer.
- Files are saved as UTF-8 (with or without a byte-order mark), whatever their original encoding.
- Undo keeps the last 300 steps, fewer when steps change millions of cells.
- Regular expressions with nested repetition, such as (a+)+, are refused because they can freeze the page.
- Drafts depend on the browser’s storage: a private window forgets them when it closes, and a full disk can stop them from being saved (the editor tells you).
Privacy
Everything happens in your browser: files you open are read on your device and are never uploaded. While you edit, a draft of the table is kept in this browser’s IndexedDB storage (on this device only) so you can come back to it; you can delete drafts at any time or switch autosave off.
Frequently asked questions
How do I open a CSV file without Excel changing it?
Open it here: every cell is kept as the exact text in the file, so leading zeros, long numbers and date-like text stay as they are. Edit what you need and save it as CSV again.
Can I open a very large CSV file?
Yes — up to 100 MB and 10 million cells. Only the visible rows are drawn, so scrolling stays fast. Sorting or filtering hundreds of thousands of rows takes a second or two.
How do I change the delimiter of a CSV (semicolon to comma)?
Open the file, then under Save choose CSV with the delimiter you need (or TSV for tabs) and download. Values that contain the new delimiter are quoted automatically.
The characters in my file look wrong (é instead of é).
The file was read with the wrong encoding. Open Read the file again, choose the right encoding (for example Windows-1252 for Western European Excel files, Windows-1251 for Cyrillic), and choose Read again. When you save, the file is written as UTF-8.
Where are my drafts stored? Can someone else see them?
In this browser’s IndexedDB storage on your device only. They are not uploaded and other people or sites cannot read them. Delete them in the drafts list, or switch autosave off.
Can I save my CSV as an Excel file?
Yes. Choose Excel (.xlsx) under Save. The header row is bold and frozen; whole numeric columns become numbers (unless you untick that), and everything else stays text.