Loading...
Loading...
Load CSV data into an editable table, modify cell values directly, and export the result as clean CSV.
Paste CSV into the input area and click Load for Editing. The table renders with each cell individually editable. Click any cell to place the cursor and type a replacement value. Changes are reflected immediately in the table without reloading the page. When edits are complete, click Export to download a properly formatted CSV.
This workflow is faster than opening Excel when you have a quick one-off correction to make. There is no import wizard, no format detection dialog, and no risk of Excel silently reformatting a numeric string like a product code or phone number into a different representation.
Fixing a single wrong value in a large export is the clearest case. If a customer's last name is misspelled in one row of a 500-row file, opening Excel, navigating to the cell, editing, saving, and re-exporting takes longer than pasting here and clicking the cell directly.
Correcting a date format in a handful of rows is another good fit. If five rows have dates in "DD/MM/YYYY" format but the rest use "YYYY-MM-DD", editing those five cells here and exporting produces a consistent file without writing a transformation script.
Adding a missing value before running an import script avoids a failed import on the first try. If a required field is blank in two rows, filling those cells here takes less time than debugging the error message from the import tool after the fact.
The Export button generates a properly RFC 4180 formatted CSV. Fields that contain commas, newlines, or double quotes are wrapped in double quotes. Internal double quotes are escaped by doubling them. The output is compatible with any standard CSV parser and can be re-imported into Excel, Google Sheets, or a database import tool without issues.
Can I add or delete rows?
The current editor focuses on cell value editing. To remove rows that match a condition, use the CSV Row Filter with an inverted condition. To add rows, append them to the raw CSV text before loading.
Does it preserve the header row?
Yes. The first row is treated as the header and is preserved in the output. Header cells are also editable — clicking a header cell and changing it renames that column in the exported file.
What happens to special characters in edited cells?
Any value containing a comma, double quote, or newline is automatically quoted on export. You do not need to manually add quotes. The exported file is safe to re-parse.