How To Export WordPress Users to CSV or XML
To export WordPress users go to WP All Export › New Export and select Users. Then drag and drop to set up your CSV/XML, including automatically detected custom user data.
Select WordPress User Data to Export
Drag and drop elements from Available Data into the export editor on the left to add them to your export file. You can click the Preview button to see what your export file looks like.
User data is into four different categories: Standard, Address, Custom Fields, and Other.
Exporting Standard WordPress User Data
Data describing the user's WordPress user account are found 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
Exporting WordPress User Address Data
By default, WordPress does not include billing and shipping address data fields. Installing and activating WooCommerce adds these fields to all users on your site.
With WooCommerce, each user account has two identical sets of address data, one for shipping and one for billing:
- First Name
- Last Name
- Address 1
- Address 2
Exporting 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, like a product's price or a real estate property's address.
By default, users will not have any custom fields attached to them. Plugins and themes, however, will add them. In fact, this is how WooCommerce adds the billing and shipping addresses to user accounts. WP All Export knows about those custom fields, so it moves them to the Address section. WP All Export will automatically detect other custom fields, and add them to Available Data › Custom Fields.
Other User Data
Here you can find other less common user fields, such as:
- 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 on for more on user passwords.
- And 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, include the User Pass export field from Available Data › Other.
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.