IBM Support

Use of a comma as a decimal separator in Text Import Wizard of SPSS Statistics.

Technote (FAQ)


There is a .csv file, which includes the number below:

This uses a comma as decimal seperator. But importing the file using the Text Import Wizard of SPSS Statistics appears to ignore the comma and the data is incorrectly imported.


Incorrect locale was set on the SPSS Statistics instance.


In some languages, such as, German, use the comma as decimal separator. In order to resolve this problem and import the data correctly, please set the locale as German first and then import the .csv file.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics
Statistics Desktop

Software version: 21.0

Operating system(s): Windows

Reference #: 1647657

Modified date: 07 September 2016

Translate this page: