is .CSV just a text file ?
Reason I ask is I'm wanting people to save a .xls file as a .csv and upload/insert into a database.
I know a virus and other nasties can be inserted into a .xls file via macros and stuff. Will the macros and nasties be transfered into the .csv or is the .csv strictly a text based file. ?
compwolf posted this at 06:15 — 6th July 2004.
He has: 72 posts
Joined: Nov 2003
To the best of my knowledge it is just a text file that uses commas to indicate the columns ... I have not researched this very well so I may be wrong ...
openmind posted this at 08:07 — 6th July 2004.
He has: 945 posts
Joined: Aug 2001
I cannot see how a macro could become embedded ito a csv as, you rightly stated, it's just a text file with values seperated by commas
Busy posted this at 09:30 — 6th July 2004.
He has: 6,151 posts
Joined: May 2001
Thanks for the replies guys
From the research I've done, there is no black and white answer whether it is just a plain old text file or has methods of hiding objects.
From lack of information, I gather it is just a plain old text file.
adam_1 posted this at 12:07 — 6th July 2004.
He has: 23 posts
Joined: Jun 2004
I have saved CSV and when opened in notepad that are just Comma Seperated Values (or was it Variables).
There is no formatting and no code.
Busy posted this at 21:57 — 6th July 2004.
He has: 6,151 posts
Joined: May 2001
A .csv file can be opened anywhere, even excell, this is why I ask because the file is created in excell, which can include macros etc and has formatting, then saved as .csv but when the file is reopened in excell it still retains the formatting (tabs).
So if it can be formatted by commas, can triggers or macro codes etc be hidden in them.
maybe the sleep in notepad but reawake in excell.
I don't know, I have no idea, hense the reason I asked
OtterBob posted this at 23:16 — 6th July 2004.
He has: 46 posts
Joined: Jun 2004
No, it's a plain-text format. All a .csv file contains is data. It's perfectly safe.
"In theory, there's no difference between theory and practice. In practice, there is." -- Yogi Berra
andy206uk posted this at 08:31 — 7th July 2004.
He has: 1,758 posts
Joined: Jul 2002
Yup... CSV contains absolutly nothing but data. Any macro's that were hidden would come into excell as plain text in a cell. CSV's are completly safe. (well... as safe as .txt files).
Andy
Busy posted this at 09:12 — 7th July 2004.
He has: 6,151 posts
Joined: May 2001
Thanks guys
Everyday is a learning day
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.