plotiq

CSV Cleaner Tool

Each cleaner is a toggle. Turn on only the ones you need — trim, NA normalize, number format cleaner, empty-row drop, empty-column drop, dedupe — and see the diff in real time.

Saves analysts a trip through pandas or OpenRefine for routine tidy-ups.

1. Load your CSV into the cleaner

Upload or paste. The raw rows appear on the left so you can see the "before" state.

2. Choose which cleaners to apply

Six opt-in cleaners. Flip each on or off and the output updates live — easy to compare before/after.

3. Download the plot-ready output

Copy to clipboard or save as .csv. The output is safe to feed into any chart tool or analysis pipeline.

How does the CSV Cleaner detect duplicate rows?

Exact whole-row match after the earlier cleaners run — so "Ada Lovelace" and " Ada Lovelace " collapse into one row when Trim is on.

Does the cleaner rewrite numeric columns automatically?

Only when you enable Clean Numbers. It strips "$", "€", "%", and thousand separators from otherwise-numeric cells — never from non-numeric strings.

Can I customize the NA values list?

Not yet — the current list (NA, N/A, null, none, "-", "--") covers 99% of real-world missing-value placeholders. File a feature request if you need a custom list.

Does the cleaner touch my header row?

Only to trim whitespace when Trim is on. NA normalization, dedupe, and number cleaning apply to data rows only — the header is always preserved.