WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Import data from excel file to a custom post type (9 posts)

  1. slurve
    Member
    Posted 3 years ago #

    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

  2. vtxyzzy
    Member
    Posted 3 years ago #

    Check the CSV Importer plugin.

  3. slurve
    Member
    Posted 3 years ago #

    Thanks for the recommendation. I ended up using CSV Importer and the Custom Post Type switcher plugin.

  4. vtxyzzy
    Member
    Posted 3 years ago #

    Glad you got it working. Now, please use the dropdown on the right to mark this topic 'Resolved'.

  5. Vegas Kev
    Member
    Posted 3 years ago #

    @vtxyzzy:

    Do you have any experience using the CSV Importer plugin for a few hundred thousand posts?

  6. satheesNava
    Member
    Posted 3 years 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

  7. Vegas Kev
    Member
    Posted 3 years 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.

  8. nsathees
    Member
    Posted 2 years ago #

    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.

  9. esmi
    Forum Moderator
    Posted 2 years ago #

    Please post a new topic.

Topic Closed

This topic has been closed to new replies.

About this Topic