Configure Learn how to adjust your operating system settings to be able to import CSV files into Microsoft Excel without friction.
You want to To run some statistics and plots on the data from the IKOSA image analysis applications? A correct , you need to import it into a spreadsheet program. The seamless import of CSV-files (comma-separated values) into Microsoft Excel depends on the configuration of your Windows operating system configuration, namely, which on the regional format settings system are currently configured in your Windows operating systemselected.
In this article we show you where to configure these settings for a smooth CSC-file import.
What to expect from this page?
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
📑 Region settings in Windows
If the region settings of your MS Windows region settings operating system are not set to an English locale, you need to take care of setting set the correct decimal and thousands delimiters (separators) during the CSV import imports into Excel.
You can check your regional the region settings in Windows 10 by typing in the word “Region” into the search field in the of your task bar.
Then, check in the region settings field open the “Regional format” tab and take a look at the Regional format data below. It contains examples for dropdown lists. Dropdown lists where you can set the appearance of items like date, decimal formats, etc. are provided.
| Note |
|---|
Important: If you change Once you’ve changed the regional format, make sure that you to restart your running applications, e.g. MS Excel, to respect adopt the new settings. |
📑 Finding your Excel version (Windows)
Go To find this information go to "File > Account > About Excel" and check on your Excel version at the top of the dialog the version of Excel.
📑 Finding the 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”.
| Note |
|---|
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. |
| 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! |
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) | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Info |
|---|
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:
Example: algorithm-prediction-analysis Delete this block before publishing! |