Fixing a Messy CSV Again? The Sunday Roast Interruption

2026-10-16

The smell of roast potatoes is coming from the kitchen, and you are not in the kitchen.

You are at the end of your parents' dining table, laptop open between the gravy boat and a stack of napkins. Your sister has asked twice whether you want to carry the plates. You said "one second" both times.

On the screen: a CSV file. The same CSV file, or its cousin. Dates in three formats. Names with trailing spaces. A phone number that Excel turned into 4.9E+10. Rows that appeared twice, or maybe three times, you can't tell without squinting.

You lost last night to this file. Friday night too, if you're honest. And now it's Sunday, and the thing is still not ready.

The quiet arithmetic

Let's call you Jonas. He's not a real person, just someone many of us might recognise. He works for himself, doing reporting and data jobs for small shops and a couple of agencies. He is good at it. That's the annoying part.

The actual work, the part clients pay for, takes him an afternoon. The cleaning before the work takes the rest of the week, in scraps. A half hour here. A whole evening there. Never invoiced, never planned, never even named.

He doesn't say this out loud, but the thought sits under everything: I'm not slow. Why does it always take this long?

And under that, a smaller, meaner one: A real professional would have this sorted by now.

That's the cost nobody puts in a quote. Not only the hours. The feeling of being someone who is always catching up with their own files.

"Are you coming, or is that work?"

His father leans over, looks at the screen, and sees the spreadsheet with its grey rows and red cells.

"Is that work? On a Sunday?"

"Sort of," says Jonas. "It's the work before the work."

His father nods the way people nod when they don't quite understand but can see it's heavy. "Eat first. It'll still be there."

That's the thing. It will still be there. It always is.

He closes the lid. Not all the way. Just enough to stop the cursor from blinking at him. And for the first time that weekend he looks up and notices that the table is set properly, with the good glasses, and that his sister has made the effort with the horseradish he likes.

He has been in the room for an hour and has barely been in the room.

The question over the Yorkshire puddings

Halfway through lunch, his sister asks something harmless. "So what is it you actually do all day?"

He starts to answer, and hears himself say: "Honestly? A lot of it is tidying up other people's exports so I can get to the real job."

She laughs. "Like doing the dishes before you can cook."

He laughs too. Then he stops, fork in the air.

Because that's exactly right. And nobody washes the dishes by hand every single time if there's another way to do it. Not because they're lazy. Because the evening is worth more than that.

It isn't a big revelation. There's no music. It's just a small, quiet turn: maybe this doesn't have to be a weekly fight. Maybe it's a chore that can be handled the same calm way every time.

He doesn't know yet how. He just knows that it's allowed to be easier.

What a different Monday looks like

Imagine the same file arriving on a Monday morning. Same mess, same chaos from a system that was never built with you in mind.

This time you open it with a coffee in your hand. You look at what would change before anything changes. You see a short, plain report of what was fixed and what was left alone. You nod. You move on.

By the time the kettle has cooled, the file is ready, and you are doing the part of the job you actually enjoy: finding the story in the numbers, writing the email to the client, sending the invoice for work that went well.

No grey Sunday afternoon. No "one second" said twice. No quiet shame at the dining table.

The evening is just an evening. Maybe you cook. Maybe you do nothing. Either way it belongs to you.

That's the whole difference. Not a faster you. A calmer week.

Back at the table

Jonas helps clear the plates. His father, pleased, hands him a tea towel and says nothing about the laptop. The pudding is apple crumble, and it is still warm.

Later, in the car park, he doesn't open the laptop bag. He leaves it in the boot like a neighbour he'll visit tomorrow.

The file will still be messy tomorrow. But he has stopped believing that messy files are a verdict on him.

If you have ever spent a whole evening on a CSV file and then promised yourself it would be the last time, you know exactly why that scene matters. The work isn't the problem. The repeating is.

If you recognise yourself

There is a toolkit made for exactly this kind of Sunday: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It helps you clean messy CSV and Excel exports: duplicates, dates, phone numbers, encoding, splitting, merging and validating. It runs a dry-run first and gives you a change report, so you can see what would happen before anything is touched.

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

See the CSV & Excel Cleaning Toolkit

Either way, may your next roast be eaten hot, with the laptop closed.

An illustrative story, written with AI assistance.