Depending on your computer's regional settings (North America vs. EU) you might be experiencing an issue where your CSV data appears only in the first column when using Microsoft Excel.
MacOS – Language and Region Settings avanced So why is Excel then struggling with my system settings? The problem and the solution I seem that the configurations available via the user interface don’t have any effect on Excel. It seems that this change happens in MacOS Sierra. Nearly any application follow now the settings of User Interface and not the parameter of the region anymore.
How do you set a Print Area in Excel By Julian Coombes 9 years ago I have recently switched from a PC to a MacBook Pro (a decision which I bitterly regret!).
Even Microsoft Office follow this pattern. The good news is that what cannot adjust via the user interface can be modified through the terminal.
The setting ‘AppleLocale’ store the value that application uses to identify the current locale and correlates to the language settings of the user interface. In case you don’t like to change your system language to German you need to change the value of ‘AppleLocale’. First I checked the current value using the following command to make sure the value is wrong.