CSV Opens in Excel All in One Column? The Kitchen Table

2026-10-27

The Wednesday that was supposed to be a day off

It is 10:20 on a Wednesday, and you are at your parents' kitchen table. You told yourself this was a day off. The kettle has just clicked. Someone is humming in the next room.

Your laptop is open anyway, because the accountant wants the payment export by tomorrow.

You double-click the file. Excel opens it.

Everything is in column A. One long, ugly column. Dates, names, amounts and order numbers are all glued together with semicolons, like a sentence with no spaces. The cell is half-hidden behind a scroll bar.

You stare at it. You think: I only downloaded it. I didn't touch anything.

The small panic nobody mentions

Let's call her Ines. She is not a real person, only someone you might recognise. She sells hand-dyed yarn online, and she does it alone. Orders, dyeing, parcels and the shop's money all run through her.

She isn't bad with computers. She has just reached the point where one file decides whether the morning goes well.

So she does what we all do. She closes the file and opens it again. Then she tries "Open with", then a different download. She even checks that she is logged into the right account, as if the shop had sent the wrong export out of spite.

The humming in the next room stops. "Everything all right?"

"Yes, fine," she says. It's the voice you use when it isn't.

What it quietly costs

The file isn't really the problem. The problem is what it does to the day.

The forty minutes you meant to spend with your family turn into a hunt through forum threads and half-remembered menu options. You wonder if the data is broken or if you are. Then the thought arrives that you've seen the other half of this before. The dates will come out wrong next. The postcodes will lose their leading zeros. A customer's name will appear three times, spelled three ways.

It is a small, specific kind of feeling unprofessional. Other people's businesses seem to have a tidy back office. Yours has a kitchen table and a laptop at 10:20 on a Wednesday, and it is all held together by you.

None of it is dramatic. It just takes a bit of your calm every single time, and the calm adds up to something you'd have liked to keep.

The turning point, over a cold cup of tea

In the end Ines gets the columns split. She doesn't remember how, only that it involved a menu she'd never opened. A little relieved, she sits back.

Then she notices that the dates are in the wrong order, and the tea has gone cold.

There is a moment, with her hand around the mug, when something shifts. It isn't a big idea. It's a plain, tired sentence: Why am I doing this by hand every month?

The export is the same shape each time. It comes from the same shop, with the same quirks and the same separators. Excel guesses how to read it based on settings she never chose. The fix is always the same set of small repairs, and she makes them from scratch every time, as if for the first time.

It doesn't have to be like this. It can be a routine that runs the same way every time, instead of a rescue she improvises under pressure.

What a normal Wednesday could look like

Picture the same kitchen table.

The export arrives. Ines doesn't double-click and hope. She drops the file into the one small tool she trusts and lets it do the tidying. It splits what needs splitting and fixes the dates. It removes the duplicates and leaves a short note about everything it changed.

Before anything is saved, she can see what would change. She looks through the list, nods, and says yes.

Then she closes the laptop. The whole thing took a few minutes, and the tea is still warm.

The humming in the next room starts again. She walks in and asks what's for lunch.

Nothing about her business has changed, except that a chore that used to ambush her has become something she handles and forgets.

If this was your kitchen table

If you have ever stared at a single stubborn column and felt the day tilt, you know what this is about. It isn't a skills problem. It's the same small job, repeated, without a system behind it.

If you're comfortable with a little Python, we made a toolkit for exactly this: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It helps you clean messy CSV and Excel exports. It can dedupe, fix dates, phones and encoding, split, merge and validate. It runs a dry-run first and gives you a change report, so you can see what happened before you rely on it.

There is a 30-day money-back promise: if it doesn't help, you get a full refund, no questions asked.

If it isn't for you, that's fine too. Either way, we hope your next export opens the way it should, and that your day off stays a day off.

An illustrative story, written with AI assistance.