Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

4 Answers 4

up vote 10 down vote accepted

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.

share|improve this answer
    
You might want to add 'Click the "Customize" button' after the first step. –  Isaac Moses Aug 21 '09 at 13:53
    
@moe37x3: Done, thanks. –  arathorn Aug 21 '09 at 14:07
add comment

Why don't you try libreoffice!

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

Giorgio

share|improve this answer
add comment

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.

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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