Editable table
Edit cells directly and keep raw output synchronized.
Input0 B
Editable gridNo rows match this view.
Basics
Understanding the format
CSV stores table data as plain text. A delimiter separates fields, quotes protect commas and line breaks inside values, and the first row often contains column names.
This editor parses CSV with RFC-style quoting, keeps empty values visible, and rebuilds the file from the grid.
What it does
What this tool does
Use one workspace to inspect structure, correct cells, sort or filter rows, clean columns, transpose data, and control the exported delimiter and quoting.
Actionable validation
See parser errors, uneven rows, blank or duplicate headers, and exact row locations.
Focused cleanup
Trim, fill, truncate, sort, transpose, insert, or remove data without rebuilding the file.
Private workflow
Files and pasted values remain in this browser tab.
How to use
How to use it
Add CSV
Paste text, choose a local file, or load the realistic sample.
Parse and review
Choose the delimiter if detection is wrong, then inspect diagnostics and the grid.
Edit or clean
Change cells directly or run a table action; use Undo to recover the previous state.
Export
Copy the formatted CSV, download it, or reuse the result as a fresh input.
Errors & limits
Common errors and limits
Uneven records
A row with fewer or more fields than the header is identified by row number.
Quoted line breaks
A newline inside a field must stay inside matching quotes.
Duplicate headers
Duplicate names are ambiguous for JSON conversion and key-based comparison; rename them first.
Review
CSV has no universal schema or data types. Review leading zeros, dates, line endings, encodings, and spreadsheet formula values before importing the result elsewhere.
FAQ
Frequently asked questions
Does this upload my CSV?
No. Parsing, editing, and export run locally in your browser.
Can it handle commas inside values?
Yes. Properly quoted commas, escaped quotes, and embedded newlines are parsed by PapaParse.
Can I edit a large file?
Moderate files work well; very large grids may be limited by browser memory and rendering speed.
Will Excel preserve leading zeros?
CSV does not store types. Spreadsheet apps may reinterpret values such as 00123, dates, or long numbers.