Learn how to adjust your operating system settings to be able to import CSV files into Microsoft Excel without friction.

To run some statistics and plots on the data from the IKOSA image analysis applications, 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, namely, on the regional format settings selected.

In this article we show you where to configure these settings for a smooth CSV file import.

What to expect from this page?

Region settings in Windows

If the region settings of your MS Windows operating system are not set to an English locale, you need to set the correct decimal and thousands delimiters (separators) during CSV imports into Excel.

You can check the region settings in Windows 10 by typing in the word “Region” into the search field of your task bar.

Open

Then, in the region settings field open the “Regional format” tab and take a look at the Regional format dropdown lists. Dropdown lists where you can set the appearance of items like date, decimal formats, etc. are provided.

Open

Finding your Excel version (Windows)

To find this information go to "File > Account > About Excel" and check your Excel version at the top of the dialog.

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”.

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 articles