Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


csv file definition

Posted on 1998-04-29
Medium Priority
Last Modified: 2010-04-06
Can anyone explain the difference between a comma seperated value/variable (.csv) file and a comma delimited ascii file. CSV files seem to have headers with field definitions - is this always the case?

Thanks, Tom.
Question by:tomcorcoran
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 1339470
Our office uses the .csv file when we need to debug the data file.  Since the file is always loaded into Excel, it proves to be beneficial to have the headers visible.  I would say that it is not always the case to have the headers, but it make it a lot easier to find fields.

Accepted Solution

peter_vc earned 160 total points
ID: 1339471
CSV files and comma delimited files generally refer to the same thing.  The one with headers in them make it possible to use those files with things like ODBC, and as scott007 said, as column headers when importing into spreadsheets.

The actual grammar of the file depends on whoever wrote the software.  Most times string fields will have quotes surrounding them and numeric fields will not.  As far as the headers go, most do not have headers (at least from all the ones I've ever seen).


Author Comment

ID: 1339472
Peter_vc, so wahta you are saying is that most of the time csv files and comma delimited files are one and the same?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 1339473
Peter_vc, so what you are saying is that most of the time csv files and comma delimited files are one and the same?

Expert Comment

ID: 1339474
I'd have to say that all of the time csv files and comma delimited files are one and the same.

Author Comment

ID: 1339475
Well, pesonally I have never seen a header in a traditional comma-delimited file but maybe you can get them...

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA:…
Suggested Courses

661 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