How do you convert an Excel file into a text file with pipe delimiters?

Question

Suppose each file has more than one tab/worksheet of data.

Answer 1

Currently, you need a macro or plugin, or a lot of time.



By hand, you have to "Move or Copy…" each worksheet to a new book, and save each one as CSV.



There is a $20 shareware program that can automate this for you:

http://www.sobolsoft.com/excelexportcsv/

Answer 2

you can set a pipe rather than a comma as a delimiter. It does not depend completely on Excel. It depends on Windows. The quickest way is to save the file as a CSV file.



To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.



Click the "Number" tab and in the "List Separator" field, replace the current default separator with the one you want to use (let's say a pipe symbol | ).



Click "OK" to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel:



Open or Create a new file in Excel.

Click File => Save As on the menu bar.

In the "File Type" drop down, select "CSV (comma separated values) *.csv".

Answer 3

Use the "Save As" feature. And save each of worksheet as a .CSV file.

Hope it help.