ANS-1883 · CSV IMPORT & DATA MIGRATION

How to Prevent Excel from Converting Numbers to Scientific Notation

Learn how to import CSV data into Excel without automatic conversion of long numbers to scientific notation, preserving data integrity.

AreaCSV Import & Data MigrationAudienceEnd userDifficultyIntermediate

Short answer

To prevent Excel from converting numbers to scientific notation when importing CSV files, use the Text Import Wizard. Access it via 'Data > Get Data > Legacy Wizards > From Text (Legacy)', select 'Delimited', choose 'Comma' as the delimiter, and set relevant columns to 'Text' format during the import process.

Scenario

When importing CSV files into Microsoft Excel, users may encounter an issue where long numerical strings, such as item IDs or serial numbers, are automatically converted into scientific notation. This automatic formatting can lead to data loss or inaccuracies, as the original full number is not preserved.

Solution

To prevent Excel from automatically converting numerical data to scientific notation during CSV import, it is recommended to use the Text Import Wizard and specify the column data types. This method ensures that Excel treats the data as text rather than attempting to format it as a number.Note: The Text Import Wizard is considered a legacy feature in modern Excel versions and may need to be explicitly enabled in Excel Options to be accessible via the 'Data' tab.

  1. Open Microsoft Excel and start a new blank workbook.

  2. Navigate to the 'Data' tab in the Excel ribbon.

  3. In the 'Get & Transform Data' group, click 'Get Data', then 'Legacy Wizards', and select 'From Text (Legacy)'.

  4. Select your CSV file from the file browser and click 'Import'.

  5. In the Text Import Wizard - Step 1 of 3, choose 'Delimited' as the original data type, then click 'Next'.

  6. In the Text Import Wizard - Step 2 of 3, select 'Comma' as the only delimiter. Click 'Next'.

  7. In the Text Import Wizard - Step 3 of 3, for all columns that contain numbers you wish to prevent from converting to scientific notation, select the column in the Data preview window and choose 'Text' as the Column data format. This instructs Excel not to apply numerical formatting to that column.

  8. Click 'Finish' and then 'OK' to load the data into the new workbook without modification.

Originally answered August 21, 2017Verified July 5, 2026

Expert NetSuite Support

Need help with this NetSuite issue?

CSV Import & Data Migration consulting and configuration support

Talk to a consultant

Keep exploring

Related answers