+ Reply to Thread
Results 1 to 2 of 2

What is csv?

  1. #1
    Registered User
    Join Date
    04-26-2005
    Posts
    43

    What is csv?

    What does it mean when an excel sheet is downloaded with ".csv"?

  2. #2
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    CSV stands for Comma Separate Values. If you load the data in notepad, it might look something like:
    Please Login or Register  to view this content.
    The file would generally have a .CSV suffix at the end of the filename to let packages such as Excel know what sort of data is contained and how to deal with it.
    (Excel has an XLS suffix, Word a DOC suffix, Notepad a TXT suffix. You might not be able to see the suffixes unless your PC has been configured to view them.)

    Now if you load the same data into Excel, Cell A1 = 1, B1=212, C1=44, D1=24, E1=4, A2=2, B2=3 and so on. The only difference is that there would be no formatting in a csv file; it is text ONLY separated by commas. You can also get Tab Delimited Files, Space Delimited Files, Tilde (~) and pretty well anything else you could choose. Excel will read them all ignoring the delimiters and placing the rest of the data into unique cells.

    Unless a person is involved in the automated sharing of data via a database/software package, then it's eally not worth bothering much with it as a format although it's worth knowing that csv's exist.

    I hope this helps.
    Martin Short

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1