Configure your system to import CSV files into Microsoft Excel without friction.
You want to run some statistics and plots on data from image analysis applications? A correct import of CSV (comma-separated values) into Microsoft Excel depends on your system configuration, namely, which regional format settings system are currently configured in your Windows operating system.
What to expect from this page?
📑 Region settings in Windows
If your MS Windows region settings are not set to an English locale, you need to take care of setting the correct decimal and thousands delimiters during the CSV import into Excel.
You can check your regional settings in Windows 10 by typing the word “Region” into the search field in the task bar.
Then, check in the region settings the “Regional format” and take a look at the Regional format data below. It contains examples for date, decimal formats, etc.
Important: If you change the regional format, make sure that you restart your applications, e.g. MS Excel to respect the new settings.
📑 Finding your Excel version (Windows)
Go to "File > Account > About Excel" and check on the top of the dialog the version of Excel.
📑 Finding decimal separator settings in Excel
Excel allows you to override the system settings for decimal separators. The number format for displaying decimal data in Excel in can be modified by navigating to “File > Options > Advanced > Use system separators”.
Important: Setting the number format for display in Excel (File > Options > Advanced > Use system separators) does not have any effect on the data import. It is recommended to keep it aligned with the system settings and use the data import wizard to define the separator type.
Conclusion: Emotional job
At the end of the article, cheer the reader up and highlight the success of their possible emotional job.
If the user's action is not complete at this point and reading another instruction is implied for successful completion of the task, offer it as additional help.
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!
Delete this block before publishing!
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
There are no items with the selected labels at this time.
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
Delete this block before publishing!