Cells are edited as text
CSV has no spreadsheet cell types, formulas, or display formats. Values are edited as strings, which can be helpful for identifiers such as 00123 that you do not want a spreadsheet application to reinterpret.
Free browser tool
Edit CSV in a browser table with type-aware sorting, row and column controls, Undo, leading-zero preservation, and UTF-8 / Shift_JIS input.
Make small CSV edits in the browser when opening a full spreadsheet is overkill: fix a few cells, add a row, or add a column, then export the result again.
CSV has no spreadsheet cell types, formulas, or display formats. Values are edited as strings, which can be helpful for identifiers such as 00123 that you do not want a spreadsheet application to reinterpret.
A new row gets cells for the current columns; a new column adds a header and empty cells to existing rows. Header uniqueness is not automatically enforced, so inspect the first row before export.
The file can look fine while still violating required-column, date-format, or unique-ID rules. Run the relevant checker after editing if the CSV will be imported into another system.
BOM can improve compatibility with some Japanese Windows Excel workflows, while web/developer systems may expect UTF-8 without BOM. Follow the destination’s documented requirement.
Fix two prices and add one notes column in a 20-row catalog export. Use a spreadsheet for heavy formulas and analysis; use this editor when the task is genuinely a small text-table correction.