What is CSV Viewer/Editor?

The CSV Viewer/Editor displays your CSV and TSV files in a clean spreadsheet-style grid. Sort columns, edit cells inline, add or delete rows, and export your changes — all without installing any software.

Upload a .csv or .tsv by dragging it onto the page, paste raw text from a spreadsheet, or start with the bundled sample of five rows. The parser is built on Papaparse so it handles quoted fields, embedded commas, and mixed line endings without choking. Edit any cell, sort by clicking column headers, add and remove rows and columns, then export the result as standard CSV that opens cleanly in Excel, Numbers, or Google Sheets.

How to use

1. Upload a CSV or TSV file by dragging it onto the drop zone, or paste raw CSV text directly into the editor.
2. Click any cell to edit it, use the column headers to sort, and right-click rows to insert or delete them.
3. When you're done editing, export your data in the format you need: Export CSV for a standard .csv, Export TSV for tab-separated text, Export JSON for an array of objects, or Export Excel for an .xlsx workbook that opens in Excel, Numbers, and Google Sheets.

When to use

• Fixing a typo or two in a large CSV before importing it into a database or analytics tool.
• Filtering and previewing rows of a customer or product export without opening Excel.
• Cleaning up a TSV copied from a SQL query so it can go into a spreadsheet.

Result

A data analyst uploads a 5,000-row customer export, corrects a misspelled company name in row 342, sorts by signup date, then re-exports the cleaned file — no software needed.

FAQ

How large a CSV can I load in this editor?

The editor stays smooth up to about 10,000 rows. Beyond that scrolling and sorting noticeably slow down because every cell is rendered in the DOM. For larger files, slice them with a command-line tool first and edit the trimmed version here.

Does it handle TSV (tab-separated) files?

Yes. The parser auto-detects the delimiter, so a .tsv exported from SQL or a spreadsheet loads correctly. On the way out you choose the format directly — Export TSV writes tab-separated text, Export CSV writes commas, Export JSON writes an array of objects, and Export Excel writes a .xlsx workbook.

What happens to commas, quotes, and newlines inside cell values?

They're preserved. Fields containing commas, double quotes, or line breaks get wrapped in quotes on export per RFC 4180, and double quotes inside are escaped as \"\". This means the exported file round-trips through Excel and most database importers without corruption.

Can I undo an accidental edit or delete?

Yes. Every cell edit, sort, add, delete, and find-and-replace is recorded on an undo stack up to 50 steps deep. Press Ctrl+Z (or Cmd+Z on a Mac) to step back, Ctrl+Y or Ctrl+Shift+Z to redo. The Undo and Redo buttons in the toolbar do the same thing. Loading a new file resets the stack, so export your work before importing something fresh.

How does the search work — full text or per-column?

It's a case-insensitive substring search across all visible cells. Rows where any cell contains your query stay visible; the rest are hidden until you clear the box. Sorting and editing still work on the filtered view.

Related Tools