Same Company, Four Spellings in Your CSV? The 10 am Call

2026-11-03

It is 9:48 on a Tuesday. The call starts at ten.

You have the export open. Your client's finance lead wants to talk about the year so far: how much work, how many projects, what the budget looks like for next quarter. A simple question. You said, "Sure, I'll pull the numbers."

You sorted the column by company. And there it is.

Nordlicht GmbH. Nordlicht Gmbh NORDLICHT GmbH (space at the end) Nordlicht

Four rows that are one client. Four subtotals that should be one number. Your pivot table sees four strangers.

The sum that refuses to be one number

You try the obvious thing first. You type over a few cells. Then you notice that the invoicing tool wrote one spelling, your bank export wrote another, and the time tracker has its own habits. You fix six rows and find three more hiding further down.

The clock in the corner of the screen says 9:53.

You are not a careless person. You are the one who remembers birthdays and sends the reminder before the deadline. But right now the thought in your head is small and sour: a real business would have this sorted.

It is a thought that has nothing to do with your work. The work was good. The numbers just arrived in a mess.

What it quietly costs

Nobody puts this on an invoice, so it is easy to miss how much room it takes.

It is the quarter-hour here and the half hour there. It is the Sunday afternoon you spend "just tidying the export" and then lose to it. It is the small lie you tell on a call: "I'll send you the exact figure after the meeting." Not because you don't know your work, but because you don't trust your own file.

And sometimes it costs more than time. If one client hides behind four names, you cannot easily see that they are your biggest. Or that they still owe you for two projects. Or that the rate you gave them in spring was lower than you remember. The mess blurs exactly the things you most want to see clearly.

You don't say any of this out loud. You just close one spreadsheet and open another and hope the second one is kinder.

The call, as it went

At 10:00 you join with a cup of tea going cold and a number you are 80 percent sure about.

"Roughly forty-something thousand so far?" you say, and you hear the "roughly" land in the silence.

The finance lead is friendly. She says that's fine, she'll check on her side. Nothing bad happens. Nobody frowns. But when you hang up you feel it in your shoulders: that small flatness of having been less sharp than you are.

You look at the four spellings again. They look back, calm and a little smug.

The turning point is quieter than you think

Here is what changes things. It is not a better spreadsheet, or a stricter rule about typing names. It is the plain realisation that this problem is repetitive, and repetitive problems do not need your attention. They need a routine.

The names will be wrong again next month. A different export, a different typo, a trailing space from some form you don't control. That is simply how exports are. The question is whether you fix them by hand every time, squinting at row 212, or whether something does the squinting for you, shows you what it would change, and lets you say yes or no before anything is touched.

That last part matters. You don't want a tool that quietly rewrites your data. You want one that shows its work, so you stay the one who decides.

An ordinary Tuesday, afterwards

Picture the same morning, a month from now.

At 9:40 you drop the new export into a folder. You look at a short list of what would change: these four names are the same company, these two phone numbers have the same digits in different clothes, these three rows are exact duplicates. You glance through it, nod, and let it go ahead. A tidy file lands next to the original, which sits untouched.

At 9:46 you open the pivot table. Nordlicht is one line. One number. It is bigger than you thought, and that is useful to know before you talk about next quarter's rate.

At 10:00 you join the call and say, "Here is the exact figure." You hear how different that sentence sounds in your own mouth.

Then the tea is still warm when you finish. That is a small thing, and it is most of what calm looks like.

If this was your morning

If you recognise the four spellings, the 9:53 on the clock and the "roughly" you didn't want to say, you are in good company. Messy exports are not a character flaw. They are a chore that was never meant to be done by hand, again and again.

There is a small toolkit built for exactly this: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It removes duplicates, fixes dates, phone numbers and encoding, and splits, merges and validates files. It runs a dry run first and gives you a change report, so you see what happens before it happens. It comes with a 30-day money-back promise: if it doesn't help, you get a full refund, no questions.

No rush. Maybe just look at your next export and notice how long you spend on the names.

An illustrative story, written with AI assistance.