Import / Export Users

Profile Builder has been tested and is fully compatible with two third party plugins that allow you to Import or Export users in WordPress.

Until we finalize developing our built in Import / Export Users Add-on, we’ll be offering support for importing or exporting your users via these tools.

So if you’re looking for an easy way to Import / Export users from/into a .CSV file feel free to use the step by step guide below.

Note – Before Importing or Exporting your Users please do a backup of your database. This will help you restore your database in case something will not work correctly.

Importing Users from a .CSV file

1. Download and install Import users from CSV with meta plugin

Get Import users from CSV with meta

2. Using Profile Builder make sure to create all your desired Extra Fields Types, before you Import, giving them the same meta names as the ones from the .CSV file and also set the Overwrite Existing option to Yes

This way after the Import you will be able to Edit and Manage all the imported Extra Fields Types via Profile Builder.

3. The .CSV file that you want to import needs to have a certain structure, so the import plugin works correctly:

1. The 1st column from your .CSV file needs to be Username and the 2nd one needs to be Email. If the Username and Email columns match existing entries in your database, that user will be updated, else a new user will be created

2. The 3rd column should be Password and if it’s empty, the passwords of the users will not be touched, if you enter a value here, this will be the new users password; if you do not create this column, the users password will be automatically generated by WordPress

3. The next columns should be the meta names that you created in Profile Builder -> Manage Fields for the fields that you want to Import

4. Download a .CSV sample file

4. The Import users from CSV with meta Add-on settings will be located under Tools -> Import users from CSV

Profile Builder - Import users from CSV with meta

Choose if you want to update existing users, the role that new users will receive, if you want to update the role for existing users, your .CSV file, choose what should the plugin do with empty cells and also if you want to send emails, then click Start Importing.

Note – Each row in your .CSV file should represent a user; each column identifies user data or meta data. If a column name matches a field in the user table, data from this column is imported in that field; if not, data is imported in a user meta field with the name of the column.

Note – After importing, you will see the imported custom fields being displayed twice in the Back-end User Profile. You will need to disable the Import plugin for them to only be showed once and correct.

Exporting Users to a .CSV file

1. Download and install the Export User Data plugin

Get Export User Data

2. Once activated the plugin settings will be located under Users -> Export Users Data

Profile Builder - Export User Data

You’ll be able to filter fields, select all fields or only some fields, set the format or even store your export options.

In the Advance Options tab you will be able to select if you want to export standard user fields, if you want to export a specific user role or all the roles and also to export based on registration date, a limit range or based on updated since date.

Note – If you don’t want to add inside the exported file the default fields like user_login, user_nicename, user_email, user_url, user_registered, user_status, display_name go to Users -> Export User Data -> Advanced Options -> Show -> Uncheck “Standard User Fields”. Keep in mind that the ID will still be added inside the exported file

3. Click Run Export and you’re done. Once you click the Run Export button, you’ll be prompted with a .CSV file containing all the user data and metadata selected including Extra Fields Types created and managed with Profile Builder.

Profile Builder - Export Users CSV