Same Customer Spelled 5 Ways in Excel? The Fair Stand

2026-10-27

The question at the folding table

It is 11:20 on the second day of the regional trade fair. Your stand is a folding table, a roll-up banner and a tablet leaning against a box of flyers.

A man in a lanyard stops. He says he works with Hartmann Logistik, and that your name came up in a meeting. Then he asks the question that sounds easy.

"How much work have you actually done for them?"

You smile. You know the answer is somewhere on the tablet. You open the customer export you saved last week, tap the search field and type Hartmann.

Five rows appear.

Hartmann Logistik. Hartman Logistik GmbH. HARTMANN LOGISTIK. Hartmann Logistic, with a c. And one with a trailing space you cannot even see, but which sorts to the bottom like a stray sock.

They are all the same client. The spreadsheet does not know that.

The quiet arithmetic of a messy list

You say, "Let me check, it's spread across a few entries." That sentence is true, and it also sounds like something a person says when they are winging it.

The man waits politely. Behind him, someone else is reading your banner.

You scroll. Three projects here, two there. Is the invoice from March under Hartman or Hartmann? Did the retainer get counted twice, or not at all? The total at the bottom of the sheet says one number, but you no longer trust it.

This is the part nobody talks about. It is not a disaster. Nobody is angry. It is just a small, constant fog:

• You are never completely sure how many clients you have.
• The "top five clients" list is wrong, and you half know it.
• The newsletter you send goes to the same person three times, in three slightly different spellings of their name.
• Every time you need a real answer, you first have to clean before you can look.

So you do not look as often as you should. That is the real cost. Not the spreadsheet, but the questions you stop asking because the answer takes an hour to trust.

What you say instead

You tell him, "Roughly a year of regular work. I'll send you exact figures after the fair."

He nods, takes a flyer and moves on. It went fine. Nothing bad happened.

But you stand there for a moment with the tablet warm in your hands, and you feel it: the little drop in your stomach of not a real business. Real businesses know their own clients. Real businesses can say a number without apologising for it.

You also know exactly how this goes. On Sunday evening you will sit down to fix it. You will sort by name. You will merge two rows, then discover a third. You will lose a phone number in the merge. At 21:30 you will wonder whether Hartman and Hartmann are really the same company or two different ones. You will leave it "for later".

It has been "for later" since spring.

The turning point, on a bench by the coffee van

During the lunch lull you sit on a bench behind the exhibition hall with a paper cup of coffee that is too hot. A woman from the neighbouring stand, who sells handmade soap, is sorting her own order sheets next to you.

You mention the Hartmann problem, half joking. She laughs. She says she once had one customer in her list under her first name, her married name and her email address.

Then she says something simple. "It's not you being sloppy. It's that every export, every form and every marketplace spells things its own way. Nobody types the same name twice."

That lands. You had been treating the mess as a personal failing. It is not. It is what happens when data arrives from five places and nobody tidies it in between. A thing that happens by default can also be handled by default, quietly, once, instead of by hand at the worst moment.

The idea that stays with you is small. What if the cleaning was not a project? What if it was just a step you run, with a preview first, so nothing gets changed behind your back, and a short note afterwards of what was merged and why?

A different Monday

Picture the Monday after the fair.

You open your coffee, then your customer list. It is the same export as always, with the same untidy spellings. But this time you run it through something once, look at what it would change before it changes anything, and read a short list: five rows became one. A trailing space gone. Two phone numbers written the same way now.

Then you type Hartmann into the search field and see a single row, with a total you trust.

You reply to the man from the fair in two minutes, with a real number in the email. You do not apologise in the second sentence.

It is 9:40. The rest of the morning is yours. Oddly, the thing you notice most is not the time saved but the feeling: you are the person who knows their own business.

If this was your trade-fair moment too

If you recognised the five spellings, the unseen trailing space and the "let me check" smile, there is a small, calm way out. We built the Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python) for exactly this kind of weekly chore: deduplicating, fixing dates, phones and encoding, splitting and merging, and validating. It does a dry run first and gives you a change report afterwards, so you always see what happened.

It comes with a 30-day money-back promise: if it doesn't help, you get a full refund, no questions.

Have a look at the CSV & Excel Cleaning Toolkit

An illustrative story, written with AI assistance.