CSV Viewer & Editor

What this tool does

This CSV viewer and editor turns a raw comma-separated file into a clean, readable table that you can change directly in the page. Paste CSV text into the box or drop a .csv file onto the upload area, and the tool parses it into rows and columns. From there you can click any cell to edit it, rename the column headers, add or remove rows and columns, and sort by any column. When you are happy with the result, copy the CSV or download it as a new file. It loads with a small sample employee list so you can see exactly how everything behaves before using your own data.

A CSV file is just a table stored as plain text — each line is a row and a delimiter (usually a comma) separates the cells. That format is easy for software to produce but hard for a person to read in a text editor. This tool bridges that gap without needing a full spreadsheet program.

Why and when you would use it

Most people reach for this when an export looks wrong and they want a quick look without opening Excel. A marketing platform sends a contact list, a finance system produces a transaction dump, an e-commerce store exports its catalogue — all of it arrives as CSV. Opening that file here lets you scan it, fix a few obvious errors, delete a column you do not need, and hand on a tidier file in under a minute.

It is also handy for preparing a small dataset to share. If you only need to send a colleague six rows out of a thousand, you can paste those rows, trim the columns down to what matters, and download a focused edited.csv rather than forwarding the entire export. For quick fixes — correcting a misspelled name, removing a test row, renaming an unclear header — editing here is faster than launching a heavyweight application.

How to use it

1. Paste your CSV into the text box, or drop a .csv file onto the upload area. The sample loads automatically so the table is never empty.
2. If the columns look merged or split wrongly, change the Delimiter menu. Auto-detect handles most files; choose comma, semicolon, tab or pipe manually if a file uses something unusual.
3. Use the First row is a header switch to tell the tool whether the top line is column names or real data.
4. Click any cell to edit its contents. Click a header field to rename the column.
5. Use Add row and Add column to grow the table, or the × buttons to delete a row or column.
6. Click Sort on a header to order the table by that column; click again to reverse it, and once more to return to the original order.
7. When finished, use Copy CSV or Download .csv to save your work.

Common pitfalls and tips

The classic CSV trap is Excel turning text that looks like a number into a number. Leading zeros vanish from ZIP codes and product SKUs — 00123 becomes 123 — and long order numbers can be rewritten in scientific notation. This tool keeps every cell as text exactly as written, so it will not silently mangle those values, but be aware of it when the file is later reopened in a spreadsheet.

Watch for mixed delimiters: a file that uses semicolons but has one stray comma will parse strangely. Smart or curly quotes pasted from a word processor are not the same as the straight quotes CSV expects and can break field boundaries. If a column refuses to sort as numbers, look for a blank cell or a currency symbol hiding in it. For developers who need a structured format instead of a table, the CSV to JSON converter and JSON to CSV converter handle that conversion. To turn a tidy CSV into web-page markup, try the CSV to Table converter; to build a CSV from a plain list, use the List to CSV converter.

Privacy

Everything in this tool happens inside your browser. The file you drop is read locally with the browser’s file API, parsed by JavaScript on your own device, and never sent anywhere. No upload, no server copy, no logging, no tracking of the contents. Closing the tab discards the data entirely. Because CSV files so often hold employee records, customer details or financial figures, that local-only design means you can view and clean sensitive exports here with confidence.