CSV / TSV
Paste delimited text or read a file, parse it, then review your cell edits before applying them.
Your data is processed in this browser, without upload or storage.
| # | Column 1: text (hint only) | Column 2: text (hint only) | Column 3: text (hint only) |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 |
Records: 3 · columns: 3 · delimiter: Comma
A product feed can fail because one description contains an unclosed quote or an identifier loses its leading zeros. This online CSV editor gives each value its own cell so you can correct the record without counting separators by hand.
Use the table as a CSV viewer before an import, or edit CSV files containing test fixtures and contact exports. Column hints describe what values look like; they never turn a long ID into a rounded number or a date-like string into a date.
Fixing a customer code should not quietly rewrite another field. The CSV editor keeps cell edits as drafts, shows their before-and-after values and counts the changed cells. Apply the preview when it is correct; one undo restores the previous source and table.
A missing field and an unclosed quote need different repairs. Diagnostics identify source line and column positions and report expected versus actual cell counts. Empty records are retained, so a blank line cannot silently disappear from the imported data.
UTF-8 is the default for files. Choose another supported encoding and read the file again if the text is wrong; the selection alone does not re-read it. Each file read creates a replacement preview. Apply that preview, then parse. Apply or discard cell drafts before re-reading.
Run Parse and validate, or press Ctrl/Cmd+Enter. If delimiter detection is uncertain, select comma, tab, semicolon or pipe and parse again. The header setting changes display and type hints; it does not remove the first record or merge duplicate header names.
Preview changed cells before applying them. The table reveals 50 records at a time, including a header record; the shown count is not an export limit. Resolve source errors and parse stale input before downloading the complete table. Undo also restores the previous source.
Read comma, tab, semicolon and pipe separators with double-quoted fields. Automatic detection supplies a suggestion, while manual selection resolves a file whose punctuation allows several interpretations.
Edit any displayed cell, including an empty or repeated header. Columns retain their positions rather than being stored under unique names, so two columns called name remain two columns.
See empty, text, number-like, boolean-like or mixed hints. These observations can reveal an unexpected value in a column, but they are not a schema validator and never change stored strings.
Try UTF-8, UTF-16LE/BE, GB18030, Shift_JIS or Windows-1252 against the original file bytes. Invalid byte sequences fail decoding instead of being replaced silently. A pasted string has no original file bytes to reinterpret.
No. File reading, parsing and editing happen in the current browser tab. The page does not send your file to a processing server or store your work for another visit.
The limits are 2 MiB for the file or UTF-8 input, 2,000 records including the header, and 100 columns. The CSV editor rejects an input beyond these bounds. For a larger dataset, prepare a smaller part before opening it here.
Yes. Enclose the field in double quotes, and represent an internal double quote with two quotes. The parser keeps quoted commas and embedded newlines in one cell; the exporter adds the quoting needed to read that value again.
Comma, tab, semicolon and pipe are supported. Choose Tab for TSV or start with detection. When detection is uncertain, choose explicitly and check the table. The export uses the separator that was actually parsed.
Text such as 007 or a long identifier stays exactly that text, without numeric rounding. CSV does not carry spreadsheet styles or display formats. Opening the downloaded file in a spreadsheet may convert values again, so import identifier columns as text there.
Does a valid record fail to parse?
Open the sample in the CSV editor, inspect a record, and preview a cell change before using your own export.