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
Data table
Instructions and important notes
Use CSV while preserving original data
- 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.
- 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.
- 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.
- 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.
- 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