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
In addition, you may specify delimiter directly in csv file. Open it in any text editor, e.g. Notepad, and add first line, which defines the delimiter, as
Now Excel opens it correctly.
- This also works, thank you so much Sergei!
Have a great evening and a nice Sunday!
Kind regards,
Paul