Go to the Data tab and select 'From Text'.If you do not want to change the default list separator or decimal symbols, then the below method will be an alternative for the meantime: If the Decimal Separator is a comma (,) then the CSV separator will be a semicolon. Change the 'Decimal Separator' to one of the below scenariosįor MacOS, if the Decimal Separator is a period (.) then the CSV separator will be a comma.

Open the Language & Region pane and go to the Advanced option.If you do not want to change this setting, there is another method to opening comma delimited files below. Note: This only works if the 'Decimal symbol' is also not a comma. Type a comma into the 'List separator' box (,).Click Customize/Additional settings (Windows 10).Open the Regional and Language Options dialog box.Open the Windows Start Menu and click Control Panel.In Europe, the default is for the semicolon to be a delimiter instead of a comma.īelow are methods for both Windows and MacOS to change the default list separator: Windows This is due to regional Excel settings that have default list separator options where files will either be read with a comma separator or semicolon separator. CSV (comma delimited) will not open correctly and the data within will be displayed incorrectly. In some regions (Europe for example) Excel files downloaded from the Harvest Admin in the format.

Csvto excel