CSV data cleaner
Diagnose a dirty CSV and clean it with auditable steps: a full local profile of every column, a suggested fix plan you approve item by item, and deterministic local execution with a change log.
About this tool
Every imported CSV is dirty in its own way: empty cells, exact duplicates, amounts stored as "$1,200.00", three date formats in one column. Downstream tools fail on all of it. This cleaner starts with a full local profile of your file — per-column types, empty rates, unique counts and duplicate rows — computed over every row, not a sample.
The model sees only that profile, never your data, and proposes a cleaning plan. You tick the steps you approve — trim, dedupe, drop empty rows, fill blanks, normalize amounts and dates, lower-case email columns — and deterministic local code executes them. Every step lands in a change log with affected counts, and your original file is never modified.
How to use CSV data cleaner
- Upload a CSV (up to 10 MB) or paste CSV text — it is profiled entirely in your browser.
- Add your provider API key in the key panel.
- Review the per-column diagnosis and the suggested cleaning plan, tick the steps you want.
- Apply the ticked steps locally and download the cleaned CSV with its change log.
Keep the original files and inspect the exported result before publishing or sharing it.
Frequently asked questions
What does the AI actually see?
Only the column profile — names, types, empty rates, value counts and up to 3 sample values per column. Your full data is never sent; cleaning itself runs locally with deterministic code.
What can it fix?
Trimming, exact duplicate rows, fully empty rows, filling empty cells, normalizing amounts like "$1,200.00" to plain numbers, converting dates to ISO, and lower-casing columns like emails.
Can I undo a cleaning step?
The change log records exactly what each step changed (how many cells or rows, in which column), and your original file is never modified — download a fresh copy and re-run with different steps any time.
How is this different from the AI data analyst?
The analyst answers questions about a CSV. This tool is a cleaning pipeline: profile, plan, apply, audit.
Related tools
- AI chat — Chat with OpenAI, Claude or Gemini using your own API key. Your key stays in your browser; requests go straight to the provider.
- AI summarizer — Summarize long text with your own OpenAI, Claude or Gemini API key. Brief, detailed or bullet-point summaries, all in your browser.
- AI translator — Translate text between 30 languages with your own OpenAI, Claude or Gemini API key. Private by design: key and text stay with you and the provider.
- AI writing assistant — Improve, expand, shorten or re-tone your writing with your own API key. Six editing modes, direct browser-to-provider calls.
- AI code explainer — Paste code and get a plain-English explanation using your own OpenAI, Claude or Gemini API key. Language auto-detect included.
- AI PDF chat — Upload a PDF and ask questions about it. The PDF is parsed in your browser; only the extracted text and your question go to your chosen AI provider.
- AI image analyzer — Upload an image and let AI describe it, extract text (OCR), or identify objects. Uses vision models from OpenAI, Claude or Gemini with your own key.
- AI voice generator — Turn text into natural-sounding speech with OpenAI TTS. Six voices, speed control, play in the browser and download MP3.
- AI data analyst — Upload a CSV and ask questions in plain English. The file is parsed locally; the AI sees only a schema summary and sample rows.
- AI spend analyzer — Turn your AI provider usage export into an independent cost receipt: per-model and per-day breakdowns, spike alerts and a monthly projection. Runs 100% in your browser — your billing data is never uploaded.