Excel - CSV ?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Excel - CSV ?

Post 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.

:?:
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

In Excel File->Save As has a CSV option (in the save as type drop down).
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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*
Last edited by feyd on Thu Jan 06, 2005 7:58 pm, edited 1 time in total.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

whahahahah ;)
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post 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?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Is fgetcsv what you want? Works for me ;)
Post Reply