January 21, 2022
Open laptop with the title, How to Export WordPress Users with WP All Export

Whether you’re trying to create a mailing list or move users from one WordPress website to another, WP All Export allows you to quickly and easily export what you need. You can:

  • Target specific groups of WordPress users with precise filters.
  • Include as much or as little user information as you like.
  • Rearrange, combine, or even customize user data fields using a convenient drag and drop interface.
  • Export your WordPress user data to a CSV file, Excel spreadsheet, or a custom XML file.
  • Download a special export bundle file that makes migrating users quick and painless.
  • Automatically export WordPress users on a schedule and integrate your exported data with external applications using Zapier.

This article covers everything you need to get started, and you can follow along on a free demo site here.

Create a New WordPress Users Export

Exporting WordPress users is easy. To perform a simple user export, go to All Export > New Export. This will bring you to the New Export screen:

Screenshot of WP All Export

1. Select Specific Post Type.

2. Choose Users.

3. Click the blue Customize Export File button at the bottom of the screen.

Customize the Export File

The Drag & Drop interface allows you to select, arrange, and modify the fields for your user export:

Exporting users in WP All Export

In this example, do the following:

  1. In the Available Data panel on the right, expand the Standard data section.
  2. Drag the Display Name, Last Name, and First Name fields into the column selection area.
  3. Click the blue Continue button.

WordPress User Export Settings

The Export Settings screen can be used to schedule your user exports and also for managing advanced settings. In this case, we’re going to skip these options by simply clicking the green Confirm & Run Export button.

Export ready to run in WP All Export

Complete the User Export

When your export process has finished, WP All Export will present you with this screen:

Export of WordPress users complete in WP All Export

To complete your export, click the CSV button in the Click to Download section. This will download a CSV file to your local computer.

That’s it! That’s how simple it is to export WordPress users with WP All Export.

Working with Other User Export File Types

To export WordPress users in one of the Microsoft Excel file formats, do the following back in the Drag & Drop Interface:

Selecting an Excel spreadsheet in WP All Export

1. Expand the Export Type section.

2. Choose Spreadsheet.

3. Select the desired Excel format.

If you wanted to export an XML file, you:

Drag and drop interface on WP All Import

1. Expand the Export Type section.

2. Choose Feed.

3. Select the desired XML format.

XML exports can be either simple or custom.

Filtering WordPress User Exports

In some cases, you only want to export a subset of users. To achieve this, you must add filters in the bottom section of the New Export screen (the first screen in the export process):

Adding filters to the WordPress users export

For example, to select only users from Texas, you:

  1. Expand the Add Filtering Options section.
  2. In the Element box, select “billing_state.”
  3. In the Rule box, select “equals.”
  4. In the Value box, select “TX.”
  5. Click the Add Rule button.

To apply multiple filters, just add more filter rules. For example, to select users from Dallas, Texas who have been active since January 01, 2021, you would set your filters as follows:

Adding multiple filters to WP All Export

Handling WordPress User Passwords

To export WordPress user passwords, simply include the User Pass export field from the Available Data > Other section of the Drag & Drop interface:

Exporting WordPress user passwords

Note that what gets exported are the hash values for the passwords, not the text versions. This is a security feature in case the export file is intercepted.

However, if you import the hashed passwords back into WordPress, users will still be able to log in using their old passwords.

Other Advanced Options

Custom Fields

WP All Export allows you to export any fields associated with users, not just the built-in WordPress fields. This means that if you have enhanced your user information with custom fields or through an add-on, extension, or plugin, you can export these fields, also.

Function Editor

If you need to manipulate the outgoing user data during the export process, you can create PHP functions to assist in this manipulation. For example, if you want to create a new field called “Days Since Active,” you can use PHP to calculate how many days have passed since each user was last active.

Scheduling Options

If you need to run a user export process on a schedule, you can do so through the Scheduling Options section of the Export Settings page. This is particularly useful if you need to keep an external system synchronized with your WordPress user data.

Setting the scheduling options in WP All Export

For example, to export WordPress Users every Wednesday at 1:00 a.m. Chicago time, you:

  1. Expand the Scheduling Options section.
  2. Choose Automatic Scheduling option.
  3. Choose the Every week on… option.
  4. Select Wed for Wednesday.
  5. Select 1:00am in the edit box below the What times do you want this export to run? prompt.
  6. Choose the UTC -5 - Chicago (CDT) timezone option.

Advanced Settings

Exporting an especially large user file? No problem. WP All Export provides an Advanced Options section on the Export Settings page. These options allow you to break exports into more manageable processing chunks, or to limit exports to only new or changed users since the last export, etc.

Finishing Up

As you can see, WP All Export makes it easy to Export WordPress Users. Give it a try with the steps outlined in this article.

With Nexcess WooCommerce Hosting, Better Is Built In

Nexcess offers fully managed hosting for WooCommerce designed for fast, high-performing stores. Nexcess also:

  • Offers high performance and site speed.
  • Dynamically scales and optimizes.
  • Secures your store with always-on monitoring.

Check out our fully managed WooCommerce hosting plans to get started today.

Trey Mills
Trey Mills

Trey started using WordPress in 2011. He records most of the walk-through videos for WP All Import, helps keep the support team on track, and manages features and bugfixes for free add-ons.

We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.