Export User Meta to Excel/CSV (4 posts)

  1. x9tripboarder16
    Posted 8 years ago #

    I've searched pretty well through the previous posts with no luck. I'm looking for a plugin that would do two things, or a way to do it manually. I've added more form fields to the User Meta, and I want to be able to export all that information into a CSV or Excel file. The exporter from PHP MyAdmin groups everything into separate chunks. In other words, it makes it difficult for me to create a mail merge because all the tags are in multiple places in the same columns. If there is no plugin, is there a way to group items with similar tags together in excel?

    Second, is there a plugin that would allow me to mass create users from and Excel document? I want to import information into the database and create users for each row. I've tried importing a few into PHP MyAdmin, but I keep getting errors.

    Any help is greatly appreciated!!

  2. Joost de Valk
    Posted 7 years ago #

    I created a plugin for this: http://www.joostdevalk.nl/wordpress/users-to-csv/

    Let me know if that solves your problem :)

  3. scormeny
    Posted 7 years ago #

    I just installed the users2csv plugin on my blog at thenovelette.com , running WP 2.2.X -- it works as advertised.

    I wouldn't mind an option (or default) that screened out administrators, and if possible I'd like to get the user firstnames and lastnames exported too.

    Thanks for a great plugin!


  4. Joost de Valk
    Posted 7 years ago #

    scormeny: the first name, last name and nickname are exported if you upgrade to version 1.2, some of the other clutter has been removed.

Topic Closed

This topic has been closed to new replies.

About this Topic