How To Export WordPress Users to CSV, Excel, or XML
To export WordPress users, go to WP All Export › New Export and select Users. Use drag & drop to set up your export, then run the export and download your file.
Step 1: Create a New WordPress Users Export
Go to All Export › New Export:
- Choose Specific Post Type.
- Select Users.
- Click Customize Export File. This will bring you to the Drag & Drop screen.
Step 2: Define Your WordPress User Export Columns
Most WordPress user exports only consist of a few data columns. You can select these columns using WP All Export's Drag & Drop interface.
The Available Data section on the right contains all the available data elements organized by categories.
To include a data element in an export, simply drag it from the Available Data section and drop it in the column selection area:
To remove a column from the export, drag & drop it outside the column selection area.
WordPress User Data Categories and Field
User data is divided by default into three categories: Standard, Custom Fields, and Other. However, if WooCommerce is installed, WP All Export will add a fourth category for WooCommerce customer billing and shipping address data, which it labels as Address. See the relevant sections below for more information.
Standard WordPress User Data
Data describing the user's WordPress user account are located in Available Data › Standard:
- ID: The user ID, assigned by WordPress
- Username: The username the user chose when creating their account
- User Email: Email address associated with the user account
- First Name: User's first name
- Last Name: User's last name
- User Registered: Date that the user registered
- User Nicename: Sanitized version of the username
- User URL: Website associated with the user account
- Display Name: The name to be displayed publicly, which is selected in WordPress as either the username, first/last, or nickname
- Nickname: A name chosen by the user to be displayed on the frontend
- Description: A description of the user, also labeled as Biographical Info in WordPress
WordPress User Custom Fields
Custom fields are extra information attached to the users on your WordPress site. They're also known as metadata. Many pieces of data are stored as custom fields such as a product's price or a real estate property's address. You can find this data in Available Data › Custom Fields.
By default, users will not have any custom fields. However, plugins and themes will add them. Because they depend entirely on which plugins or themes have been installed, we do not have a predefined list of custom fields. Also, since many of these fields tend to be used for internal purposes, their names may not be meaningful at first glance:
However, having access to these fields may make the difference between a successful vs unsuccessful user export.
WooCommerce Address Fields
The billing and shipping address fields that WooCommerce attaches to users are also custom fields. However, to make these fields more readily accessible, WP All Export creates a separate section for them in Available Data -> Address.
These fields include:
- Billing First Name
- Billing Last Name
- Billing Company
- Billing Address 1
- Billing Address 2
- Billing City
- Billing Postcode
- Billing Country
- Billing State
- Billing Email
- Billing Phone
- Shipping First Name
- Shipping Last Name
- Shipping Company
- Shipping Address 1
- Shipping Address 2
- Shipping City
- Shipping Postcode
- Shipping Country
- Shipping State
WordPress User Other Data
You can find other, less common user fields in Available Data-> Other. These include:
- User Role: All users have a role that determines what they can do when logged in. You can read more about user roles here: https://wordpress.org/support/article/roles-and-capabilities/
- User Pass: A hash of the user's password. Read the next section for more information on user passwords.
- Everything else. There's a lot of user data that the vast majority of people will never need to export. In case you do, it's all here.
Exporting WordPress User Passwords
To export a WordPress user password, drag the User Pass field from Available Data -> Other into the column selection area.
These are hashes of the passwords, not the passwords themselves. Hashing is a one-way action that irreversibly scrambles a string of text. It is not possible to reverse the hashing process and reveal the original password. You can, however, import the hashed passwords back into WordPress and users will be able to log in with their old password.
Step 3: Download Your WordPress User Export
Once your WordPress User export is properly configured, click Continue and verify the export settings. To run your export, click Confirm & Run Export.
When the export finishes, click CSV to download your user data:
Another option is to click Bundle, which downloads a zip file containing both the export file and an import template. WP All Import can use this template to import WordPress users on another site, which is a very convenient way to migrate users from one site to another.
WordPress User Export Advanced Topics
Exporting to Other File Types
In the preceding tutorial, we exported our WordPress Users to a CSV file by default. WP All Export can also export users to Excel or XML.
To use Excel, do the following in the Drag & Drop interface:
- Expand the Export Type panel below the column selection area.
- Choose Spreadsheet.
- Select Excel File XLS or Excel File XLSX.
Want to export to XML instead?
- Expand the Export Type panel.
- Choose Feed.
- Select Simple XML Feed or Custom XML Feed.
Export WooCommerce Users Advanced Options
The Advanced Options panel is found just above the Export Type panel when exporting to CSV or XML. It is not present when exporting to Excel. Here is what it looks like when exporting to CSV:
With CSV files, there are only two options:
- Separator, which defines the character to be used to separate one column from another. The default option is to use a comma (,). Another popular option is to use a pipe character (|).
- Include header row and column titles in export: When selected, the first row is a header row with column titles. If not selected, the first row simply contains the data for the first user with no header or column titles.
To understand the XML options, read our guide on exporting WordPress data to XML.
Filtering User Exports
Sometimes, you may want to export only a subset of WordPress users.
To do this, expand the Add Filtering Options panel near the bottom of the New Export screen. A filter rule requires an Element, a Rule, and a Value:
In this case, we are filtering for:
Element = billing state
Rule = equals
Value = "TX" for Texas
Expressed verbally, this says, “Export all WordPress Users with a billing address in Texas.”
You can also combine multiple filter rules. For example, you can add an "Or" condition to include users from Florida, too:
You can create whatever combination of filters that you require.
Frequently Asked Questions
How to Export All WordPress Users?
Run a standard export as described in this document. Select your export columns as usual but do not apply any filters. When you export WordPress users without filters, this will automatically export all users in the WordPress database.
How to Import WordPress Users?
- In the WordPress main menu, navigate to All Import > New Import.
- Choose how you want to load your data (i.e. upload file, use a URL, etc.).
- Select your import file and your import target (i.e. Users).
- Use the Drag & Drop interface to map incoming fields to your WordPress user fields.
- Run the import.
How to Migrate WordPress Users to Another Website?
- Export the users that you wish to migrate. When you do this, download the Bundle option instead of a CSV file. The bundle file contains an import template in addition to the export data file.
- Install WP All Import on the target site.
- Import the bundle file. WP Import will know what to do from there, allowing you to just accept the import default settings.
- Check the imported users.
See Migration Overview for more information.
Can I Export WordPress User Passwords? Is That Secure?
WP All Export lets you export hashed passwords, which are completely encrypted and secure. You can then import them back into WordPress and users will be able to use their old passwords without ever exposing them to others.
Can I Export WordPress User Data From Other Plugins or WooCommerce Extensions?
Yes. WP All Export automatically detects custom data added by other plugins. You can export this custom user data the same way that you export any other type of WordPress data. This is just one of the ways that our software makes your import/export tasks easier.
How Do I Schedule My WordPress User Exports?
You can schedule your WordPress user exports to run automatically using either cron jobs on your server, or our automatic scheduling service to set your user export schedule directly from our interface. Talk about convenience!
To learn more, please see How to Schedule WordPress Exports.
Export WooCommerce products into a CSV or XML file with WP All Export.
Export your WooCommerce reviews using WP All Export.