Easily Learn to easily import CSV files with your image analysis results into MS Excel 2016 to get your data optimally prepared for further statistical evaluation.
The IKOSA Platform cumulates 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 table calculation 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 before you can perform actual calculations on them.
In this article, you will learn what CSV files are and how you can to easily import CSV data into an Excel 2016 worksheet to be able to proceed with your analysis.
| Info |
|---|
Please note: This guide assumes the regional format settings of your Windows OS has been set to English (United Kingdom).* *The same applies if you have selected different English-language settings e.g. English (United States). |
What to expect from this page?
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
📑 Import CSV files using the
...
| Info |
|---|
Please note: This guide assumes your regional format settings of Windows being set to English (United Kingdom). |
In order to obtain the data in the desired format, you have to import your CSV file into Excel. To do this you have to perform the following steps:
External Data Import
Open a blank Excel workbook
Click the "Data" field in the upper top menu bar
Select the option "New Query "Get External Data > From File > From CSVText"
Choose the CSV file you want to import and click import
Preview your data in the window that opened
Choose "Import"
In the Step 1 window that shows up select the option "Delimited" for the original data type, and check the box "My data has headers", then click "Next"
In Step 2 choose "Comma" as the delimiter (separator) type
Click on the "LoadFinish" button and , then "OK" to insert the data into the workbook
Check that if your decimal data has been imported correctly
| Info |
|---|
Conclusion: Emotional job
Example: You are done with the training! Now it’s time to evaluate how did it go. If you need any help with that, we have for you a couple of how-to articles. Delete this block before publishing! |
...
Conclusion: Social job
Propose a social action if relevant.
Example: Share the progress of your training with colleagues, discuss the outcomes and make new discoveries!
...
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
...
...
Adjust displayed content of related articles by the label of the main section the published article belongs to.
Delete this block before publishing!
| Filter by label (Content by label) | ||||||||
|---|---|---|---|---|---|---|---|---|
|
...
Don't forget to add labels to this article to increase its searchability. Add labels of the main section where it belongs to and subject related labels.
Labelling technique:
start label name with a noun (ex. annotation, image, etc)
use dash “-“ between the words
don’t use more than 3 words in one label
Example: algorithm-prediction-analysis
...