CSV Decimal Comma Won't Add Up in Excel? The Balcony Sum

2026-10-31

The sun is out, the sea is somewhere behind the next building, and you are on a balcony in Split with a laptop on your knees.

This is the week off you promised yourself. Except a client wrote on Monday: "Quick thing, could you send the sales summary by Thursday, 5 pm?" You said yes. Of course you said yes. It was a quick thing.

Now it is Thursday, 2:15 pm. The export from the shop system is open in Excel. You select the revenue column and look at the bottom bar, waiting for a total.

It says 0.

The column that looks fine and isn't

You look closer. The numbers are there: 49,90. 1.249,00. 12,5. They look like money. But they are hugging the left edge of every cell, and a tiny green triangle sits in the corner of each one.

You try the obvious things. You click the little warning icon. You retype one cell by hand and it turns into a proper number, which feels like progress for about four seconds, until you remember there are 3,800 rows.

You try again. Some rows convert. Some turn into dates. One becomes 12 May, which is not a price. Another is a long number with a point in it that makes no sense at all.

Somewhere down the page, a thought arrives that you don't say out loud: a real professional would not be sitting here, sweating over a comma.

What it quietly costs

It isn't the comma. It's what the comma does to the afternoon.

Your partner is waiting at the beach café. You told them an hour. The kind waiter has brought a second glass of water you didn't ask for. Every few minutes you type "just one more thing" in your head, and every few minutes it is not the last thing.

You also feel the small, familiar guilt. If you had charged for this properly, would you be doing it on holiday? If you had a system, would a decimal comma be a five-minute problem instead of a three-hour one?

And underneath that, the quieter fear: what if the total you finally send is wrong, and you never notice? A thousands separator read as a decimal. A price quietly divided by a thousand. The client trusts you with this number. That's why they asked you.

So you check. And check again. The checking is the real time thief.

The moment it tips

At 3:40 pm you stop.

You close the laptop halfway, not all the way, and look at the street below. A man is hosing down the pavement outside a bakery, completely unbothered by anything.

And a plain thought turns up: this is not the first time.

It was a date format last spring. A weird character in a customer's name the autumn before. Different file, same evening-shaped hole. Each time you solved it from scratch, felt clever for a minute, then forgot how. Each time you told yourself you'd keep a note of it. The note is not anywhere.

The problem was never this file. The problem is that every messy export arrives as a brand-new emergency, when it is really the same few small mishaps wearing different clothes.

What if the emergency part could simply be taken away? Not a heroic fix. Just a calm routine that looks at the file, shows you what it would change before touching anything, and hands you a short list of what it did. Something you could trust the way you trust a good colleague's "I've checked it."

You finish this one by hand, because the deadline is real. You send it at 4:52 pm, slightly shaky, with a sentence in your email you wish you hadn't needed to write.

Then you go and find the café.

A different Monday

Picture the same kind of week, a few months from now.

A client's export lands in your inbox on a Monday morning. Coffee is still hot. You glance at it, notice it comes from a system that writes commas where you'd expect points, and you feel nothing in particular. No tightening in the chest.

You run it through your routine. You read the short report: what was fixed, what was left alone, what looks odd and deserves your eyes. Nothing is changed behind your back. Your original file stays exactly as it was.

The total appears. It's a number you believe.

You spend your saved hour on something that actually earns money: replying to a prospect, tidying a quote, or simply leaving at six because you can.

That is what we mean by calm. Not that messy files disappear. They never will. It is that they stop deciding what kind of day you have.

If you saw yourself on that balcony

There is a small Python toolkit for exactly this kind of afternoon: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python). It tidies the usual suspects in exported files: duplicates, dates, phone numbers, encoding trouble, splitting and merging, validation. It runs a dry run first and gives you a change report, so you can see what would happen before anything does.

It's made for people who are comfortable running a Python script, and it doesn't replace your own judgement about what the numbers mean. It just takes the comma-shaped panic out of getting there. Like all our paid products, it comes with a 30-day money-back promise: if it doesn't help, you get a full refund, no questions.

If that sounds like your next messy Thursday, you can have a look at the toolkit here.

An illustrative story, written with AI assistance.