Prevent Long CSV Numbers from Changing to Scientific Notation in Excel
Question details
The user wants to import long CSV values into Excel without scientific notation or lost digits.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A CSV file contains long identifiers or other values that must retain every digit when opened in Excel.
- Observed behavior
- Excel may display long values in scientific notation and replace digits beyond its 15-digit numeric precision limit with zeros.
Locate the original CSV and identify the columns that contain long values, such as account numbers or IDs. Import from the original file rather than a workbook where Excel has already changed the digits.
Import the CSV with the Text Import Wizard
Use the legacy Text Import Wizard to set long-number columns to Text before Excel converts them.
In Excel, go to Data > Get Data > Legacy Wizards > From Text (Legacy), or Data > From Text in older versions. Select the original CSV file.
In the Text Import Wizard, choose Delimited, click Next, and select Comma as the delimiter.
Click Next, select each affected column in the preview, and choose Text under Column data format. Click Finish and choose where to place the imported data.
Check the imported values, then use File > Save As to save the result as an Excel workbook (.xlsx).

Import the CSV with Power Query
Use the modern From Text/CSV import flow when Power Query is available.
Import Long CSV Values as Text in WPS Spreadsheet
Use the text import options in WPS Spreadsheet to keep long CSV identifiers as text, then save the result as an Excel-compatible workbook.
- 1. Open the original CSV: In WPS Spreadsheet, select File > Open and choose the original CSV file.
- 2. Configure the import: In the text import dialog, select the comma delimiter and preview the columns.
- 3. Import identifiers as text: Select each column containing long values and set its column format to Text before completing the import.
- 4. Check and save: Verify the digits in the worksheet, then select File > Save As and choose the .xlsx format.

Frequently Asked Questions
Why does Excel change digits after the fifteenth digit?
Excel stores numbers with a maximum of 15 significant digits. Import long identifiers as Text using the Text Import Wizard or Power Query before Excel converts them to numbers.
Can I recover digits by changing the cell format to Text?
No. Changing the format after Excel has already converted and altered a value does not restore lost digits. Reimport the original CSV and set the affected column to Text during import.
Does scientific notation always mean digits were lost?
No. Scientific notation can be a display choice. However, values exceeding Excel's 15-digit numeric precision can lose digits, so import long identifiers as Text and check them against the original CSV.
Can I use imported text values in calculations?
Values imported as Text are best suited to identifiers rather than arithmetic. Converting a long value back to a number can subject it to Excel's 15-digit precision limit.




