Export Microsoft Excel to CSV in Win OS
Though this is contrary to the official CSV standard, Excel uses the Windows “List Separator” character as the delimiter for CSV files. In English, that’s a comma, but it isn’t a comma for all languages. Try this:
- Go into the Windows Region and Language control panel. The name of that control panel may vary with the version of Windows.
- In that control panel, find the “List Separator” setting.
- Change that setting to commas.
- Apply, exit, and then try save file as CSV again
- Save your file in Excel as a CSV. Instead of semicolons, Excel will use commas as the delimiter.
Step 1:
Go to Administrative Language Settings.
**Please click image to view clearer.
**Please click image to view clearer.
Step 2:
Select Formats and click Additional Settings.
Step 3:
Change List separator from " ; " to " , " and click Apply and OK.
**Please click image to view clearer.