How to view and edit a CSV file
- Open a file, drop it on the box or paste CSV text. Sample data lets you try it first.
- Check the detection above the grid: delimiter, quotes, header row and encoding. Change one and the file is read again.
- Explore: click a header to sort (again to reverse, a third time to reset), filter rows with the search box, and open Column stats for types, blanks, distinct values and ranges.
- Edit: double-click a cell, press Enter or just type. The bar above the grid shows the full value, line breaks included.
- Export CSV or TSV with the delimiter, quoting and line endings you need, for the filtered view or every row.
Files are parsed with PapaParse, which handles quoted fields and line breaks inside cells as RFC 4180 describes. Only the visible rows are drawn, so 100,000 rows scroll as easily as 100.
Frequently asked questions
Are my CSV files uploaded anywhere?
No. The file is read and parsed on your device, in a background worker for big files. Nothing you open, paste or edit is sent to a server. Page views are counted with Cloudflare Web Analytics, which uses no cookies and never sees your data.
How large a CSV file can it open?
The grid only draws the rows you can see, so scrolling stays smooth with hundreds of thousands of rows. Files of tens of megabytes open comfortably on a typical laptop; the limit is your device's memory.
Which delimiters and encodings are detected?
Comma, semicolon, tab and pipe delimiters, the quote character, and whether the first row is a header. Files are decoded as UTF-8, UTF-16 or Windows-1252, and a byte order mark is removed. You can override every guess.
Can I edit the data and save it?
Yes. Double-click a cell or press Enter to edit it, double-click a header to rename it, and add or delete rows and columns, with undo for every change. Export writes a new CSV or TSV file with your edits.
Why do accented characters look wrong?
The file was probably saved in another encoding, for example Windows-1252 by an older version of Excel. Pick the encoding above the grid and the file is decoded again.