Default delimiter for Excel .csv files

Neat tip for exporting CSV files from Excel (not sure where I picked it up):

  1. Control Panel > Region and Language
  2. Click on “Additional settings…” in the lower right
  3. Change the List Separator value to the appropriate delimiter.

Windows CSV delimiter

Leave a Reply

Your email address will not be published. Required fields are marked *