Anyone know what's involved with importing data from an excel sheet directly into phpMyAdmin? Basically, I have a custom post type set up for a business directory. Each business has an address, phone, website url, etc. Normally I would enter all this through the WP interface, filling out each custom field. But this excel sheet I have lists around 350 businesses, so entering them manually makes me want to consider a career change. Is it possible to automate this somehow? Or import the excel sheet directly into MySQL somehow? Thanks in advance for any help.
Tom
Thanks for the recommendation. I ended up using CSV Importer and the Custom Post Type switcher plugin.
Glad you got it working. Now, please use the dropdown on the right to mark this topic 'Resolved'.
Vegas Kev
Member
Posted 1 year ago #
@vtxyzzy:
Do you have any experience using the CSV Importer plugin for a few hundred thousand posts?
satheesNava
Member
Posted 10 months ago #
Hey if any one looking to import Excel sheet with custom fields and AIO SEO data here is one plugin called xl2wp.
can be found at http://xl2wp.sigmaNames.com
Vegas Kev
Member
Posted 10 months ago #
@SatheesNava....I haven't tried that one...but the CSV Importer plugin by dvkob is pretty good and robust. You should give it a shot.
But the CSV Importer do not import All in One SEO data! xl2wp does import them too and it is difficult to manage the escape for , within the CSV file.
slurve
