What the CSV Editor does
The CSV Editor opens a CSV, TSV or pasted spreadsheet in an editable grid. It detects the separator, handles quoted cells with commas and line breaks, and keeps the header row in place when you sort. Clean data with Trim spaces, Remove duplicate rows and Remove empty rows, add or delete rows and columns, and save with commas, semicolons, tabs or pipes, with an option that keeps Hindi readable in Excel.
How to use it
- Open a file or paste data; the separator is detected.
- Edit any cell; use the column buttons to sort or delete.
- Clean with Trim spaces and Remove duplicate or empty rows.
- Choose the separator and download.
Example
The sample list has six rows, one a duplicate Pen line. Remove duplicate rows deletes it, and sorting the Price column from high to low puts “Desk lamp, LED” at ₹899 first, then Stapler, Notebook and Pen, with the header row still on top. Saved as TSV for Excel, the file starts with the mark that tells Excel it is UTF-8.
CSV tips
Many European spreadsheets use semicolons, because their decimal separator is a comma; choose Semicolon when saving for them. Cells containing the separator, quotes or line breaks are wrapped in quotes automatically, which keeps the file valid.
Excel can show Hindi and other scripts as gibberish when it opens a plain UTF-8 CSV. Ticking For Excel adds a byte-order mark at the start of the file so the text appears correctly.
Questions people ask
Is my data uploaded?
No. Everything is worked out in your browser, and nothing you enter is kept once you close the page.
How big a file can it open?
Thousands of rows work well. Very large files are better in a spreadsheet program.
Does sorting understand numbers?
Yes. A column of numbers, including ones with commas or ₹, sorts by value, not as text.
Can I undo?
There is no undo; keep your original file until you have saved the result.