Helpdesk Baruch College

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

If you’re working with some dreadful business system that ought to have been retired in the dark ages, you could have needed to create a documents from Excel with some unusual delimiters apart from comma or tab-delimited to import into the system. Right here’s the technique on just how to do it.

Normally, this isn’t the kind of short article that most people will certainly need to make use of, with any luck ever before– yet if you do require to understand just how to do it, the service isn’t actually evident in the beginning.

Exporting Excel Files as Pipe Delimited

For the purposes of this instance, we’ll utilize this ridiculous little Excel file.

To conserve the file as Delimited, you’ll require to click the Office switch as well as select Save As– > Other Formats.

Then choose CSV (Comma delimited)(*. csv) from the drop-down checklist, and offer it a name.

Now here’s where the intriguing component occurs … Excel by default will utilize a comma as the delimiter, yet if you open Control Panel– > Region and also Language, and then click the Additional setups switch on the bottom …

Now look very closely at the “List separator” item, which normally has a comma in the area, but also for the purposes of picture I’ve changed it to a Pipe personality.

Once you hit Apply, and afterwards conserve your Excel file, you’ll discover that your data now has pipeline characters as the delimiter.

You’ll possibly want to transform the List separator back to a comma simply in instance some other application requires it.

Exit mobile version
Skip to toolbar