Page 1 of 1

Excel - CSV ?

Posted: Thu Jan 06, 2005 7:56 pm
by Steveo31
I'm lookin for a way to get Excel data to CSV, in which I can deal with it in PHP to put into MySQL. I'm havin probs figuring where to start. I thohgt Excel could export directly to CSV, but I can't find anything on it.

:?:

Posted: Thu Jan 06, 2005 7:56 pm
by markl999
In Excel File->Save As has a CSV option (in the save as type drop down).

Posted: Thu Jan 06, 2005 7:58 pm
by feyd
File > Save As...
Scroll down the pull down to CSV.

There's probably a macro you can create to do it too, dunno it though as I hate scripting Excel. :)

mark beat me! :P *bang-bang-bang*

Posted: Thu Jan 06, 2005 7:58 pm
by markl999
whahahahah ;)

Posted: Thu Jan 06, 2005 8:55 pm
by Steveo31
Doh... duh. Hah, saw that right after I posted.

Why this get moved? I guess I ..yeah, I didn't make clear what I'm trying to do. I think there's some regex involved.. I need to get those values in an easy to use fashion. Not askin someone to do it for me, but is regex what I'm after?

Posted: Thu Jan 06, 2005 8:56 pm
by markl999
Is fgetcsv what you want? Works for me ;)