Support » Plugins and Hacks » Export User Meta to Excel/CSV

Export User Meta to Excel/CSV

  • 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!!

Viewing 3 replies - 1 through 3 (of 3 total)
  • I created a plugin for this: http://www.joostdevalk.nl/wordpress/users-to-csv/

    Let me know if that solves your problem 🙂



    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!


    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export User Meta to Excel/CSV’ is closed to new replies.