Edit CSV values in a table without opening a spreadsheet app. Add or remove rows and columns, then download the revised file.
How to use
Paste comma separated CSV and select Load table, or import a UTF8 CSV under 1 MB. Edit cells and export the result. Limits are 1,000 rows and 100 columns.
Example
Use name,city as the header and Ada,London as a row. A value containing a comma must be enclosed in double quotes.
FAQ
Will export run formulas?
This editor treats cells as text. Spreadsheet apps can interpret values beginning with formula characters when you open the downloaded CSV.
Related tools
A practical task
Load a small sample with the header and two rows before editing a full file. Confirm that quoted commas stay inside cells and that the correct row becomes the header. After editing, inspect a downloaded copy in the application that will import it.
Another useful question
Will editing the input update an already loaded table?
Load the revised input again. Treat the input area and the current table as separate stages so you do not export an older loaded version by mistake.
Details for interpreting the result
| Detail | Explanation |
|---|---|
| Quoted CSV fields | In comma separated CSV, a field containing a comma, quote, or line break needs quotes around it. A quote inside that field is doubled. Splitting every comma by hand loses those field boundaries. |
| Column headers | Headers provide names for columns; they are not extra data values. Keep their order aligned with each row. When building objects, duplicate header names create ambiguity about which value belongs to a key. |
| Strings and values | The JSON string "12" differs from the number 12, and "false" differs from false. Type changes affect comparisons and imports. Keep identifiers as strings when their leading zeros or exact digits matter. |
| Empty and missing data | An empty string, a missing property, and null express different states in structured data. A flat table can merge some of those distinctions. Confirm how missing cells should be handled before converting records. |
| CSV and spreadsheets | CSV stores text and delimiters, not cell formatting. A spreadsheet can interpret a value beginning with a formula marker when opening it. Review imported files rather than assuming quoted cells cannot be interpreted. |
| Numeric precision | JavaScript numbers cannot represent every large integer exactly. Long account numbers, order identifiers, and arbitrary precision decimals should remain strings or use a suitable numeric library in the receiving application. |
| Workbooks and sheets | An XLSX workbook can contain several worksheets, formulas, formatting, and hidden context. A CSV export represents one flat table. Select the intended sheet and retain the workbook when that extra context matters. |