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!