Clean my data
Tidy a messy table in seconds
Trim spaces, remove duplicates, fix dates and numbers, split names and more. Everything runs in your browser, so your data stays on your device.
- Private: nothing uploaded
- CSV, TSV and Excel
- Undo any step
- Unlimited quick-clean
Only your column names and types are sent to the AI. Your rows stay in this browser.
Quick clean
Steps applied
Preview
What it fixes
The usual suspects in messy data
Invisible spaces
Leading, trailing and double spaces, plus non-breaking spaces from web pages, which break lookups.
Mixed date formats
31/12/2026, Dec 31 2026 and Excel serial numbers all become 2026-12-31.
Numbers stored as text
"$1,234.50", "1.234,50 €" and "(300)" become real numbers you can sum.
Duplicates
Remove repeated rows, matched on the whole row or on the columns you choose.
Inconsistent case
jOHN smith and JOHN SMITH become John Smith, or any case you need.
Combined columns
Split full names, addresses or tag lists into separate columns.
More free spreadsheet tools
Everything you need when a formula gets in the way.
- Formula generatorDescribe it in plain English, get a working formula.Open tool
- Formula explainerPaste any formula and see what each part does.Open tool
- Formula fixerFix #N/A, #VALUE!, #REF! and wrong results.Open tool
- Excel ↔ Sheets converterTranslate formulas between Excel and Google Sheets.Open tool
- VBA & Apps ScriptMacros for Excel and scripts for Google Sheets.Open tool
- Regex formulasExtract, match and replace text with REGEX functions.Open tool
- Conditional formattingCustom-formula rules to highlight cells and rows.Open tool
Frequently asked questions
Is my data uploaded anywhere?
No. Files are read and cleaned inside your browser. When you use "Plan with AI", only your column names and their detected types (such as "date" or "number") are sent, never the rows themselves.
What file types can I use?
CSV, TSV and Excel files (.xlsx and .xls). You can also copy a range in Excel or Google Sheets and paste it straight into the box. For Excel files, the first sheet is used.
How do I get the cleaned data back into my spreadsheet?
Click "Copy table" and paste into Excel or Google Sheets, or download a CSV or Excel file. Each step also shows the equivalent formula if you prefer to clean inside your sheet.
How are dates like 03/04/2026 handled?
The tool checks the column for values that can only be read one way (like 25/03/2026) and uses that order. You can also set day-first or month-first yourself. Dates are converted to YYYY-MM-DD, which every spreadsheet understands.
Is there a size limit?
Tables up to about 100,000 rows work well in most browsers. The preview shows the first 100 rows, and every step applies to the whole table.