export mysql data into multiple rows in excel
Posted on 2013-11-04
I have a plugin in wordpress that sets up addresses for a google map.
I'd like to export the data into separate columns in Excel. My first attempt didn't work as it puts everything into 1 column in Excel.
I can get the information exported out of phpMyAdmin correctly, but need to split what's exported into name, address, city, state, zip.
Here's how it exports
"310 E. Argonne Dr
Kirkwood, MO 63122
Mail to: PO Box 515134
Pastor: Thomas Lovis"
Is there something I'm missing on the export or a tool in Excel that I'm overlooking? I tried data to columns but it only grabbed the address.