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.

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

1 Answer 1

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

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.