Messy CSV Export Every Week? The Conference Coffee Line

2026-10-18

The coffee line at the conference hotel is twelve people long. Priya is eighth.

She isn't thinking about coffee. She's holding her phone at an awkward angle, thumbnail on the corner of an attachment: orders_export_week41.csv. The same name as last week, with a different number at the end.

She knows what's inside without opening it. Dates in three formats. Names with a space after them that you can't see. The same customer twice, once in capitals. A phone number that lost its leading zero somewhere between the supplier's system and her inbox.

She's here to hear a talk about growing a small business. Her real week is waiting in that attachment.

The Monday that has a shape

Every freelancer and small team has a task like this. It isn't big, and nobody would call it a crisis. It comes back every week, and it comes back a little different each time.

Priya runs the data side for a few small clients. One of them sends this export every Monday. It feeds a report she promised would be ready by noon. Her promise was easy to make, back when she imagined the file would arrive clean.

So Monday has a shape. Open the file. Sigh. Sort by the column that's probably the date. Scroll. Find the row where a comma in an address pushed everything one cell to the right. Fix it. Scroll again.

Forty minutes later she gets to the actual work. By then she's already a little tired and a little resentful. She's not even sure of the file. Did she catch every duplicate, or only the ones she happened to see?

The cost nobody puts on an invoice

The forty minutes isn't the part that bothers her.

The part that bothers her is the quiet doubt afterwards. She sends the report at 11:52 and spends the next hour half-listening in other meetings, wondering whether one wrong row slipped through. She never says it out loud, because it sounds like a small thing to worry about.

It's also the Mondays that were supposed to start with something she's good at, and start instead with cleaning up after a file. It's the feeling of being a professional with a clever laptop who's spending her best hour on trailing spaces.

She once worked out, roughly, how often she'd done this fix. Then she stopped working it out, because the number made her stomach drop.

A small thought in a long line

The barista calls a name that isn't hers. The line shuffles forward.

The speaker had said something in the opening session that stuck with her. It was nothing dramatic, just a throwaway line: if you've done it by hand three times, the fourth time is a choice.

Priya looks at the attachment again.

It isn't that she can't fix the file. She can, and she's very good at it. That's exactly the trap. She's so competent at the cleanup that she never asked whether it should still be her job every single week.

For the first time the thought arrives without guilt. What if the file just arrived the way I fix it, and I only had to look?

She imagines a Monday where she still opens the export, but this time she can see a short list of what would change before anything does. Fourteen duplicates. Dates made consistent. Two phone numbers flagged for a human to glance at. Nothing silently rewritten, nothing she has to take on trust. Then one calm click, and a tidy record of what happened that she could show a client if they ever asked.

It's a small picture, and it doesn't feel like a miracle. It feels like relief.

The same Monday, a different way

The next week, nothing dramatic happens. That's the point.

Priya makes tea at home, at her own table, with the window open a crack. The export arrives with its usual cheerful, slightly broken name. She opens it, glances over what's about to change, and nods.

There's no scrolling and no hunting for the row that slid one cell to the right. Ten minutes in, she's already working on the part of the report she actually enjoys, the part where the numbers say something.

She sends it at 9:40. Two hours early. She doesn't spend the late morning wondering. When the client replies with a quick thumbs-up, she doesn't feel relieved so much as settled, the way you feel when the front door is locked and you don't have to check it.

The afternoon is just an afternoon.

What actually changed

The exports didn't get better. They're still messy, because the supplier's system hasn't changed and probably won't.

What changed is whose problem it is. The mess stopped being a personal weekly chore and became something she can see, check and set aside. The first hour of Monday went back to her.

If you recognise Priya, if there's a file that comes in every week and you've been fixing it by hand for longer than you'd like to admit, you aren't behind. You're good at something that should have been handed off a while ago.

If this is your Monday too

There's a toolkit we made for exactly this kind of weekly cleanup: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It tidies duplicates, dates, phone numbers and encoding, and it can split, merge and validate files. A dry run shows you what would change before anything does, and a change report tells you afterwards what it did.

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

The coffee, by the way, was fine. The talk was fine. What Priya remembers is the line, and the moment she realised the fourth time was a choice.

An illustrative story, written with AI assistance.