Cannot choose export options for CSV files

[HappySpaceInvader]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to be able to export CSV files with the text fields quoted. I can import them into Excel 2008 in this format; however, when I save the file, the quotes are stripped out.

In other versions of Excel on Windows (and also in OpenOffice), I can choose what the delimiter is, whether text fields are quoted, etc..

I can't find the option in Excel 2008 - where is it? Nothing in the help files on exporting to CSV, beyond the most perfunctory explanation of what a CSV file is.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to be able to export CSV files with the text fields quoted. I can
import them into Excel 2008 in this format; however, when I save the file, the
quotes are stripped out.

In other versions of Excel on Windows (and also in OpenOffice), I can choose
what the delimiter is, whether text fields are quoted, etc..

I can't find the option in Excel 2008 - where is it? Nothing in the help files
on exporting to CSV, beyond the most perfunctory explanation of what a CSV
file is.

Well, that's the way it is. Those options are not available on the Mac. The
text will only be quoted if it contains a comma. Use Help-Send feedback to
tell Microsoft that you need this feature.

 

[CyberTaz]

No offense, but before you follow Bob G's suggestion to "Send Feedback" you
might want to double-check your facts

CSV files generated by PC Excel 2003/2007 do not use quotes as text
qualifiers, nor is there any option to select them (or any other) when you
Save As .csv because .csv file format doesn't use them. Quotes are added
automatically in .csv format only to those fields [and for those records
only] which contain commas, quotes, etc. I think you may be remembering back
to the days of [Comma] Delimited Text Files rather than Comma Separated
Value files - that's one of the differences.

You may also be confusing the creation of .csv with what happens when you
use Excel to *open* or *import* a text file. The Import Wizard used for that
purpose does provide the opportunity to identify both the text qualifier as
well as the field delimiter used in the incoming data in addition to other
import options. Those options have been retained because of the number of
possible sources still in existence that use other flavors of delimited text
output.