Excel And .CSV ?


  1. Posts : 542
    Windows 7 64bit
       #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
      My Computer


  2. Posts : 10,485
    W7 Pro SP1 64bit
       #2

    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.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 12:29.
Find Us