Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 12 down vote favorite
1

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?

share|improve this question

2 Answers

up vote 3 down vote accepted

Seems that even now, Excel has problems saving a proper CSV file. An old ExcelForum.com post lists a number of macros that do the trick.

share|improve this answer
up vote 7 down vote

This page also has the solution which comes straight from the horse's mouth:

http://support.microsoft.com/kb/291296/en-us

If the link degrades, the topic to search for is:

"Procedure to export a text file with both comma and quote delimiters in Excel" and/or "Q291296"

tl;dr: use their macro

share|improve this answer
1  
Something that may be worth noting is that macro is using Integer for row and column values. You'll get hit with an error if trying to export greater than 32768 rows. Changing the datatypes to Long, for example, will fix that problem. – Dan May 21 at 18:06

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.