What Is Dirty Data?

Before you can clean data in Excel, you need to clearly understand what "dirty data" is and why it causes problems.

The biggest issue is that Excel treats values based on their internal format, not just how they look. Because of that, even small inconsistencies can completely break formulas, sorting, or filtering.

This usually happens when data comes from outside sources. For example, when you copy data from a website or import a CSV file, Excel may not correctly recognize numbers, dates, or text. As a result, you get a mix of formats inside one column, even though everything visually looks similar.

Let's look at a very simple example:

At first glance, everything looks correct. All salaries seem to be numbers. But there is a hidden problem: "3000" is stored as text, not as a number.

This leads to unexpected behavior when adding, subtracting, and so on.

Key Insight

Dirty data is dangerous not because it looks wrong, but because it looks correct while behaving incorrectly.

That's why the first step in working with Excel data is always: carefully inspect what type of data you actually have, not just how it appears.