How to Preserve Leading Zeros in CSV Files

Why Leading Zeros Disappear

CSV stores everything as text. Spreadsheet apps then guess types when you open the file. Numeric-looking values like 02108 or 00045 get interpreted as numbers, and Excel drops the leading zeros because 2108 and 45 are the same numerically.

The CSV itself is fine. The reader stripped the zeros.

• US ZIP codes like 02108 become 2108.
• Employee IDs like 00045 become 45.
• Phone numbers like 0812345 lose the leading 0.
• Country codes and SKUs like 007A become 7A after conversion attempts.

The Two Root Causes

Fix the right cause. Do not blame the CSV.

Step-by-Step: Keep Leading Zeros Safely

Depending on which side you control, use one or more of these fixes.

• Preview the CSV in the Online CSV Editor and confirm zeros are present in the source.
• If double-clicking Excel strips them, use Data > Get Data > From Text/CSV and set the ID column to Text during import.
• If you send CSV to others, keep the ID column as text and document that.
• For database loads, define the column as VARCHAR/TEXT (not INT).
• For JSON output, keep the value as a string rather than a number.

import pandas as pd

df = pd.read_csv("employees.csv", dtype={"employee_id": str})
print(df["employee_id"].head())

const rows = parse(csv, { columns: true });
for (const row of rows) {
  row.employee_id = String(row.employee_id);
}

When You Cannot Change the Consumer

Sometimes a partner double-clicks the CSV and blames the file. Two workarounds help.

• Prefix values in Excel with a leading apostrophe (e.g., '02108) so Excel treats them as text. Note this changes the visible value if the recipient exports again.
• Deliver an .xlsx file instead of a CSV, where the column is explicitly typed as text.

Real-World Examples

This bug wastes hours across every industry.

Common Mistakes

The reflex fixes often make things worse.

• Padding zeros back in with a formula on the fly and forgetting to remove it before export.
• Assuming the CSV is broken when the reader stripped the zeros.
• Reformatting the entire column as text after the values already lost zeros.
• Loading into a numeric database column and losing precision permanently.

Best Practices

Treat ID-like columns as text everywhere.

• Define ID/postal/phone columns as text in source systems.
• Import CSV with explicit column types.
• Deliver .xlsx when partners insist on double-click.
• Use string types in JSON and database schemas.
• Verify sample rows after every conversion step.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and needs no account for everyday conversions. Preview zero-prefixed columns in the Online CSV Editor, then use the CSV to Excel Converter to deliver a workbook where types are explicit. Client-side workflows run on Windows, macOS, and Linux browsers.

Conclusion

Leading zeros in CSV survive when you treat ID-like columns as text end to end. The CSV was fine; the reader made assumptions. Fix the reader, or ship a workbook that leaves no room for guessing.