CSV decimal dot in Excel

here is the answer I used:

• go to Data tab on excel sheet.

• click on from Text button.

• then select text or csv file.

• then the import wizard will come out. select comma separated or space separated option.

• then select delimiter. (this is better if you don't want it to have problem while importing decimals)

• then in the next window there will be Advanced option for General column type. Click the advanced button and choose how to separate decimals and thousands.

Change the decimal separator to a "." and remove the thousand separator with a space.

For users seeking to this question with newer Excel versions like Excel 365... As written at Professor Excel you could activate/restore "From Text (Legacy)" in the settings.

My prefered solution

File - Options - Data

Then you will be able to get the old import wizard... legacy but in my opinion more intuitiv.

Other possibilities

At that linked Professor Excel website there are also shown other possibilities. With Excels new import dialog, if you have several columns with numbers all in a different locale to your computers locale settings, then it will be much more effort to do the import. With the old wizard you are set within a minute. With the new import dialog I haven't found yet a method to be as fast as with the legacy import method.