Link to home
Start Free TrialLog in
Avatar of Flex Tron
Flex TronFlag for United States of America

asked on

.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 !!
Avatar of sungenwang
sungenwang
Flag of United States of America image

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.
ASKER CERTIFIED SOLUTION
Avatar of rindi
rindi
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ahmedalnooh
ahmedalnooh

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.
Avatar of Flex Tron

ASKER

Thanks Guys
Got the Answer