CSV Viewer and Editor

How to open and edit a CSV file

1. Drop your file on the drop zone or click it to choose a .csv, .tsv or .txt file. You can also paste CSV text in Or paste CSV text and click Open pasted text, or start from scratch with New empty table.
2. The Encoding and the Delimiter are detected automatically. If accents look wrong (for example é instead of é) or everything lands in one column, pick them by hand. Untick First row contains column names if your file has no header row.
3. Browse the table page by page. Use Search all columns, or choose a Filter column and type what it Contains. Click the arrow next to a column name to sort it (ascending, descending, then back to the original order).
4. Click any cell to edit it, rename a column in its header, or use Add row, Add column and Delete column. The × at the end of a row deletes it.
5. Under Export, choose the Delimiter and the options, then click Download CSV.

The file is read and edited in your browser tab. It’s never uploaded, so you can safely open customer lists, bank exports or other private data.

Encodings and delimiters

A CSV file is plain text, but not all programs write it the same way. This tool looks for a byte-order mark (BOM) first: UTF-8, UTF-16 LE and UTF-16 BE files that start with one are decoded accordingly. Without a BOM, the file is checked as UTF-8; if it isn’t valid UTF-8, it’s read as Windows-1252, the encoding Excel on Windows uses for “CSV” files in English and French. The detected encoding is shown above the table.

Commas are the standard delimiter, but spreadsheets set to French or other languages that use a decimal comma write semicolons instead, and some exports use tabs or pipes. The delimiter giving the most consistent number of columns over the first 50 lines is chosen. Quoted fields ("Tremblay, Ana") may contain delimiters, quotes (doubled: "") and line breaks, as defined by RFC 4180. Rows with missing fields are padded with empty cells and reported in a notice.

Sorting, large files and export

Sorting understands numbers: 9 comes before 10, negative and decimal values are ordered correctly, text is sorted alphabetically without regard to case or accents, and empty cells always go last. Search and filters also ignore accents, so ecole finds École.

Only one page of rows (50 to 500) is displayed at a time, which keeps the page fast even with hundreds of thousands of rows. Files up to 200 MB can be opened, depending on your device’s memory.

The export contains every row in the current sort order, or only the matching rows if you tick Export only the rows that match the search and filter. Add a UTF-8 BOM helps Excel display accents correctly when you double-click the file.

Formula injection protection

A cell that starts with =, +, - or @ can be run as a formula when the CSV is opened in a spreadsheet, which attackers use to trigger links or commands (“CSV injection”). With Protect against formula injection ticked, such cells get a leading apostrophe so spreadsheets show them as text. Plain numbers like -12.5 are not changed. Untick it if the file feeds another program that must receive the exact values.