Close
Time left to register for Excel Made Easy class
Cleaning messy data in Excel

Cleaning Messy Data in Excel

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

Filters: Excel’s easy button

How to standardize names in Excel

Using the & (ampersand) to combine text

Table Capture plugin for Chrome

Data sources

Fanstasy Pros

Yahoo Sports

ESPN

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.

1 thought on “Cleaning Messy Data in Excel”

  1. Pingback: Build a Dungeons and Dragons encounter tool in Excel - an XLOOKUP tutorial - Rockstar Excel

Leave a Reply