CSV editor

Edit table data without uploading files

Drop a CSV file here

or choose a file from your device. Data will not be uploaded.

Supports .csv and .tsv up to 2 MB
5,000 rows · 100 columns · 50,000 cells maximum

Choose a file, paste text, or try sample data to get started

Set up tables and files

Table display

Choosing a header does not delete the first row. Use a column arrow to sort, drag a border to resize, or open the column menu for keyboard controls.

Reading files

This setting applies on the next file open. ANSI depends on the source system: Thai often uses Windows-874, Western languages Windows-1252. For incorrect text, change encoding and reread. Downloads remain UTF-8.

Downloaded files

Formula protection changes exported text, for example =1+1 becomes '=1+1 and -10 becomes '-10. Displayed table values remain unchanged.

Start new project

Undo up to 20 steps within the memory limit. Clearing the table can be undone until you close or reload the page.

When enabled, records and inputs are saved automatically only in this browser, without server transmission. Others using the same browser may see them, and clearing site data may remove them.

Turning off remembering or deleting saved data stops remembering and removes the saved copy while retaining current on-screen data. Clear Table empties the table and, if remembering remains on, saves that empty table with current settings.

Saving is not enabled

Remembers the table, filename, search, sort order, column widths, and settings, not the original file or undo history. Large files or insufficient browser storage may prevent saving; download a backup CSV.

Paste CSV text

Column options

Instructions and important notes

Use CSV while preserving original data

  1. Select or drop a file to open its table. If everything appears in one column or Thai text is incorrect, open Settings, change delimiter or encoding, and reread the selected file. Automatic delimiter detection uses the first row and may guess incorrectly.
  2. If there is no header, uncheck “First row is header” in Settings. The first row returns as data; changing this option does not delete information.
  3. Click cells to edit, Tab to the next cell, and Enter for a line break inside a cell. Add rows at the bottom or columns on the right. Undo restores edits, deletions, or sorting.
  4. Select column-header arrows to sort ascending, descending, then restore original order. Sorting uses Thai text and digit-sequence comparison, such as 2 before 10; it does not calculate negatives, decimals, or dates. Drag header edges to resize, use left/right arrows when an edge is focused, or use the column-menu slider.
  5. Search to filter the table, which displays 25 rows per page. Downloads include all rows in the selected order by default. To export only matching rows, open the arrow beside Download and choose Search results only. Both options include all matching pages and the header row.

Long numbers, dates, and spaces

The tool stores values as text: it does not calculate formulas, convert dates, round numbers, trim spaces, or remove blank rows. Thus 00123 remains intact in the CSV, but an application such as Excel may interpret it as a number. Use its data import menu and set that column to text before use.

Row numbers follow the original data order before sorting or searching, starting at 1 and excluding the header. Text fields expand with lines without tiny scrollbars. Very long text can be scrolled within the field using a mouse or keyboard.

Match ANSI or Shift-JIS to the file

ANSI depends on the source Windows language: Windows-874 for Thai and Windows-1252 for Western languages. Shift-JIS supports Japanese files. Choose in Settings before opening, or change it and reread the selected file. Downloads remain UTF-8. See Microsoft language code table and Web character-encoding standard

File formats and limitations

CSV stores one text table without colors, calculated formulas, multiple sheets, or Excel cell formatting. This tool does not open .xlsx. Limits are 2 MB, 5,000 rows, 100 columns, 50,000 cells, and 2 million total characters. Column widths affect this page only and are not saved in CSV.

Rows with differing field counts retain them; missing fields display blank and are added when edited. Adding or deleting columns normalizes every row to the same count. Export uses UTF-8, CRLF row separators, and quotes values containing delimiters, quotation marks, or line breaks. Quoting and line endings may differ from the source.

Privacy and opening files in spreadsheet applications

Files and text are read on-device without uploading or account storage. If you enable local retention, the table and settings remain in this browser profile's localStorage until retention is disabled, the copy is deleted, or site data is cleared. Otherwise, undownloaded data disappears on reload or tab closure. The tool does not execute HTML-like text or formulas, but other spreadsheet programs may treat values starting with =, +, -, or @ as formulas. Check their source or enable apostrophe prefixing before sharing.

Check CSV files before sharing them for Excel · Read how to fix garbled Thai in CSV and Excel · Privacy Policy