For images see blog post : [ Ссылка ]

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.
------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- [ Ссылка ]
🏅- Test employee Excel skill levels- [ Ссылка ]
🏆- Improve you Excel Skill Levels- [ Ссылка ]
🇿🇦- Our main website- [ Ссылка ]

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Handling CSV's that use semi colons instead of commas
00:21 Separate columns with semi colons
01:09 Correcting the source of the problem if all your files have changed

------------------------------------------------------------------------------------------------------------------------------------------------------

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.

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.

свернуть