Problem to open a csv file with excel with different regional settings

Question

Hi,

I have a csv file in which the field separator is pipe "|".

List separator in my regional setting is set to semicolon ";".

when I open the csv file all values are loaded into first column.

the problem could be fixed if I include in the first row the following line sep=|

I have tried to find any information related in microsoft but I didn't find any post realted.

I would like to know if this solution icould be used due to the csv file will be downloaded

by several users across the world and excel version could be different (2003,2007, 2010)

Thanks in advance

Answer 1

Unless you change the field separator to | in Windows' regional settings, you won't be able to open the .csv file correctly. You can use Data > Text to Columns after opening the .csv file, though.

Alternatively, change the extension to .txt.

When the user opens the file in Excel, the Import Text Wizard will start.

Select Delimited, then click Next.

Specify Other as delimiter and type | in the box.

Click Next, specify field formats if necessary, and finally click Finish.