YOUR TABLE. YOUR CHANGES.

CSV & TSV Table Editor

Edit cells and column names, add rows, sort precisely and export the table you need. Values stay text, including leading-zero IDs and large numbers.

Editable paginated gridUndo & exact decimal sortLocal CSV / TSV export

1. Open a table

Loading replaces the working table. Source edits do not change the grid until you load again. Uneven rows are padded; extra columns receive names. UTF-8 files up to 4 MiB / one million text characters.

No table loaded.Jump to grid ↓

Ready. Try the sample or open a CSV / TSV.

2. Edit & organize

Filter, sort & clean the table

Find rows

Sort all rows

Numeric mode accepts plain decimals up to 100 characters, without exponent or thousands separators. Sorting does not rewrite values.

Clean deliberately

Duplicates compare every cell exactly and keep the first row. Both actions affect the full table, including rows hidden by your filter. Undo restores the previous table.

Load a table to edit its cells and column names.

No data rows.

Up to 5,000 rows, 100 columns and 100,000 cells; 20,000 characters per cell and two million edited characters. Wide tables cap each page at 500 editable cells. Page limits affect only the view, not exports. Cell values can contain line breaks.

3. Preview & export

Formula protection changes exported cells starting with =, +, -, @ or spreadsheet control prefixes, including negative numbers and column names. Turn it off when exact raw values are required. Your working cells stay unchanged. CSV cannot force a spreadsheet to keep numeric-looking IDs as text; import those columns as text in that application.

No export preview yet.

Processing runs locally without a table upload or stored editing history. Website ads and analytics follow our privacy information.

Using CSV & TSV Table Editor

Edit delimited tables without uploading them for processing. Values stay strings, including leading-zero identifiers and unsafe large integers. Review each transformation before exporting.

  1. Open a UTF-8 CSV/TSV or paste source. Choose delimiter/header/blank-record options and Load / replace table, or start a blank table.
  2. Edit headers and cells in the grid. Add/delete rows or columns, filter, sort all rows, trim values or remove exact duplicates. Undo restores recent working-table states.
  3. Choose delimiter, line endings, header inclusion, all or filtered rows, quoting, BOM and formula protection. Preview the export and download the full selected table.

Example

The sample has leading-zero IDs, quoted commas, a multiline note, a large integer, duplicate rows and a formula-like value. Edit one cell, undo it, and compare text versus exact numeric sorting.
Filter the sample by Lin. Filtered-only export includes both matching rows across all pages; removing duplicates affects the full table. Default formula protection prefixes the =SUM cell without changing the working value.

Questions & answers

Does it change number formatting automatically?

No. Cells and headers remain strings. Leading zeros, large integers and decimal formatting stay unchanged in the working table. Spreadsheet software may infer types when opening CSV; import identifier columns as text there.

How does exact numeric sorting work?

Plain signed decimals are compared using integer digits and decimal scales, avoiding floating-point precision loss. Exponent notation and thousands separators are rejected. Values are not rewritten; blank cells sort last in both directions.

What does a filter change?

It changes which rows appear in the grid. It does not delete rows. Export uses every working row unless Export current filtered rows only is selected; pagination never limits the export.

How are uneven records handled?

Missing trailing cells are padded with empty strings. Extra columns receive generated names. Duplicate and blank original headers are kept by position, with display placeholders for blank names. This creates an editable rectangular table and may normalize row shape on export.

Can I undo edits and cleanups?

Yes. Up to ten recent table states are kept in memory, bounded by a six-million-character history budget. A cell focus creates an edit checkpoint. Rows, columns, sorting, trimming, duplicate removal and table replacement can be undone while the page is open.

What does formula protection do?

It prefixes exported formula-like values or spreadsheet control prefixes with an apostrophe, including negative numbers and headers. Working cells do not change. Disable it when exact raw exported values are needed. Quoting fields alone does not reliably prevent spreadsheet formula interpretation.

Are CSV bytes preserved exactly?

The tool preserves cell strings but reserializes records using your output options. Delimiters, quoting, row shape, line endings, optional BOM and formula prefixes can change. Multiline cell content is retained. Use a checksum tool when you need byte-for-byte verification.

What are the limits?

Input is up to one million text characters and 4 MiB per UTF-8 file. The working table supports 5,000 rows, 100 columns and 100,000 cells, with 20,000 characters per cell and two million edited characters. Each page caps at 500 editable cells; export is bounded to four million characters.

Are my tables saved or uploaded?

No processing upload or persistent editing history is used. Parsing, sorting and exporting run in a browser worker using the already hosted Papa Parse library. Website ads and analytics follow the privacy information.

KEEP YOUR WORKFLOW MOVING

A useful next step for your task.

Browse Developer & Data

Help improve this tool

Report a problem or suggest an improvement

Describe the issue without pasting private tool input. Feedback goes to our admin inbox.

Find another tool · Read practical guides