.xls and .csv (What is the difference)

Hi Friends,
I was wondering what is the difference technically in a .xls file and a .csv file format.
How are the two different? I know csv is comma separated variable but what exactly does that mean ..Is it a binary file or a what !!
Flex TronDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

csv is a text file. It can be opened by Notepad or Wordpad. xls is the file extension for Excel workbook file. It is a binary file and can not be viewed by a text editor.
As mentioned above, xls is a file for Excel data to be stored in. csv on the other hand is mainly used to export and import data from / to programs like excel. It doesn't have any formatting.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
csv is like txt file but the defferent that if you opened it with excel will gain some features like the xls files so for that its a usefull extention with some kind of tools like csvde and ldifde also use this link for more details http://en.wikipedia.org/wiki/Comma-separated_values
As stated above, it's a text file that's separated by commas.  Can be opened with notepad, wordpad, or excel.

I've always used CSV files when writing mass amounts of data so I can can store the values in a format that can be easily recognized by both excel and access when importing the data.  Works wonders for access as all you have to do is set your delimiter to comma and your imported table is complete.
Flex TronDeveloperAuthor Commented:
Thanks Guys
Got the Answer
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.