What is a CSV file?

[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!

[eWish]

CSV stands for Comma Separated Values.


--Kevin

[npidaparthy]

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.

[poolboi]

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 :)