Export WordPress Users to CSV

In this article, I will explain how to export users from your WordPress installation using Admin Columns Pro. I will show you how to create the perfect CSV export that suits your needs in just a few clicks.

The reason to export users is usually the need to import them into other software that is not connected with WordPress. The challenge is always to format your content in such a way that other software understands it. Luckily, CSV (Comma-separated values) is one of the most well-supported ways to do that: it formats content using columns and rows. And very conveniently, this is much like the overview screen itself.

Creating the CSV export

For this article, I have created a use-case to demonstrate how exporting users works: I have users in my WordPress installation of which some are companies and some are individuals and I need to import the companies into another piece of software. Let’s get started!

First of all, we are going to create a new Column Set that we make just for this export. I do this to not interfere with the overview I use for my day-to-day management of users.

Create new Export column set

You can simply discard this Column Set afterward. However, if you have to export your users more often, it might be handy to keep around to quickly redo this export.

Now let’s choose the columns that we need for this export using the Admin Columns settings screen. We only add the columns that the other piece of software supports, which in this case is the name, address, CEO and company type.

Final export column set

As you can see, we have selected the fields we want to export. But wait, we also have some individual users on our screen. Let’s filter them out as we don’t want them in our CSV:

The actual CSV will also contain exactly these columns (including the headings) and the total number of results. Just enable “export” on the screen options on the top right and press the button. Even very large datasets are no problem. The download will build in the background and will keep you informed about the progress.

Users exported

And now we have a CSV document with the same information that was on your screen a few seconds ago:

Users exported

As you can see, exporting your users, or really any content from any overview screen is really simple and flexible. If you need to export your content and want control over what it is you export, Admin Columns Pro can be a real time-saver.