Messy CSV Exports Every Week? The Cabin Draining Board

2026-10-17

The laptop sits on the draining board because it is the only flat surface at the right height.

Behind Marit, rain runs down the cabin window. In the next room two kids argue happily about a board game. The kettle clicks off. She doesn't hear it, because on screen is the same file she opened last Friday, and the Friday before that.

A supplier export. Three hundred and some rows. Dates in two formats. Phone numbers with and without country codes. A name column where "Müller" has turned into "Müller". And the same customers, again, two or three times each.

It is Wednesday of half-term week. She told everyone this was a holiday.

The holiday that isn't one

You know this kind of week. You are technically away. The cabin is real, the rain is real, the walk to the lake is real. But so is the Thursday report, and the report starts with that file.

So you do it "quickly" between breakfast and the walk. Find and replace. Sort by name. Squint at the duplicates. Delete a row, wonder if it was the right one, and press undo. Fix a date, then notice the next ten are still wrong.

It is never quick. It is a small, fiddly job that makes you feel like a clerk and not like someone who runs her own work.

And the quiet part, the one you don't say out loud, is the fear. Not of the mess itself, but of the row you missed. The number that looks right and isn't. The email that goes to the same person twice, or to nobody.

What it costs, quietly

Nobody sees this cost on an invoice.

It is the hour on Friday afternoon that was meant for something else. It is the Sunday evening feeling when you remember the export is coming tomorrow. It is the way you start a Monday already slightly tired, because part of you is bracing for the file.

It is also the confidence you lose in your own work. When you clean something by hand, you can never fully say it is clean. You say "I think so." You say it to the client, and you say it to yourself at 2 am.

Marit has said "I think so" a lot this year.

The pause by the sink

She is halfway through the date column when her daughter appears at her elbow, holding a tiny plastic hotel.

"Are you still working?"

"Nearly done."

"You said that before breakfast."

It isn't an accusation. It's just a fact, delivered the way children deliver facts. Marit looks at the screen, then at the hotel, then at the rain.

And a thought arrives, not dramatic, just clear: this is the same job every time. Why am I doing it like it's new?

The file is different each week. The mess is not. The same handful of problems, in the same handful of columns. She has been solving them from scratch, by hand, every single time, as if no one had ever seen a messy export before.

It doesn't have to be like this.

A different Wednesday

Picture the same cabin, the same rain, the same draining board.

The file arrives. You open it, but not to fix it. You run it through something you trust and let it show you what it would change before it changes anything. Duplicates found. Dates made consistent. Phone numbers tidied. Odd characters repaired. A short report of what happened, row by row, so you are not saying "I think so" any more.

You read the report with your tea. It makes sense. You nod. The clean file is ready.

The whole thing takes about as long as the kettle.

Then you close the laptop. Not "later". Now. You go and lose a game of hotels to a seven-year-old, and nobody checks the time.

Monday, afterwards

This is the part that surprises people.

It isn't the hours saved, though they matter. It's how Monday feels. The export lands in your inbox and your shoulders stay where they are. You don't groan. You don't put it off until the afternoon, and then the evening.

You have a routine for it, and the routine has a record. If a client asks "what did you change in that file?", you have an answer. A calm, specific, honest one.

That is what it feels like to run a real business with real tools. Not grand. Just quiet.

If you recognise yourself

Maybe your version isn't a cabin. Maybe it's the desk in the spare room, the train home, the ten minutes before a call. The file is always slightly different and always the same kind of mess.

If you're tired of fixing it by hand, there is a gentler way. We made the Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python) for exactly this: removing duplicates, fixing dates, phones and encoding, splitting and merging, and validating, with a dry-run first and a change report afterwards, so you can 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.

You can look at it here, whenever it suits you: Clean Data in Minutes – CSV & Excel Cleaning Toolkit

And if not today, that's fine too. Go and see how the board game ends.

An illustrative story, written with AI assistance.