Interested with Bulk SMS Philippines? Contact Us HERE

How to Export Microsoft Excel to CSV File in Win OS

Export Microsoft Excel to CSV File 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.


The generated .CSV file can be used for multiple purpose. Learn more on How to Send SMS using CSV File