Cleaning messy data in Excel is both an art and a science.
Often the same cells contain multiple types of information that need to be separated, you have garbage information to remove, or columns contain a mix of different things.
Here I go through three examples of messy spreadsheets, showing some of the methods I use to fix them.
The examples I use here are from fantasy football sites, but the methods I demonstrate should be useful even if you don’t care about fantasy football.
Cleaning messy data in Excel is one of my specialties, and I’d like to make this into a series.
So if you have any spreadsheets that are total disasters you’d like me to fix, please send them my way.
Or if you need help cleaning messy data in Excel for something confidential, or more extensive than what can be done in a public video, that’s a service Rockstar Excel offers.
Related links
How to standardize names in Excel
Using the & (ampersand) to combine text
Table Capture plugin for Chrome
Data sources
Want to learn more about Excel?
Check out our Courses and Consulting page for upcoming classes.
And please subscribe to our newsletter to be notified of any future courses, and get monthly tips on how Excel can make your life easier.
You can also submit questions to be answered in a future blog post or video, or book a free consultation to find out how we can save your business time and money with our done-for-you solutions.
Pingback: Build a Dungeons and Dragons encounter tool in Excel - an XLOOKUP tutorial - Rockstar Excel