How to Export data from Excel 2010 to pipe delimited text file

This tutorial is going to show you how to export Excel data to a pipe delimited text file

In this tutorial you are going to learn how to export data from excel to pipe delimited text file.

Step # 1 -- Opening Region and Language Settings

Close Excel if you have the program open. Click "Start" and then click "Control Panel". In the window that appears you need to click on the "Region and Language" option. At the bottom of this new window click on the "Additional settings..." button.

Step # 2 -- Changing the Default List Separator

This will open the "Customize Format" window. Locate the "List separator" box and replace the comma with the pipe symbol. Click "OK" and then "OK" again in the previous window. Now you need to open the Excel file that you want to export.

Step # 3 -- Saving the File

Once the file has loaded click the "File" option in the main menu and then click on the "Save As" option. In the window that opens click on the drop down box next to "Save as type", and from this list you need to select the option "CSV (Comma delimited)". Click on the "Save" button, and in the dialog box that appears click "OK".

Step # 4 -- Opening the File with Notepad

This is how to export data from excel to pipe delimited text file, and to view the file in Notepad go to where it is located, right click on it, navigate to "Open with" and click "Notepad". As you can see all the bits of data from the file are separated with the pipe delimiter.

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[andreipopirda]

This is a great video! Never thought of it. But there is a reason why - the Excel developers who thought to dynamically grab the list separator from regional settings, but NOT dynamically change the extension of the file. Therefore, no matter what delimiter you choose (pipe, hash, question mark, etc.), the C from CSV will always mean COMMA. :)).

[BrunoLeonidio]

Perfect ! you've just saved my life ! Thx !

[markwedding]

2018 and I still can't believe it's this difficult to export Excel data with a custom delimiter. Good video though

[dkk]

Super Sir..Wonderful.. Perfect.. This is what I exactly wanted to convert the data from one delimited to another, like Tab to Pipe symbol, and comma delimited to Pipe or Tab... Thank you so much..

[madmax]

Brilliant! Thank you for taking the time to make this video for us minions!

[crazy-tl]

and now that I have done that, how can I continue to utilize formulas in other excel files? or will I need to switch back each and every time after saving a pipe delimited file?

[qmbpult]

what am I doing wrong? there are no commas no pipes, text has only spaces.

[lhenryk]

nice knowing that what is always been there (csv options like separator and delimieter) as been removed from excel .. M$hit is always going worst .. swicth to linux

[LordOrwell]

how does this work if your text field already has a pipe in it?

[ukaszjarych]

Very poor solution. So every time i have to go to regional settings and change them? This is not useful at all