Compliance & Reporting
      Back to home
      1. Support Center
      2. Tutorials
      3. Compliance & Reporting

      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!