Data Import & Export

Recover Phone Numbers Changed to Scientific Notation in Excel

John WilsonJohn Wilson Nov 13, 2026 869 views

Question details

The user needs to recover phone numbers affected by Excel's automatic conversion of a contacts CSV file.

Recover Phone Numbers Changed to Scientific Notation in Excel
Product
Microsoft Excel, Google Contacts, and Outlook
Device & OS
not provided
Scenario
A contacts CSV file was opened in Excel before importing the contacts.
Observed behavior
Long phone numbers may appear in scientific notation, and Excel may round digits or remove leading zeros. Changing the cell format cannot restore digits already lost.
Before you start

Check whether the original contacts are still available in Google Contacts or in an unmodified CSV file. If Excel has the CSV open, avoid saving over it while you check.

Solution 1Recommended

Export contacts again and import the CSV directly into Outlook

Use a fresh Outlook-format export to transfer contacts without letting Excel convert phone numbers.

1
Export the contacts

Open Google Contacts, select the contacts you need, and choose Export. Select Outlook CSV and download the file.

2
Start the Outlook import

Without opening the downloaded CSV in Excel, open classic Outlook and select File > Open & Export > Import/Export.

3
Select the CSV file

Choose Import from another program or file, select Comma Separated Values, and browse to the downloaded CSV.

4
Complete the import

Select the destination Contacts folder, review Map Custom Fields if needed, and finish the import. Open a few contacts to check their phone numbers against the source.

Export contacts again and import the CSV directly into Outlook
When the original is unavailable: If the only remaining CSV was saved after Excel changed the numbers, formatting the cells will not recover lost digits. Obtain another export or a copy from another contacts source if possible.
Work with contacts in WPS Spreadsheets

Import phone numbers as text in WPS Spreadsheets

Use WPS Spreadsheets to import an unmodified contacts CSV and set phone number columns to text before working with them. This helps preserve leading zeros and long numbers, but it cannot restore digits already lost.

  1. 1. Get an original CSV: Export the contacts again from Google Contacts or locate an unmodified CSV copy.
  2. 2. Start the import: Open WPS Spreadsheets, create a blank workbook, and use Data > Import Data to select the CSV file.
  3. 3. Choose text for phone numbers: In the text import wizard, select each phone number column and set its format to Text before completing the import.
  4. 4. Check the results: Compare several imported phone numbers with the source contacts, including any leading zeros and long numbers.
Import phone number columns as text to avoid numeric conversionOpen and edit Microsoft Excel XLSX and XLS filesWork with CSV contacts in a familiar spreadsheet interfaceUse WPS Office's free spreadsheet tools
microsoft office alternative - wps office

Frequently Asked Questions

Can I recover lost digits by changing the Excel cell format?

No. Formatting can change how a value is displayed, but it cannot restore digits Excel already rounded or removed. Import a fresh export or an unmodified copy instead.

Does scientific notation always mean the phone number is damaged?

No. It can be a display format. Select the cell and compare its value in the formula bar with the original contact, including leading zeros. Excel stores numeric values with only 15 significant digits, so longer numbers may have been rounded.

Which Google Contacts export should I use for Outlook?

In Google Contacts, choose Export and select Outlook CSV. Import the downloaded file through Outlook without first opening and saving it in Excel.

How can I stop Excel from changing phone numbers in a CSV?

Use Data > From Text/CSV and import the phone number columns as Text before numeric type conversion occurs. Check the imported values against the original contacts.