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
If Excel asks to remove leading zeros, click "Don't Convert" to keep them.
- Put 00123 and 0912345678 in a small CSV.
- Convert file.
- 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.