CSV Editor

Edit CSV files online, without a spreadsheet

This CSV editor opens a comma-, semicolon-, tab- or pipe-separated file as a grid you can edit directly: click a cell, type, press Enter. It reads quoted fields, doubled quotes and line breaks inside cells (RFC 4180), auto-detects the delimiter and renders large files page by page, so a table with 100,000 rows stays responsive. Add, reorder and delete rows and columns, rename headers, sort, filter, find and replace, trim and de-duplicate, and undo any step.

When the data is right, export it in the shape the next tool wants: CSV with your choice of delimiter, quoting and line endings, TSV, typed JSON, a Markdown table, or an Excel-compatible CSV with a UTF-8 byte-order mark and semicolons that opens correctly by double-clicking in Excel.

It is a different job from the CSV Formatter & Validator, which reports broken rows and rewrites a whole file in one go. Use the validator to find what is wrong with a file and this editor to fix individual values by hand. Nothing is uploaded: parsing, editing and exporting run in your browser, and a draft of your edits is kept in local storage so a reload does not lose work.

How to use the CSV Editor

1. Drop a .csv or .tsv file on the dropzone, or paste the text and press Open in editor. Untick First row is a header if your file has none.
2. Click a cell to select it and click again (or press Enter) to edit. Enter saves and moves down, Tab saves and moves right. Double-click a column name to rename it.
3. Use the toolbar to insert, delete or move the selected row or column. The arrow next to a column name sorts by it; a second click reverses the order.
4. Type in Filter rows to show matching rows only, or open Find and replace for exact, case-sensitive or regular-expression replacements.
5. Open Clean up to trim spaces, remove duplicate rows or drop empty rows. Everything, including sorts, can be undone with Undo or Ctrl+Z.
6. Pick a format under Export — CSV, TSV, Excel-compatible CSV, JSON or Markdown — set delimiter, quoting, line endings and BOM, then Download or Copy.

CSV Editor features

Keyboard shortcuts

Which export to choose

CSV has no single standard beyond RFC 4180, so the right settings depend on where the file is going:

• CSV, comma, CRLF, minimal quoting — the default; accepted by databases, Python, R, Google Sheets and most importers. “Minimal” also quotes fields with leading or trailing spaces so importers that trim keep them.
• Excel-compatible CSV — semicolon delimiter plus a UTF-8 byte-order mark. Excel on a PC set to a European or Indian locale uses the semicolon as its list separator and only recognises UTF-8 when the BOM is present; without it, ₹, € and accented names turn into garbage.
• TSV — tabs rarely appear in data, so nothing needs quoting; paste straight into a spreadsheet.
• JSON — an array of objects keyed by the header. Empty cells become null, numeric columns become numbers and boolean columns become true/false, as APIs and the JSON Formatter expect.
• Markdown table — for GitHub issues and documentation; pipes are escaped and numeric columns right-aligned.

CSV editor or CSV formatter?

The CSV Formatter & Validator asks “is this file valid, and can it be rewritten cleanly?” — it lists rows with the wrong field count, stray quotes and mixed line endings, then converts the whole file. This editor asks “what should this cell say?” — correcting a price, filling a missing city, removing a column of personal data before sharing, or reordering rows by hand. For a read-only look at a huge file use the CSV Viewer; CSV to JSON offers more conversion options than the JSON export here.