English

Differentiate Excel file and CSV file.

Advertisements
Advertisements

Question

Differentiate Excel file and CSV file.

Distinguish Between
Advertisements

Solution

Excel \ csv : / ‘
Excel is a binary file that holds information about all the worksheets in a file, including both content and formatting. CSV format is a plain text format with a series of values separated by commas.
XLS files can only be read by applications that have been specially written to read their format, and can only be written in the same way. CSV can be opened with any text editor in Windows like notepad, MS Excel, Open Office, etc.
Excel is a spreadsheet that saves files into its own proprietary format viz. xls or xlsx. CSV is a format for saving tabular information into a delimited text file with extension .csv
Excel consumes more memory while importing data. Importing CSV files can be much faster, and it also consumes less memory.
shaalaa.com
Create A CSV File Using Microsoft Excel
  Is there an error in this question or solution?
Chapter 13: Python and CSV files - Evaluation [Page 266]
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×