Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


differences between excel file and csv file

Posted on 2012-09-06
Medium Priority
Last Modified: 2012-09-11
what are the differences between excel file and csv file. Are both same. What are the differences, similarities and uses of both.Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
Question by:gudii9
LVL 25

Accepted Solution

lwadwell earned 1000 total points
ID: 38372670
A csv (which stands for Comma Separated Values) file is nothing more than a plain text file ... containing 'tabular' data delimited by a defined character like a comma ',', but other delimiters are commonly used too, e.g. tab, pipe '|' and others.

An excel file depends on the version of Microsoft Excel ... prior to Excel 2007 they were a binary object, 2007 and beyond an XML based storage structure (I think).
Although excel file contains tabular data ... it is holds much more, e.g. formatting, formula's, VBA code.
LVL 25

Expert Comment

ID: 38372708
Here is a csv file ... and the same file saved as an excel file.
LVL 22

Assisted Solution

CompProbSolv earned 500 total points
ID: 38372721
@lwadwell regarding 2007 files as XML:

I just learned this recently and it is pretty cool.  Add .zip to the end of the file name for an Excel (or Word) 2007 file and then unzip it.  You'll see the XML files themselves.  It can be very handy for editing files externally or recovering a damaged file.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 33

Assisted Solution

by:Paul Sauvé
Paul Sauvé earned 500 total points
ID: 38373163
Basically, to read a csv file as an Excel file (version 2007 and later) you have to import the file using the Data tab -> Get External Data option -> From Text function.

This is a 3-step process that uses Excel's Import Text Wizard.

Author Comment

ID: 38373805
can i use csv file instead of excel. Does it make any difference. IT is easy to generate csv for me rather than xls file. Please advise. what is .xlsx file
LVL 33

Expert Comment

by:Paul Sauvé
ID: 38374013
Yhis article at Microsoft.com explains exactly what a csv file is: Excel formatting and features that are not transferred to other file formats.
CSV (Comma delimited)
This file format (.csv) saves only the text and values as they are displayed in cells of the active worksheet. All rows and all characters in each cell are saved. Columns of data are separated by commas, and each row of data ends in a carriage return. If a cell contains a comma, the cell contents are enclosed in double quotation marks.
If cells display formulas instead of formula values, the formulas are converted as text. All formatting, graphics, objects, and other worksheet contents are lost. The euro symbol will be converted to a question mark.
 Note   If your workbook contains special font characters such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system. For example, if you are using Windows and want to use the text file on a Macintosh computer, save the file in the CSV (Macintosh) format. If you are using a Macintosh computer and want to use the text file on a system running Windows or Windows NT, save the file in the CSV (Windows) format.
What is implied here is only the values are converted - NOT the formulae that could be present in th original Excel file.
LVL 25

Expert Comment

ID: 38374601
>> can i use csv file instead of excel.
You haven't explained what you are using it for ... hard to make an opinion.  If you are just outputting plain text (letters and numbers etc) then a csv is a very common approach used by many.

>> Does it make any difference.
Depends on the data and purpose.

>> what is .xlsx file
Up to version 2007 of Excel ... the files where .xls (the binary form I mentioned above), from version 2007 the new format and new name .xlsx is used.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question