A STARTING POINT, MADE FOR YOU
The data cleaner
toolbox.
Inspect columns, standardise cells and remove duplicate records locally.
INSIDE THE TOOLBOX
Starter collection8 useful places to start.
Exact text, missing-value and numeric rules are shown in each tool. Keep an original copy before transforming data.
CSV column profile
Inspect missing values, distinct values and numeric summaries by column.
Remove duplicate CSV rows
Keep the first row for each complete record or chosen key.
Fill empty CSV cells
Replace empty values across a table or in one column.
Clean CSV cell whitespace
Trim cell edges or collapse internal whitespace without changing headings.
Find & replace in CSV cells
Replace literal text inside selected cells while keeping the table structure.
Rename CSV columns
Apply an explicit heading map while preserving cell contents.
Round a CSV numeric column
Round decimal values with exact half-away-from-zero ties.
Extract CSV date parts
Add calendar fields from a strict ISO date column.
SMALL TASKS. LESS FRICTION.A few things you
A few things you
can tick off.
- Profile missing and mixed-type values
- Keep the first record for each key
- Round decimal strings with a stated tie rule