Export from Excel adds quote marks

[howardg]

Thanks for your clear answer to my earlier question. I have run into a different problem now. After exporting the file, opening it in Excel (using the text import wizard), adding some words, saving as a text file, uploading to your site, and downloading to my iPhone, I find that dozens of the words have quotation marks around them where none had existed before. When I open the file in Excel I use the default settings for the import wizard, i.e., tab-delimited file, text qualifier = ", with "general" as the data format for all columns. I know this may be an Excel issue, but if you have any insight about where these unnecessary quote marks are coming from I would really appreciate it.

ADDITIONAL INFORMATION: After posting I did some additional investigation and discovered that the glitch comes at the point where I save the Excel spreadsheet to a text file. If any cell of the spreadsheet contains a comma, then that cell will export with the text surrounded by quote marks, e.g., [get, obtain] comes out as ["get, obtain"], but [get obtain] comes out as [get obtain]. What's up with that? I'd really like to be able to include commas without getting quotation marks.

[Ernie]

When you paste into my website, don't copy from a text file you created from Excel... copy directly from Excel. (No need to create a text file.) If you have any problems after trying that let me know.

[howardg]

Yes, that seems to work well. Thank you very much!