What is a CSV file?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • poolboi
    New Member
    • Jan 2008
    • 170

    What is a CSV file?

    hey guys

    posted a request on how to convert CSV to excel earlier
    just wanna know the confusion here
    what exactly is a CSV file?

    is it supposed to be an excel CSV file? or is it just a normal file?
    cos what i have is just a FILE apllication where i have to use notepad to open and i then am able to see data with commas in it

    however when i save with an extension of .csv i got an excel of data with commas in it?
    help clarify thanks you!
  • eWish
    Recognized Expert Contributor
    • Jul 2007
    • 973

    #2
    CSV stands for Comma Separated Values.


    --Kevin

    Comment

    • npidaparthy
      New Member
      • Feb 2008
      • 14

      #3
      Originally posted by poolboi
      hey guys

      posted a request on how to convert CSV to excel earlier
      just wanna know the confusion here
      what exactly is a CSV file?

      is it supposed to be an excel CSV file? or is it just a normal file?
      cos what i have is just a FILE apllication where i have to use notepad to open and i then am able to see data with commas in it

      however when i save with an extension of .csv i got an excel of data with commas in it?
      help clarify thanks you!


      CSV is Comma Seperated Value

      when u save the file with csv extension and, when u try to open the file it will open in Excel

      if you want to do some operations on the file and put in the excel, Perl supports that also

      let me know if it this information helps you.

      Comment

      • poolboi
        New Member
        • Jan 2008
        • 170

        #4
        yup
        i've found out if u save with extension it opens in an excel file

        now i have a csv file without the extension .csv file, i dunno what it is
        but i'm trying to figure out if using a perl program i want to convert it into an excel file how should i do it? should i have a program that opens the csv file and the using saveAs i convert it to an excel file??

        hm .. i also need top like do some operation in the excel format like get rid of the commas, and get rid of some particular column of information in the excel file
        yeah thanks :)

        Comment

        Working...