How to edit CSV data in your browser
- Use Detect automatically or choose the Delimiter for your data.
- Select Choose CSV or TSV file, paste data and select Open pasted data, or select New table.
- Select a cell and press Enter to edit it. Paste a range into a selected cell or add and delete rows and columns.
- Choose your export settings and select Download table.
Review a table before importing it
Use this CSV viewer to check a small data export before opening it in a spreadsheet or loading it into another system. The grid keeps identifiers, postal codes and other fields as text. You can check the first row for column names and look for misplaced data that may have come from an extra separator. The viewer reports short rows relative to the header and pads them. A row wider than the header adds columns, with empty cells where the other rows have no values.
Edit CSV online with a keyboard
Select a cell and use the arrow keys to move. Press Enter to open the selected cell for editing, use Shift+Enter to insert a line break and press Escape to cancel the edit. You can paste a tab-separated range copied from a spreadsheet into the grid, starting at the selected cell. The grid expands when the range needs extra rows or columns. Use Undo if you paste a range into the wrong position or delete a row by mistake.
Supported separators, shortcuts and export rules
| Feature or limit | Supported behavior in CSV editor |
|---|---|
| Supported delimiters | Comma, semicolon, Tab and pipe (auto-detected or chosen manually) |
| Keyboard editing | Arrow keys move, Enter edits, Shift+Enter adds a newline, Escape cancels |
| File & grid bounds | One UTF-8 file up to 10 MiB, 50,000 rows, 100 columns and 500,000 cells |
| Export options | Keeps source delimiter & CRLF endings; optional spreadsheet formula protection & UTF-8 BOM |
Formula protection prepends an apostrophe to values a spreadsheet program could interpret as formulas—turn it off only for clean machine imports. When a table needs to become structured records, convert it with JSON converter, or extract tabular data out of documents first with PDF to Excel.
Frequently asked questions
Will the CSV editor keep leading zeros in IDs?
Yes. The grid treats every cell as text, so values such as 001 remain unchanged in the file. When reopening it in a spreadsheet, import that column as text.
Which separators does the CSV viewer support?
Comma, semicolon, Tab and pipe. Automatic detection works for these four separators. You can also select the separator before opening your data.
Can a CSV cell contain a separator or a line break?
Yes. Quote the cell in the input and double any literal quotes it contains. In the grid, use Shift+Enter while editing to insert a line break.
What does spreadsheet formula protection change?
It adds a leading apostrophe to values that spreadsheet software might treat as formulas. Disable it if you need an exact text value for a trusted import.
How large a CSV file can I edit?
One UTF-8 file up to 10 MiB, with at most 50,000 rows including the header, 100 columns and 500,000 cells after padding.
Last updated November 12, 2026