Beginner's Guide for WordPress - Start your WordPress Blog in minutes.
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
WordPress Plugins
View all Guides

How to Export WordPress Users Data to a CSV File

Last updated on by
Special WordPress Hosting offer for WPBeginner Readers
How to Export WordPress Users Data to a CSV File

Recently, one of our users reached out to us asking how to export WordPress users data to a spreadsheet. We have done it in the past using a SQL query in phpMyAdmin. Instead of telling the user a long method, we decided to search for a plugin that would do it. Clearly, there is one that works. In this article, we will show you how to export WordPress users data to a CSV file (spreadsheet).

First thing you need to do is install and activate the Export Users to CSV plugin.

Upon activation, you will see a new menu item being added under users called Export to CSV.

Export Users to CSV

As you can see in the screenshot above, you have the option to export all users or a specific user role. More importantly, you can export user data from a certain time period.

You are probably wondering why would anyone use this feature? Well in this particular case, the user wanted to export the list of their customers from WooCommerce. However, it seems like that this feature is not built-in. Upon further research, we found an extension they have which costs $29, which is a bit steep. A functionality like this should be in the core of the plugin.

Anyways, if you want to export all user meta data into a spreadsheet, then use Export Users to CSV plugin.

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Page maintained by Syed Balkhi.

WPBeginner's Video Icon
Our HD-Quality tutorial videos for WordPress Beginners will teach you how to use WordPress to create and manage your own website in about an hour. Get started now »


  1. Stef says:

    This plugins is deprecated but still works perfectly. I can’t believe all the information we were able to retrieve. Love it.

    Thanks for this post.

  2. Q says:

    This plugin is no longer maintained and out of date – better to try our new version here –

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.