1

I have a csv file when opened in notepad looks like this:

sep=,
ProgramXX, PXXXXX, ....
IDXXXXX, XYZXXXXX, ....

This should open well formatted as csv file in excel program but what I see is this: enter image description here

This problem is too localized to a 'client machine', not able to reproduce the issue elsewhere. Is there any settings that I'm missing in excel? The version of MS Excel is 2007.

Improve this question
1

1 Answer 1

Reset to default
2

Credit to https://superuser.com/users/166431/michael-field via Easiest way to open CSV with commas in Excel, the client needs to uncheck 'Use system separators' in their Excel advanced options for the 'sep=,' command to work.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .