Differentiate Excel file and CSV file?

1.	Differentiate Excel file and CSV file?
Answer» The difference between Comma-Separated Values (CSV) and eXceL Sheets(XLS) file formats is Excel: 1. Excel is a binary file that holds information about all the worksheets in a file, including both content and formatting 2. XLS files can only be read by applications that have been especially written to read their format, and can only be written in the same way. 3. Excel is a spreadsheet that saves files into its own proprietary format viz. xls or xlsx 4. Excel consumes more memory while importing data CSV: 1. CSV format is a plain text format with a series of values separated by commas. 2. CSV can be opened with any text editor in Windows like notepad, MS Excel, OpenOffice, etc. 3. CSV is a format for saving tabular information into a delimited text file with extension .csv 4. Importing CSV files can be much faster, and it also consumes less memory

Answer»

The difference between Comma-Separated Values (CSV) and eXceL Sheets(XLS) file formats is

Excel:

1. Excel is a binary file that holds information about all the worksheets in a file, including both content and formatting

2. XLS files can only be read by applications that have been especially written to read their format, and can only be written in the same way.

3. Excel is a spreadsheet that saves files into its own proprietary format viz. xls or xlsx

4. Excel consumes more memory while importing data

CSV:

1. CSV format is a plain text format with a series of values separated by commas.

2. CSV can be opened with any text editor in Windows like notepad, MS Excel, OpenOffice, etc.

3. CSV is a format for saving tabular information into a delimited text file with extension .csv

4. Importing CSV files can be much faster, and it also consumes less memory

Discussion