Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel And .CSV ?


18 Nov 2013   #1

Windows 7 64bit
 
 
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 System SpecsSystem Spec
.

18 Nov 2013   #2

W7 Pro SP1 64bit
 
 

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 System SpecsSystem Spec
Reply

 Excel And .CSV ?




Thread Tools



Similar help and support threads for2: Excel And .CSV ?
Thread Forum
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel help Microsoft Office
Excel? Software
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find 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 11:33 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33