If your computer or laptop automatically opens CSV files to XLSX format in Excel, the larger number fields may not translate correctly. Importing the file using this process will ensure your data is correct.
How the import feature works will depend on your version of Excel. This article recommends a process based on Microsoft Office Standard 2016 and Microsoft 365.
Microsoft Support additional options.
Step | Microsoft Office Standard 2016 | Microsoft 365 |
1 | Open Excel and select a New > Blank workbook.![]() |
Open Excel and select a New > Blank workbook.![]() |
2 | Select the Data menu, and then select From Text. Select the file, and then select Import. ![]() |
Select the Data menu, and then select From Text/CSV. Select the file, and then select Import. ![]() |
3 | Find the Original data type section, select Delimited, check the My data has headers box, and then select Next. ![]() Find Delimiters and check Comma, and then select Next. Select all columns in the Data preview by selecting the first column header on the left, hold down the Shift key, and select the last column on the right. Find the Column data format section, select Text, and then select Finish.
|
Find the "Data Type Detection" option, select Do not detect data types, and then select Load. ![]() |
4 | Review, make any changes needed, and save your spreadsheet. | Review, make any changes needed, and save your spreadsheet. |