Troubleshoot a problem

Opening an exported CSV file in Excel can result in a loss of data or improper formatting (e.g. not recognizing application identifiers, dropping leading zeroes, scientific notation conversion).

Watch a video

In Excel 2016

1. Open a blank Excel workbook.
2. Select Data > From Text.
3. Choose the CSV file in the Import Text File window.
4. Select Import:
   1. Select the Delimited option, and then select Next.
   2. Deselect the default Tab option, and then either:
      • Select the Comma option, and then select Next.

        or

      • Select the Period option, and then select Next.
   3. Select all columns and the Text option, then select Finish.
5. In the Import Data window, select the New worksheet option and then select OK.
6. Select File > Save As and make sure Save as type is set to Text (Tab delimited).
7. Select Save to save the active sheet.

   The file displays the correct data and formatting.

In Excel for Office 365

1. Open a blank Excel workbook.
2. Select Data > From Text/CSV.
3. Choose the CSV file in the Import Data window.
4. Select Import:
   1. Select Do not detect data types from the Data Type Detection drop-down.
   2. Select Load.
5. Select Save to save the active sheet.

   The file displays the correct data and formatting.