*.CSV file format mismatch due to control panel setting for MS EXCEL

A few days back, I was struggling to solve a display mismatch problem in *.CSV file.

We had a tab delimited *.CSV file for upload.

While opening *.CSV file at my end its was showing correct format.

But when the same file was opened by one of my client (From Germany) it was displaying in different format. Its was very strange for me :-(

Correct format as shown below (sample tab delimited *.CSV file):

Client side format (incorrect format) below (sample tab delimited *.CSV file):

Solution:

At first I could not able to find the issue.

Checked and tried all the setting in the EXCEL option it’s was almost same.

After analyzing and investigation, I tried to change region and language setting and it worked.

Go to the control panelregion and language setting formatadditional settings

Now in the number decimal symbol it was ‘,’ and List separator ‘;’

Now change decimal to ‘.’ And List separator to ‘,’ as shown below.

Note: If two symbols are same it won’t work

Apply the changes

Again apply in the region and language page setting

Close all the excel sheet

Now open the excel sheet again. We can see the correct format .