CSV viewer & editor. A spreadsheet that never phones home.

How to use the CSV Viewer & Editor

This tool opens a CSV file as a table you can search, sort and edit, then saves it back out as CSV or JSON. It works out whether the file uses commas, tabs, semicolons or pipes, and it reads quoted fields that contain commas or line breaks. Use it to check an export before you import it somewhere else, fix a few cells without opening a spreadsheet app, or turn a CSV into JSON.

Step by step

1. 1
   Open your data

   Drop a file on the card that says "Drop a .csv file here", or click the card to browse. It accepts .csv, .tsv and .txt files up to 25 MB. To paste instead, press Paste CSV text, paste into the box and press Load. Load sample opens a five-row example.

2. 2
   Set the header row

   First row is header is ticked by default, so the top line becomes the column names. Untick it if your file has no header row; the names change to Column 1, Column 2 and so on, and the old header line becomes a normal row. You can switch back without losing anything.

3. 3
   Search and sort

   Type in Search all cells to show only rows where any cell contains your text, ignoring case. Click a column header to sort it ascending, again for descending, and a third time to return to the original order. Columns of plain numbers sort as numbers.

4. 4
   Edit cells and names

   Click any cell and type to change it; press Enter to finish. Click the name in a column header to rename that column. Use the small x at the end of a row to delete the row, or the x in a header to delete that column. At least one column must remain.

5. 5
   Add rows and columns

   Press + Row to add an empty row at the bottom, ready to type in. Adding a row clears any sort, and while a search is active the new row stays hidden until you clear the search. Press + Column to add an empty column on the right, named after its position, such as Column 6.

6. 6
   Save the result

   Press Download CSV to save edited.csv, Download JSON to save edited.json, or Copy CSV to put the CSV on your clipboard. Press Load another file to go back to the open card.

Reading the result

• The line above the table counts rows and columns, and adds the number of matches while a search is active. The sample shows 5 rows and 5 columns, because its header line is not counted as a row.
• The # column shows each row's position in the data, not its position on screen, so after a sort the numbers stay attached to their rows.
• Only the first 2,000 matching rows are drawn at once. When a file has more, an amber note reads Showing first 2,000 of N rows (export includes all), and every row is still searched, sorted and saved.
• Download JSON turns each row into an object keyed by the column names. Values that look like numbers, true, false or null become real JSON types, so in the sample salary 128000 is a number and active true is a boolean. Numbers with leading zeros or thousands separators stay as text.

Tips and common mistakes

• Sorting and searching change only what you see. Exports keep every row in its original order, including rows hidden by a search, so sort the source data elsewhere if the saved order matters.
• The CSV export always uses commas, whatever the input used, and quotes any value that contains a comma, a quote or a line break. A tab or semicolon file comes out as a comma file.
• If First row is header is off when you export, the CSV has no header line, and the JSON keys become Column 1, Column 2 and so on.
• Give every column a different name before you download JSON. Two columns with the same name share one key, and the later column's value wins.
• Delimiter detection reads the first line that is not blank. If that line is a title or a note rather than data, delete it first or the wrong separator may be picked.

Privacy and limits

Files are read and parsed by your browser, and nothing is uploaded or sent anywhere. Nothing is saved between visits either, so download or copy your work before closing the tab. Files larger than 25 MB are refused.

Back to the tool

Everything a CSV tool should do.

• View any CSV as a table instantly, with automatic delimiter detection for comma, tab, semicolon and pipe files.
• Sort by any column with one click, cycling ascending → descending → unsorted, with numeric-aware comparison.
• Search and filter rows in real time across every column at once.
• Edit cells inline and rename, add or delete columns and rows without leaving your browser.
• Export to CSV or JSON, or copy the CSV straight to your clipboard.
• Handle quoted fields correctly, including commas and line breaks inside quoted values (RFC 4180).

Frequently asked questions.

More text & code tools.

Browse the full free-tool library →