# Why You Want to Clean Up Your Data Before You Automate

> Want to clean up all your data before you automate? A process only needs the details it reads to be right. You leave the rest alone for now.

- Author: Impruvement (https://impruvement.com/en/story)
- Pillar: Integration
- Published: 2026-10-30 · Updated: 2026-11-04
- Canonical URL: https://impruvement.com/en/blog/why-you-want-to-clean-up-your-data-before-you-automate

You want to clean up all your data first because without a process you have no yardstick, so every column seems to count. Your first automated process only needs the details it reads to be right. You leave the rest alone until a process needs it.

## Do you have to clean up your customer list before you automate?

No. You only clean up the slice your first process touches. Your customer list can hold duplicates, old addresses and empty columns and still carry a process. All it takes is that the two or three columns it reads are right.

Cleaning up without a process has no end, because you have no yardstick. You don't know which column counts, so to you every column counts. While you clean, new entries keep coming in. The cleanup turns into a permanent project, and your automation starts later than it has to.

The process decides what clean means. Not the other way round.

## Which details does your first automated process need?

It needs exactly the details it reads to produce its result, and no more. You find them by asking at every step: what has to be in place here for it to move on?

Take an email enquiry that automatically books an appointment, sends a confirmation and reminds both sides. This process reads three details: name, email address and preferred date. Your calendar is where the result goes. Your price list doesn't appear anywhere in it. Whether it's out of date makes no difference to your start.

That's why you can say exactly how tidy your data has to be. Every detail the process reads sits in one binding place and has a fixed format. A date is always a date, never "Tuesday next week". The process asks nothing more of you. If your details still live mostly on notes and in spreadsheets, read [Paper Chaos in Your Office: The First Step Out of Notes and Excel](https://impruvement.com/blog/paper-chaos-in-your-office-the-first-step-out-of-notes-and).

## What do you do when your data is scattered across Excel, emails and notes?

You set exactly one source for every detail your process reads. Every other place stays as it is for now.

Say your customer addresses sit in an Excel spreadsheet, in your inbox and on sticky notes by your screen. For the booking process, you declare the spreadsheet the valid source for email addresses. You don't work through the notes in advance. You transfer an address only when the process needs it.

Then you decide what happens when something goes wrong. If a detail is missing or its format is wrong, the process tells you instead of quietly carrying on. That way you clean exactly the records that are actually needed. It happens at the pace of your work, not in advance.

You might be thinking: then the rest stays messy. Yes, until a process needs it. Until then it doesn't cost you a single extra hour.

Do you notice that tidying up comes before starting more often than the job calls for? Then the pattern runs deeper than your data. That's exactly where the challenge comes in: four days, one tangible first step. Sign up at [impruvement.com/en/challenge](https://impruvement.com/en/challenge).

## Frequently Asked Questions

**Do you have to clean up your whole customer list before you automate?**

No. You only clean up the two or three columns your first process reads. Duplicates, old addresses and empty columns elsewhere can stay for now.

**How do you find out which details your first process needs?**

You ask at every step what has to be in place for it to move on. Whatever the process doesn't read, you don't need to clean.

**What happens if a detail is missing or in the wrong format?**

The process reports it to you instead of quietly carrying on. You then fix exactly that record, at the pace of your work.

## The Next Step

The Challenge: four days, free, one video a day — https://impruvement.com/en/challenge