Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

MS Excel export allows a csv (comma delimited) export. Is it possible to export my files from excel to .txt or csv files (all the cells in my excel file) delimited by "|" (without the quotes) instead of commas.

share|improve this question
up vote 1 down vote accepted

Yes, it is possible. In MS Excel 2007, you would go to your options, and visit the detailed settings tab. Uncheck the box for using system delimiters (which should be showing the comma character). Then, just enter the pipe character or whatever you want as your new default column delimiter. With this setting change, the pipe character will be used instead of the comma when you export as CSV. You should have a look at this page.

share|improve this answer
That page worked out fine, I changed in Windows 7 from Control Panel > Region and Language settings > Formats > Additional settings > List Separator. In that box I changed it from "," to "|". Thanks, the page link at the end of your post did the trick – rzlines Apr 30 '11 at 11:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .