By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

What is a CSV file?

100+
P: 170
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!
Feb 14 '08 #1
Share this Question
Share on Google+
3 Replies


eWish
Expert 100+
P: 971
CSV stands for Comma Separated Values.


--Kevin
Feb 14 '08 #2

P: 14
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.
Feb 16 '08 #3

100+
P: 170
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 :)
Feb 18 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.