CSV now semicolon not comma

Suddenly your Excel CSV’s are now semicolon not comma. You can change this back to be a comma or else you can learn how to use semi colons instead of commas for CSV’s.

Changing CSV’s back from semi colon to comma

In all likelihood this has happened when you are working on a new computer and it is a setting, not in Excel, but Windows.

So in Windows, search for the ‘Clock and Region’ settings, then

  • Choose the ‘Change date, time or number formats’ option
  • On the next screen choose ‘Additional Settings’, and
  • in the ‘Customize Format’ screen, check what is listed as the ‘List Separator’. This will be what Excel uses as the delimiter so if you need to change it, you can do it here.
CSV now semicolon not comma

So now you won’t have a CSV using semicolon instead of a comma. You can use the same process if you actually want your ‘Comma Separated Files’ to rather be ‘semi colon separated’ files.

Excel formulas need a semicolon instead of a comma?

Excel CSV opens in one column

The Excel Online Course that covers importing CSV’s