How to Open a CSV file in Excel

Files/Reports downloaded from the Scantrust Portal are in the format CSV (Comma Separated Value).

Excel reads CSV files by default but in some cases when you open a CSV file in Excel, you see scrambled data that’s impossible to read because all the data is put into one column. 

In order to properly open CSV files in Excel without the need to convert anything, please follow the following steps:

  • Open a new Excel document and navigate to the Data tab.

excel sheet data tab

  • Click “From Text”.

excel import from text function

  • Navigate to the CSV file you wish to open and click “Import”.

import csv file to excel

  • From the newly-opened window, choose “Delimited”. Then click “Next”.

text import wizard in excel 1st step delimited

  • Check the box next to the type of delimiter – Scantrust Files use the Comma as delimiter. Then click “Next”.

text import wizard in excel

  • Click “Finish”.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request