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.
business,phone,reviews,company_no Kiln & Co Pottery,01632960410,48,09876543 Marlow Print Works,01632 960411,4.6,SC123456
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
Add the CSV
Paste it into the box or press Open a file for a .csv, .tsv or .txt file.
Name the sheet
Type a Sheet name of up to 31 characters, the most Excel allows. The download is named after the sheet.
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.
Download
Press Download .xlsx. The row count above the button confirms how much was read.
Which values become numbers
| Value in the CSV | Cell in the workbook | Why |
|---|---|---|
| 48 | Number | Converts back to exactly 48 |
| 4.6 | Number | Converts back to exactly 4.6 |
| 01632960410 | Text | A number would lose the leading zero |
| 01632 960411 | Text | Contains a space |
| 12345678901234567890 | Text | Longer than 15 digits, beyond Excel's precision |
| 1,250 | Text | The 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