What this tool does
You open a CSV, then clean it with a series of steps (remove a column, sort, filter, fill cells…). Every step is recorded in the Script panel on the right. Your original file is never changed — you Export a new cleaned CSV when done.
Because the steps are saved separately, you can Save script once and replay the exact same cleaning on next month's file in one click.
Getting started
- Open CSV (or drag a file onto the window), or Load sample to try it.
- The table shows your data. Column letters
A B C… sit on top, row numbers down the left — just like a spreadsheet.
- New session clears everything to start fresh.
- Header control (top-left of the table) sets which line is the column header:
first row, none (columns become A, B, C and every row is data),
or file line… to point at the real header when the file has comment/preamble lines above it.
Your choice is remembered and used as the default for the next file you open.
Adding steps
- Click + Add step at the bottom of the Script panel and pick an action.
- Or use shortcuts on the table: click a column's
⋯ menu to remove/rename/move it, or drag a header to reorder.
- Each step has its own little editor — change a dropdown or value and the table updates live.
- Toggle a step off with
☑, reorder with ↑ ↓, or delete with ✕.
The actions
The + Add step menu is grouped into Columns, Rows, and Cells.
- Insert column / row — at start, end, or before/after a chosen column or row number. The fill value can target specific rows/columns (numbers, letters, or ranges like
A:C) or fill everything.
- Remove column(s) — remove one or many at once by name, letter, or range (e.g.
notes, A:C, H).
- Remove row(s) — delete rows by number/range (e.g.
2,4-6).
- Rename column and Set column order (or just drag headers) — reshape the columns.
- Fill / set cells — write a value into a whole column, a whole row, or specific cells; with an optional “except these rows/columns”.
- Format date — reformat a date column, e.g. turn
2026-06-27T15:30:45Z into 2026-06-27 (several output formats).
- Move row to top / to position — pull a matching row where you want it.
- Sort rows (text or numeric) and Filter rows (keep or drop matches).
Editing cells directly
Click any cell and type — the edit is recorded as a step too, so it survives and replays. Re-editing the same cell just updates that step.
Navigating large files
Use the pager above the table to change rows-per-page and jump between pages or to a specific page. Export always writes all rows, not just the visible page.
Undo / Redo & scripts
- ↶ Undo step / ↷ Redo step step backward and forward through your actions.
- Save script downloads your steps as a
.json; Load script replays it on the current file.
- Export CSV writes the cleaned result to a new file.
Tip: your source file on disk is never modified. Worst case, just export again. Press Esc or click outside to close this guide.