How to preserve text formatting in CSV files

Notice some weird formatting after exporting data to a CSV file? You came to the right place. Learn how to preserve formatting for numerical values in CSV files.

 

 

1. Open a blank Excel document

 

 

 

 

2. Navigate to the Data tab & Click Get Data (Power Query)

 

 

 

 

3. Click Text/CSV

 

 

 

 

4. Click Browse & select the CSV file you exported from ApprentiScope

 

 

 

 

5. Click Next

 

 

 

 

6. Set Data type detection to Do not detect data types

 

 

 

 

6. Click Load

 

 

 

 

7. Be amazed!