Getting pipe delimited csv out of Excel

Handy little tip here. If you need to save an excel file in a flat file format such as csv but you want the separator to be something other than a comma or a tab then you can do the following.

Open up settings > control panel > regional and language settings and choose customize on the first tab. On the screen that shows up next, on the numbers tab is a box titled list separator. Change the value on this box to the delimiter you want to use and heh presto when you save as a csv in excel the values will be separated the way you wanted them.

Advertisements