csvjson

CSV Viewer & Editor

Paste any CSV data to view it as a sortable, filterable table. Double-click cells to edit, add or delete rows, and export the result back to CSV. Auto-detects delimiter.

Features

🔍
Filter rows

Type in the filter box to instantly show only rows containing the search term across any column.

↕️
Sort columns

Click any header to sort ascending. Click again for descending. Numeric columns sort by value.

✏️
Edit cells

Double-click any cell to edit in place. Press Enter to save, Escape to cancel.

Add/delete rows

Add empty rows at the bottom or delete any row with the x button that appears on hover.

⬇️
Export CSV

Download the current table including edits as a properly quoted CSV file.

🔄
Auto-detect

Delimiter detection handles comma, semicolon, tab, and pipe files without manual configuration.

Common use cases

Quick data inspection

Paste an API response or database export to quickly understand the structure and spot data quality issues.

Small data fixes

Correct a handful of cells — a typo, a wrong category, a missing value — without opening Excel or writing a script.

Delimiter conversion

Paste a semicolon-delimited file (common from European Excel exports) and re-export as standard comma-delimited CSV.

Filter before importing

Filter down a large export to just the rows you need, then export the subset for importing elsewhere.

Frequently asked questions

What delimiters are supported?

Comma (,), semicolon (;), tab, and pipe (|). Auto-detect mode uses PapaParse which handles the vast majority of files correctly. Select manually if your file uses an unusual delimiter.

How do I edit a cell?

Double-click any cell in table view to enter edit mode. Press Enter or click outside to save, or Escape to cancel. Changes are tracked in memory — use Export CSV to download the modified file.

Can I open a CSV file from my computer?

Paste the file content into the Raw tab. Open the file in any text editor, select all, copy, and paste.

How does column sorting work?

Click any column header to sort ascending. Click again for descending. Numeric columns sort by value, text columns sort alphabetically.

What happens to my edits if I switch to the Raw tab?

Edits made in the table are tracked separately from the raw input. The Raw tab shows the original pasted text. Use Export CSV in table view to download your edited data.