How to use the CSV Viewer and Editor
- 1. Add your CSVPaste the text or upload a .csv file. Commas, semicolons, tabs and pipes are detected.
- 2. Open the tableClick any cell to edit, a column name to sort, or type in Filter to search.
- 3. Clean and saveRemove empty or duplicate rows, add rows or columns, and download the CSV.
How the CSV is read
CSV looks simple, but real files have traps: values with commas inside quotes, quotes inside values written as two quotes (""), line breaks inside a cell, Windows line endings and a hidden byte-order mark at the start of files saved from Excel. This tool follows the standard CSV rules (RFC 4180) for all of these, and picks the delimiter by counting commas, semicolons, tabs and pipes in the first line. European Excel files often use semicolons, so that matters.
Big files are shown 50 rows per page so the browser stays fast. Up to 200,000 rows can be opened.
Worked example
The sample has four students with name, city and score. Open it, then click the score header: the table sorts from lowest to highest, Karan (67) first. Click again for highest first: Meera (91) moves to the top. Numbers are sorted as numbers, so 100 comes after 91, not after 10.
Type Noida in Filter and only Asha and Karan stay visible, and the counter shows "2 match the filter". Click a cell, change the value and press Enter to save the edit.
- Remove duplicate rows keeps the first copy of rows that match in every column.
- Remove empty rows drops rows where every cell is blank.
- Download CSV writes a clean, properly quoted file that opens in Excel, Google Sheets or pandas.
Frequently asked questions
Is my CSV uploaded to a server?
No. The file is read and edited inside your browser, and the download is created on your device.
Why do my Hindi or special characters look wrong in Excel?
Excel sometimes guesses the wrong encoding. Use Data > From Text/CSV in Excel and choose UTF-8, which is what this tool writes.
Can it open Excel files?
This page is for CSV. For .xlsx and .xls files use the Excel viewer tool.
Is the CSV editor free?
Yes, it is free. Opening your first table asks for your name and WhatsApp number once; after that it and every other Uncodemy tool open freely.