Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

What are CSV and XLS(Microsoft or OpenOffice) files ? What is the main difference between these two files ?

share|improve this question

migrated from stackoverflow.com Jun 20 '10 at 3:23

This question came from our site for professional and enthusiast programmers.

    
Note that a native Open Office Calc file has an extension of ods, and is totally different to either a CSV or an XLS file, being XML wrapped using a zip –  Mark Baker Jun 19 '10 at 20:23

5 Answers 5

up vote 16 down vote accepted

CSV : means C omma S eparated V alues. it is a plain text (ansi) format.
XLS : is the main binary file format for all e X ce L S heets

share|improve this answer

CSV files hold plain text as a series of values (cells) separated by commas (,) in a series of lines (rows). You can actually open a CSV file in a text editor and read it yourself. Many applications are capable of reading CSV files, and many languages provide built-in functions that simplify reading/writing CSV format.

XLS is an MS Excel workbook binary file, which holds information about all the worksheets in a workbook, comprising both content and formatting (number masking, colouring, conditional formatting, etc), and can also hold additionals like charts, images, etc. 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.

share|improve this answer

CSV files are intentionally designed to be widely supported; any OS or application that imports or exports data usually has CSV support.

They do nothing else but hold data - no text formatting for example.

Excel files hold the same data, but in binary format. This allows the file to save specifc Excel features - charts, formatting, etc.

share|improve this answer

.csv file type can contains plain text and no formatting other than what is in what column. The .xls file type contains data and and also formatting

share|improve this answer
  1. Excel is a spreadsheet application that saves files into its own format while CSV is a standard of saving tabular information into a delimited text file
  2. CSV is a very old method of saving tables compared to Excel
  3. CSV files cannot store other information like formatting while this comes standard in Excel
  4. Files saved in excel cannot be opened or edited by text editors while CSV files can.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.