Excel Removed Leading Zeros From My CSV? The Courier Desk

2026-10-29

It is 8:52 on a Tuesday morning, and you are standing at the courier depot counter with a laptop balanced on a stack of flat boxes.

Behind you, a man in a hi-vis jacket sighs the way people sigh when they have a van waiting. In front of you, the clerk is scrolling through your upload and frowning.

"These postcodes," she says. "Four digits. They need five."

You look at the screen. Row after row of customers in Dresden, Leipzig and Chemnitz, all with a postcode that has lost its first character. 01067 is now 1067. 04109 is now 4109. Your brain does the quick, useless thing it does when something small goes wrong in public: I only opened the file. I didn't even change anything.

The zero that went missing

Let's call you Jonas. You are an illustrative character, but you will probably recognise him. He runs a small online shop selling hand-blended tea, alone, from a spare room and a garage shelf.

The shop platform lets you export orders as a CSV. Yesterday, you opened that file in Excel just to have a quick look. You sorted a column, fixed a typo in one address, and saved. It felt like nothing. It felt like closing a drawer.

Excel, helpfully, had decided that a postcode is a number. And numbers don't start with zero.

So the zero vanished. Quietly. No warning, no red cell, no message. Just a file that looked almost right.

What it quietly costs

The frustrating part isn't the four-digit postcode. It's everything around it.

You stand at the counter, trying to remember whether you have the original export somewhere. You do, but it's in a folder called "orders_final_2", next to "orders_final_2_NEW". You're not sure which one is untouched.

Then the other thoughts arrive, the ones you don't say out loud:

• Did the phone numbers lose their leading zeros too, the ones the courier texts for delivery?
• What about the product codes? Half your SKUs start with 00, and your supplier is very particular about them.
• How many other files have you saved this way without noticing?

That last one is the one that sits in your stomach. It isn't the single mistake. It's the feeling that your data is slightly unreliable, and that you can't tell how much.

You apologise to the clerk. You apologise to the man in the hi-vis jacket. You step aside, and the queue closes up behind you like water.

You don't feel like someone running a real business. You feel like someone winging it with a laptop on a pile of boxes.

The fix that costs another hour

Back home, you do what everyone does. You search for how to put the zeros back. You find a handful of ways: formatting columns, adding apostrophes, importing instead of opening, padding values by hand.

Some of it works. Some of it works until the next export, when you forget, and the zeros leave again.

That's the pattern that wears you down. It isn't one catastrophe. It's a small chore that comes back every week, wearing a slightly different outfit. Postcodes today, phone numbers next month, invoice numbers after that. Each time, you lose twenty minutes and a little confidence.

And each time, there's the same quiet worry: what if I miss one, and it reaches a customer?

The moment it clicks

The turning point isn't dramatic. It happens on a Thursday, when a friend who builds websites sees you wrestling with a file and says, almost in passing:

"Why are you opening it in Excel at all?"

You stare at her. It had never occurred to you that the file could be looked after before it ever reached a spreadsheet. That the cleaning could be a small, repeatable step instead of a rescue mission. That text could simply stay text, and the report of what changed could be something you read, not something you reconstruct from memory.

It's a small idea. But it changes the shape of the problem. You stop being the person who fixes each file by hand and become the person who has a way of handling files.

A different Tuesday

Fast-forward a few weeks.

It's 8:52 on a Tuesday again. You're at the same courier counter, same flat boxes, same hum of the depot fridge. The queue behind you is just as long.

But the laptop is open to a file you didn't wrestle with. The postcodes have five digits. The phone numbers begin the way phone numbers should. You glance at a short list of what was checked and what was left alone, and you don't have to hold any of it in your head.

The clerk scans the upload and nods. "All good."

Two words. You almost laugh at how much they weigh.

You walk out into the cold air with your hands free, and the morning is still yours. There is time to get a coffee that isn't from a machine. Time to answer two customer emails properly. Time to blend the autumn mix you've been putting off.

The zero isn't a big thing. But not having to think about it is.

If you recognise yourself

If you've ever opened a CSV, watched a zero disappear, and felt your day tilt a little, you're not careless. Excel is built to guess, and it guesses wrong on exactly the things small businesses depend on: postcodes, phone numbers, product codes.

There is a calmer way to handle those files. One of the tools we made is a Python toolkit for cleaning messy CSV and Excel exports: duplicates, dates, phone numbers, encoding, splitting, merging and validating. It can do a dry run first, and it gives you a change report so you can see what happened before you trust it. It is made with AI, checked automatically, and refined by real use, and 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 the Tuesday you'd like, you can take a look here: Clean Data in Minutes – CSV & Excel Cleaning Toolkit (Python).

An illustrative story, written with AI assistance.