Learn to easily import CSV files with image analysis results into MS Excel 2021/Office 365 to get your data optimally prepared for further statistical evaluation.

The IKOSA Platform generates quantitative results data in a CSV format, since CSV files offer more flexibility than conventional XLS file formats. These files can be later transferred to different spreadsheet programs like Excel. Yet, before you can perform actual calculations on them, you need to convert CSV files into formats native to the spreadsheet program.

In this article, you will learn to easily import CSV data into an Excel worksheet to be able to proceed with your analysis. 

What to expect from this page?

Enable Legacy Text Import in MS Excel

1. Open a blank Excel workbook

2. Click on “File > Options” and open the Excel Options dialog

3. Find the “Data” section and in the “Show legacy data import wizards” field, tick “From Text (Legacy)”

4. Click OK

Open

Import CSV files using the Legacy Text Import

1. Open a blank Excel workbook

2. Click the "Data" field on the top menu bar

3. Select "Get Data > Legacy Wizards > From Text (Legacy)"
   
   

   Open

   

4. Choose the CSV file you want to import and click “Import”
   
   

5. In the Step 1 window that shows up, select the option "Delimited" for the original data type, and tick the box "My data has headers", then click "Next"
   
   

6. In Step 2 choose "Comma" as the delimiter (separator) type.
   
   

7. Click "Finish" and then "OK" to insert the data into the workbook

8. Check if your decimal data has been imported correctly
   
   

Good job! Now you have your data in the right format and can start with your analysis. We’re sure there are tons of report-worthy insights there.

Show others on your team how to properly import CSV data by sharing this guideline.

If you have any questions, please send us an email at support@ikosa.ai.

Related articles