Map Extract
Free tool

Convert CSV to an Excel file without losing zeros

Paste or open a CSV, name the sheet, and download a proper .xlsx workbook. Numbers that are safe to convert become numbers you can add up; phone numbers, company numbers and anything with a leading zero stay as text, so Excel cannot strip them.

Runs in your browser. Nothing you enter is uploaded.

A short lead list into a workbook

Three columns here would normally suffer when opened from CSV: a phone number with no spaces, a review count and a company number that starts with zero.

With Store numbers as numbers ticked, only the review counts become numeric cells, because 48 and 4.6 convert back to exactly the same text. The phone and company numbers stay as text cells, zeros intact. The first row is written in bold and each column is given a width based on its content.

Input
business,phone,reviews,company_no
Kiln & Co Pottery,01632960410,48,09876543
Marlow Print Works,01632 960411,4.6,SC123456
Result
Leads.xlsx, sheet "Leads"
A: business (text)   B: phone (text, 01632960410 kept)
C: reviews (numbers 48 and 4.6)   D: company_no (text, 09876543 kept)
Row 1 in bold

Making the .xlsx

  1. Add the CSV

    Paste it into the box or press Open a file for a .csv, .tsv or .txt file.

  2. Name the sheet

    Type a Sheet name of up to 31 characters, the most Excel allows. The download is named after the sheet.

  3. Choose number handling

    Leave Store numbers as numbers on so totals and sorting work on numeric columns. Turn it off to make every cell text.

  4. Download

    Press Download .xlsx. The row count above the button confirms how much was read.

Which values become numbers

Value in the CSVCell in the workbookWhy
48NumberConverts back to exactly 48
4.6NumberConverts back to exactly 4.6
01632960410TextA number would lose the leading zero
01632 960411TextContains a space
12345678901234567890TextLonger than 15 digits, beyond Excel's precision
1,250TextThe comma makes it text; remove it first if you want a number

Questions people ask

How do I convert CSV to Excel without losing leading zeros?

Convert the CSV to .xlsx here rather than opening it directly in Excel. Values with a leading zero, such as UK phone numbers and many company numbers, are written as text cells, which Excel displays and keeps exactly. Open the downloaded workbook normally and the zeros are still there.

Can I add up columns in the converted file?

Yes, if Store numbers as numbers is ticked. Plain numbers such as counts, prices without symbols and ratings are stored as numeric cells that SUM and sorting treat as numbers. Values with currency symbols or thousands commas stay as text, so tidy those columns in the CSV first if you need to total them.

Does it keep accented characters and symbols?

Yes. The workbook stores text as Unicode, so names such as Café Aubergine or Łukasz appear correctly, without the garbled characters that sometimes appear when Excel opens a UTF-8 CSV directly. Pasting from a source that already shows broken characters will carry those through unchanged.

Can I put several CSVs into one workbook?

This converter writes one CSV to one sheet. To combine several sheets or workbooks, convert each CSV and then use the merge Excel tool, which joins workbooks into one file with a sheet per source or with all rows stacked together.

Where your data goes

The workbook is assembled in your browser from the CSV on this page. Neither the CSV nor the .xlsx is uploaded at any point.

Checked against the tool on

Top