CSV Editor

What is a CSV editor?

A CSV editor displays delimiter-separated text as rows and columns while preserving every cell as text. It is useful for correcting an export, renaming a header, adding or removing records, replacing repeated text, and changing row order without opening a full spreadsheet application.

This editor does not infer numbers or dates. Values such as 00123, 2026-01-01, 123456789012345678, and 1E10 remain strings unless you replace them yourself.

How to edit a CSV file

1. Open a .csv, .tsv, or .txt file, drag a file onto the tool, paste CSV text, or select Example.
2. Open Settings when you need to select a delimiter or change whether the first row contains headers.
3. Select Edit CSV after pasting text. Opened files and the example are parsed automatically.
4. Select a cell to edit its complete value. The active cell uses a multiline text area, so quoted line breaks can be retained.
5. Select a row number or column header before inserting, deleting, renaming, or sorting that part of the table.
6. Select Download CSV, confirm the file name, and save the complete edited document.

Each cell, row, column, replacement, or sort operation can be undone. Opening another file, clearing the editor, or changing parsing settings asks before discarding changes that have not been downloaded.

CSV editor example

Input:

id,name,city,note
001,Alice,London,"Customer since 2024"
002,Bob,New York,"Prefers email, not phone"

You can change Bob’s city, rename note, insert another record, or sort all rows by id. The downloaded CSV keeps 001 as text and correctly quotes values that contain commas, quotes, or line breaks.

Editing cells, rows, and columns

Selecting a data cell opens that cell for editing. Press Cmd + Enter on macOS or Ctrl + Enter on Windows and Linux to commit while staying in the table, or move focus away to commit. Press Escape to cancel the active cell edit.

Insert row adds a row after the selected row, or at the end when no row is selected. Insert column follows the same rule for columns. Row and column deletion can be reversed with Undo. The final column cannot be deleted; use Clear when you want to discard the document.

When the first row is treated as headers, select a column and then select Edit header. Empty and duplicate headers remain valid CSV text; generated Column 1, Column 2, and similar labels are display aids rather than automatic data changes.

Find, replace, filter, and sort

The row filter searches every data cell and only changes which rows are visible. Hidden rows remain in the document and are included in the download.

Find & replace performs a literal replacement across data cells. It can match text with or without case sensitivity, reports the number of matches before replacement, and records the complete replacement as one undoable action. It does not use regular expressions or change header cells.

Column sorting is an explicit edit. Select a column, then choose ascending or descending order. The sort applies to all rows, including rows hidden by the current filter, and the new order is written to the downloaded file.

Value fidelity and CSV formatting

The editor preserves parsed cell strings, including leading zeros, long numeric-looking text, empty cells, delimiters inside quoted fields, escaped quotes, and quoted line breaks.

Downloading serializes the edited values as valid delimiter-separated text. The output uses UTF-8 with a byte order mark and CRLF line endings for broad spreadsheet compatibility. Quote placement and original line-ending style may be normalized even when the cell values are unchanged. Completely blank or whitespace-only source lines are ignored during table parsing.

Use a raw text editor when byte-for-byte preservation of the original quoting and whitespace is required.

CSV editor vs. CSV viewer vs. spreadsheet

The editor intentionally does not provide formulas, charts, cell types, XLSX workbooks, SQL, multi-cell transformations, cloud storage, or file comparison.

Use CSV to JSON when the edited rows need to become JSON records. Use JSON to CSV for the reverse conversion.

Editing larger CSV files

Inputs over 1 MB are parsed in a browser worker, and the table renders 25 to 250 rows per page. Inputs over 50 MB are rejected to limit browser memory use.

Parsing in a worker does not make every edit instantaneous. Search, replacement, sorting, row count, column count, cell length, device memory, and browser performance all affect responsiveness. Dedicated desktop software is more appropriate for very large or multi-gigabyte files.

CSV Editor FAQ

Can I edit a CSV without Excel?

Yes. Open or paste the CSV, edit the table, then download a new .csv file. The editor does not provide spreadsheet formulas or formatting.

Can I edit CSV headers?

Yes. Keep First row contains headers enabled, select a column, and select Edit header.

Does filtering remove rows from the download?

No. Filtering only changes the visible table. Every row remains in the downloaded document unless you explicitly delete it.

Does sorting change the CSV?

Yes. Ascending and descending column sorts reorder the complete document and are included in the download. Sort operations can be undone.

Can Find & replace use regular expressions?

No. It performs literal text replacement in data cells, with an optional case-sensitive match.

Are numbers and dates automatically converted?

No. Every parsed cell stays a string, so identifiers and number-like text are not reformatted automatically.

Can the editor open XLSX files?

No. CSV contains one plain-text table, while XLSX is a workbook format that can contain sheets, formulas, styles, charts, and other features.

Is the original CSV formatting preserved exactly?

Cell values are preserved, but download serialization may normalize quoting and line endings. The tool does not provide token-level or byte-for-byte source preservation.