Online CSV Viewer and Editor
Open a CSV, TSV or tab file as a searchable table, edit cells, rows and columns, and download the result. Your file never leaves your device.
Turn on JavaScript to open your file. It is read in your browser and never uploaded.
How to open a CSV file online
- Drop your file on the page. Drop a .csv, .tsv or .tab file on the page, or choose it from your device. It is read in your browser and never uploaded.
- Check the columns. The delimiter (comma, semicolon, tab or pipe) is detected for you. If the columns look wrong, pick another delimiter from the list at the bottom, and turn "First row is header" on or off.
- Search and sort. Type in the search box (press / to jump to it) to show only the rows that match, and click the arrows in a column header to sort that column.
- Switch to Edit to make changes. Click a cell to edit it, add or delete rows and columns, use find and replace, or clean up a column or the whole table: change case, trim spaces, remove empty or duplicate rows. Undo and redo are always there.
- Download your CSV. Use the download icon to save the edited file. The original file on your device is never changed.
CSV viewer and editor: common questions
Why does my CSV file open in a single column?
The file probably uses a different separator from the comma, such as a semicolon, which is common in files saved by Excel in many countries. OpenAnyDoc detects comma, semicolon, tab and pipe automatically, and you can choose the delimiter yourself from the list at the bottom of the table.
How do I open a CSV file with Arabic or other non-English text?
Just open it: UTF-8 (with or without a BOM) and UTF-16 files are read directly, and a file that is not valid UTF-8 is read as Windows-1256, the old Arabic encoding. Arabic cells display right-to-left. When you download, a byte order mark is added if the file has non-English text, so Excel shows it correctly.
Can I open a large CSV file online?
Yes. A CSV file with 100,000 rows opens in under a second, because only the rows on screen are drawn, and it stays smooth while you edit. Files over 50 MB show a warning, and OpenAnyDoc still tries to open them; the limit is your browser's memory.
How do I remove duplicate rows from a CSV file?
Switch to Edit, open the Clean up menu (the Aa icon) and choose "Table: remove duplicate rows". The first copy of each row is kept. The same menu can remove empty rows, trim spaces, change the case of a column and fill empty cells down.
Does the CSV editor keep leading zeros and long numbers?
Yes. Every cell is read as text exactly as written, so postcodes like 00123 and long ID numbers are not changed into numbers or shortened.
Can I edit TSV and tab-separated files too?
Yes. .tsv and .tab files open tab-separated, with the header row detected, and you can edit and download them the same way as a CSV file.