How to 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:

  1. Go into the Windows Region and Language control panel. The name of that control panel may vary with the version of Windows.
  2. In that control panel, find the “List Separator” setting.
  3. Change that setting to commas.
  4. Apply, exit, and then try save file as CSV again
  5. 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.

 

SMS Coverage for All Countries Worldwide

 A B C D E F G H I J K L M N O P Q R S T U V Y Z
Quick Links
Products
Pricing
Support
divider