Excel save-as CSV options

Here is little trick to change the CSV save-as option to use something other then a comma. Sometimes you need to make an output file with a delimiter other than a comma, tab or space. Excel does not come with an option to save a file as pipe delimited. You have to make a system change to accomplish this. This option is in the strangest place and you would never think to look there.

This link will show you the easy way to make the change. Be aware that when you make this change, you make it for the computer not just Excel.

http://superuser.com/questions/783060/excel-save-as-csv-options-possible-to-change-comma-to-pipe-or-tab-instead

Leave a Reply

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