I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall was possible in earlier Excel versions via a wizard?


From this page:

  • Bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.
  • Click the "Customize" button.
  • Click the “Number” tab and in the “List Separator” field, replace the current default separator with the one you want to use (in your case, the pipe symbol).
  • Click “OK” to save the change and close the window.

Now exporting as CSV in Excel will produce pipe-delimited files.

  • You might want to add 'Click the "Customize" button' after the first step. – Isaac Moses Aug 21 '09 at 13:53
  • 1
    Just emphasising this is located within the system control panel, not excel. Also link is not available anymore. The matter was also discussed and solved here: answers.microsoft.com/en-us/office/forum/… – Father Stack Mar 11 '15 at 13:02

Also, assuming no commas in the actual data, you can export to regular .CSV, and then use notepad to Find/Replace all commas with pipes. If you do have commas in your data, then before exporting to .CSV, Find/Replace (within Excel) all of the commas to something that is not used in your data (e.g., the left curly brace, or the tilde). Then, after exporting and find/replacing commas to pipes, you can find/replace that new character back to commas.


Changing the list separator back and forth is a pain.

Leaving it as | is not acceptable as it screws up a lot of things. Saving as a TAB-separated text file, then using a text editor to globally replace the TABs with |s works well.

To do this with Notepad, highlight a TAB character in the text file, then copy it, then invoke Replace, then paste it into the search for box, then put whatever delimiter you want in the replace with box.

  • +1, Much simpler than the accepted answer. Also, you don't even need to save as tab-separated file, you can just select all, copy, and then paste into Notepad++ or similar to replace the tabs. – Amos M. Carpenter May 22 '15 at 2:47

Why don't you try Libreoffice!

When you open or save a CSV file, it asks what delimiter should be used!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.