Forum Discussion
Open a csv file in Excel
Thanks for checking. That explains the behavior that you describe.
You have the following choices:
1) You might set point as decimal separator and comma as thousands separator and as list separator in Windows. The csv file will then open correctly for you. This will, of course, affect all applications, and might be very inconvenient depending on where you live.
2) Leave the system settings as they are. Change the extension of the csv file to .txt.
Excel will then display the Text Import Wizard when you open the file. You can specify the delimiter there.
HansVogelaar Thanks for your reply, Hans. In my system settings, the list separator is a semicolon and I use a comma as decimal separator. In Excel, the 'Use system separators' check box is checked.
In the csv file, the fields are separated by "," Should I change something?
Kind regards,
Paul
Thanks for checking. That explains the behavior that you describe.
You have the following choices:
1) You might set point as decimal separator and comma as thousands separator and as list separator in Windows. The csv file will then open correctly for you. This will, of course, affect all applications, and might be very inconvenient depending on where you live.
2) Leave the system settings as they are. Change the extension of the csv file to .txt.
Excel will then display the Text Import Wizard when you open the file. You can specify the delimiter there.
- Thank you so much, Hans, this works!
Have a great evening and Sunday!
Kind regards,
Paul