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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s