How to open semicolon delimited CSV-files in US-version of Excel
Problem
When I double-click on a .csv file, it is opened in Excel. The csv-files have columns delimited with semicolons (not commas, but also a valid format). Using a German Windows/Excel setup, the opened file is displayed correctly, the columns are separated where the semicolons existed in the csv-file. But when I do the same on an (US-) English Windows/Excel setup, only one column is imported, showing the whole data including the semicolons in the first column. (I don't have an English setup available for tests, users have reported the behavior) I tried to change the list separator value in Windows regional settings, but that didn't change anything. What can I do to be able to double-click-open those CSV-files on an English setup? EDIT: It seems to be the best solution not to rely on CSV-files in this case. I was hoping that there is some formatting for CSV-files that makes it possible to use them internationally. The best solution seems that I'll switch to creating XLS-files.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: How to open semicolon delimited CSV-files in US-version of Excel
Add this on the first line of the CSV file: or This will override system setting ("list separator character") and Excel will open the file correctly.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix