fbpx
Site logo white shadow

10 rules for Clean data in Excel

We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all 10 items are correct, data is clean. Simple and easy to use.

10 rules for Clean data

Remember, here we are talking about input data – not output (reports).

  1. Each column must have a heading
  2. No blank headings
  3. No duplicate headings
  4. No formulas in headings
  5. No merged cells
  6. Each column must have ONE meaning
  7. Each column must have ONE type of data
  8. No subtotals or grand totals
  9. Formatting should not be used instead of data
  10. Data must grow vertically, not horizontally
Watch this video to learn more.
This is the Hindi version.

Convert clean data to a Table

If you are using Excel, as soon as data is cleaned, convert it into a Table. Why? Here are the benefits of using Excel Tables – 13 articles.

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,811 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.