Here’s a quick hack when your CSV file has a different separator than Excel is expecting.
Add this on the first line of the CSV file:
This will override system setting for list separator character and Excel will open the file correctly.
Note: Excel expects the separator to match the one defined in the Control Panel/Region/Formats/Additional settings/List Separator. On a French system, it expects a semi-colon.