losing quotes when saving CSV for website

D

DPeters

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

We use a CSV spreadsheet to manage our new websites display. When downloaded the file appears with quotes around each word when saved directly to desktop. (Sample: "City","State","Address","# BR",)

When opened in excel and modified and re-saved in the same CSV type (or any of the CSV save-as options) the data appears minus the quotes. (sample: City,State,Address,# BR,# BA, ) The website doesn't recognize this formating and the search fields come up empty.

The developer is using open office and I have tried to save the files on both MAC and PC with no luck.

Thanks for any help
 
H

HappySpaceInvader

Apparently, Excel 2008 does not have this feature. I have sent feedback requesting it, and I advise you do the same.

In the meantime, you can always download OpenOffice (for free), which does support this feature.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Surrounding data fields in quotes when saving to csv 1
Cannot choose export options for CSV files 2
Excel CSV Files; Creating Of 3
Import CSV file 1
Question about CSV saving 0
Exporting CSV files to Excel 7
Save as CSV file leaves CELLS content between quotation marks 0
can list of emails be transferred to safari address book? 7

Top