Data Cleaning Checklist for Spreadsheets and CSV Files
Step-by-step checklist to clean any spreadsheet before analysis or import: duplicates, formats, blanks, outliers and more.
Open the free Data Cleaning Checklist →What is the Data Cleaning Checklist?
Step-by-step checklist to clean any spreadsheet or CSV before analysis or import. It's completely free, needs no sign-up and works on any phone or computer.
Why it's helpful
- Step-by-step order
- Tick items as you go
- Links to the right tools
Who it's for
Analysts, office teams and students.
How to use it
- Work through each section and tick items off.
- Use the linked ReadyToUse tools for the slow parts.
💻 Open source: this tool is free and open source (MIT License). View the code on GitHub, download it and run it offline.
The bigger picture: Excel & CSV
Spreadsheets still run most offices. Cleaning data, converting formats and understanding formulas are daily tasks that eat hours; the right tool turns them into seconds.
What's changing: Excel and Google Sheets keep adding powerful functions like XLOOKUP, FILTER and LET, plus AI helpers. Knowing the fundamentals makes those features far more useful.
Frequently asked questions
Is my progress saved?
Yes, in this browser.
Related guides
