Configure your system to 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 systemsettings selected.
In this article we show you where to configure these settings for a smooth CSV 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! |
Now that you’ve adjusted your system settings you are good to go and start the import of CSV files into Excel. Have fun analyzing your data!
If you know someone who struggles with CSV imports, share this article with them.
If you have any questions, please send us an email at support@ikosa.ai.
📚 Related
articlesarticles
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
Delete this block before publishing!