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.
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.