How to export WordPress users with WP All Export

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:

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:

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.

Complete the user export

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

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:

• 1. Expand the Export Type section.
• 2. Choose Spreadsheet.
• 3. Select the desired Excel format.

If you wanted to export an XML file, you:

• 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):

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

• Expand the Add Filtering Options section.
• In the Element box, select “billing_state.”
• In the Rule box, select “equals.”
• In the Value box, select “TX.”
• 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:

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:

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.

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

• Expand the Scheduling Options section.
• Choose Automatic Scheduling option.
• Choose the Every week on… option.
• Select Wed for Wednesday.
• Select 1:00am in the edit box below the What times do you want this export to run? prompt.
• 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.