

Pro-Tip – If you don’t need to do this a lot and just need to change the delimiter for a file one time, you can use the tool located at Online CSV Tools to change the CSV delimiter online in a flash.

You can even choose to create a comma separated value file on Mac format or for MS-DOS. A comma separated CSV file (both in UTF-8 or standard format).Using the Save As feature, you can choose from: Presto, changeo…you have the data in the correct format. Saving a file to the CSV, or comma delimited Excel format is a really easy process using the File > Save As menu. Just use Excel’s built-in “Save As” function and change the format using the file type dropdown. The key is to know how to change delimiter in Excel or change the CSV delimiter and then save the file to the requested output format.Ĭonverting between XLS, XLSX, and CSV formats is pretty easy. Pain in the you-know-what.īut don’t worry, help is here.

As an Amazon Associate I earn from qualifying purchases when you buy something from those links. I get commissions for purchases made through those links. Please note: Some of the links in my posts are affiliate links.
