CSVStitch

CSV to Excel and keep leading zeros

A code like 00123 or a phone number like 0912345678 is text, not a quantity. A spreadsheet that stores it as a number keeps 123 and 912345678 instead.

Use this when the zero is part of the code. A plain amount, with no opening 0, is still stored as a number.

🔒 Your files stay in your browser and are never uploaded

  1. Put 00123 and 0912345678 in a small CSV.
  2. Convert file.
  3. The first cell must still show 00123 before you download.

Common problems

A postal code 00123 and a phone number 0912345678 are identifiers. If a spreadsheet stores either one as a number, the opening 0 is discarded and the code becomes shorter. This page writes those cells as text. Compare the read-back with the code you typed: five characters for 00123, and the 0 still in front of 912345678. A price that never had an opening 0 is unaffected and stays numeric.

Why does a spreadsheet drop the opening 0?

It treats 00123 as the number 123. A text cell is what keeps every digit, including the 0.

Does 0912345678 stay intact?

Yes. A phone number or a postal code is written as text, so the opening 0 remains in the cell.