Chapter: 12th Computer Science : Chapter 13 : Database concepts and MySql : Python and CSV Files
Difference between CSV and XLS file formats
Difference between CSV and XLS file formats
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
importingdata
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
inWindowslikenotepad,MSExcel, 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
5. it also consumes less memory
Related Topics