Excel And .CSV ?

[Robert11]

Hello,

I have created a small Excel file that I wish to be saved as a CSV.

Question: do I have to put " marks around the beginning, and end, of the text in each cell, or does Excel automatically do what is required for CSV when I tell it to Save As a CSV ?

I did Not put any " marks around any text, and when I opened it up in Notepad++, there were a single set of double quotes (e.g., "Bob") marks around the text.

Is the initial Excel file I created without any " text marks
a "true" CSV ? Or,...?

Working with, and creating, a CSV seems a bit confusing, at least to me.
I did read many of the CSV articles via a Google, but still not too clear.

Any clarifications on what is exactly required when creating in Excel would be most appreciated.

Thanks,
Bob

 

[UsernameIssues]

No - you do not need to put anything around any cell... just save it as CSV.

I don't see Excel (Office 2010) adding any quotation marks to text when I open the CSV in a text editor. Perhaps that has something to do with the original spreadsheet.