Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas

If you’re working with some awful corporate system that should have been retired in the dark ages, you might have had to produce a file from Excel with some weird delimiters other than comma or tab-delimited to import into the system. Here’s the trick on how to do it.

Naturally, this isn’t the type of article that most people will need to use, hopefully ever—but if you do need to know how to do it, the solution isn’t really obvious at first.

Exporting Excel Files as Pipe Delimited

For the purposes of this example, we’ll use this silly little Excel file.

image

To save the file as Delimited, you’ll need to click the Office button and choose Save As –> Other Formats.

Then select CSV (Comma delimited)(*.csv) from the drop-down list, and give it a name.

Now here’s where the interesting part happens… Excel by default will use a comma as the delimiter, but if you open up Control Panel –> Region and Language, and then click the Additional settings button on the bottom…

Now look very closely at the “List separator” item, which normally has a comma in the field, but for the purposes of illustration I’ve switched it to a Pipe character.

Once you hit Apply, and then save your Excel file, you’ll notice that your file now has pipe characters as the delimiter.

You’ll probably want to change the List separator back to a comma just in case some other application needs it.

 

 

[ORIGINAL POST] : http://www.howtogeek.com/howto/21456/export-or-save-excel-files-with-pipe-or-other-delimiters-instead-of-commas/

Advertisements

One thought on “Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas

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