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. A separate window will appear with the converted file.|
|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, select Text under column data format to change the format, 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.|