Turn a noisy CSV into one that charts and spreadsheets can read cleanly. Opt-in cleaners trim whitespace, strip currency signs, normalize NA tokens, drop empty rows / columns, and dedupe.
Runs before any of Plotiq's chart tools to guarantee a good plot.
Drop the file or paste CSV text. Plotiq parses it live and previews the raw rows on the left.
Trim whitespace, NA→blank, strip currency signs, drop empties, dedupe — every cleaner is a standalone toggle.
A stat chip row shows exactly what changed: "12 cells trimmed · 3 duplicates removed", etc.
Common missing-value placeholders — NA, N/A, null, none, "-", "--" — get rewritten to empty strings so your charting library treats them as actual missing values, not noise.
No. The number cleaner only strips formatting noise (currency symbols, thousand separators) from cells that are already numeric-looking. Leading-zero strings like 007 stay untouched.
Yes. A chip row above the cleaned output shows, e.g. "12 cells trimmed · 3 NA normalized · 2 duplicates removed" — only cleaners that actually changed something show up.
Yes — running it twice on the same file gives the same result as running it once. Safe to bake into a scripted pipeline.