New
#1
Excel And .CSV ?
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