Data Cleaner

Fix spaces, capitals, numbers stored as text, dates, blanks and duplicates in one go.

๐Ÿ”’ Runs in your browserโšก Instant results๐Ÿ‘ค No sign-upโญ Downloads with Pro

Clean messy spreadsheet data in one click

Exports from other systems are rarely tidy: extra spaces, invisible characters, numbers Excel won't add up because they're stored as text, dates in the wrong format, blank rows and duplicates. Drop the file in, tick what to fix, and download a clean copy. Every changed cell is highlighted so you can see exactly what happened.

What it fixes

Frequently asked questions

Will it change my original file?

No. You download a new, cleaned copy. Your original file is never changed or uploaded.

Why are some numbers not converted?

Values with leading zeros, like product codes 00123 or phone numbers, are kept as text on purpose so the zeros are not lost.

More data analysis & spreadsheet tools

๐Ÿ“Š
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
๐Ÿ“ˆ
Instant DashboardPower BI style dashboard from any Excel file
๐Ÿ”
CSV โ†” Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
๐Ÿงฉ
Excel File MergerCombine many spreadsheets into one
๐Ÿงน
Duplicate RemoverFind and delete duplicate rows
๐Ÿ“ˆ
Chart MakerPaste data, get a chart, download PNG or PowerPoint
๐Ÿ—„๏ธ
Excel to SQLCREATE TABLE & INSERT statements from any spreadsheet
๐Ÿงฎ
SQL Query BuilderBuild SQL with clicks, explained in English, run on your data
โœจ
SQL FormatterMake messy SQL clean and readable
๐Ÿงฝ
Data CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
๐Ÿ”—
VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
๐Ÿ†š
Compare Two Excel FilesSee added, removed and changed rows and cells
๐ŸงŠ
Pivot Table BuilderGroup, total and chart your data with clicks
๐ŸŒ
Web Table to ExcelCopy tables from websites into clean Excel
๐Ÿ”ฃ
JSON โ†” Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
๐Ÿ“
UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
๐Ÿ”„
Unpivot / Reshape DataColumns to rows and back, ready for Power BI
๐ŸŽฏ
Outlier FinderSpot unusual values, typos and errors
๐Ÿ“
Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
๐ŸŽฒ
Random Sample PickerRandom rows for audits, surveys and prize draws
๐Ÿงช
Test Data GeneratorRealistic fake UK data for testing and demos

See all 108 tools โ†’