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 worksheet to be able to proceed with your analysis.
| Info |
|---|
Please note: This guide assumes your the regional format settings of your Windows being 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 External Data Import
Open a blank Excel workbook
Click the "Data" field in the upper top menu bar
Select "Get External Data > From Text"
Choose the file you want to import and click "Import"
In step 1 of the dialog choose 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 on "Next"
- Choose
In Step 2 choose "Comma" as the delimiter (separator) type in Step 2
Click on "Finish", 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! |
| Info |
|---|
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! Delete this block before publishing! |
...
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
| Info |
|---|
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
...