Import users from CSV with meta
Clean and easy-to-use Import users plugin. It includes custom user meta to be included automatically from a CSV file and delimitation auto-detector. It also is able to send a mail to each user imported and all the meta data imported is ready to edit into user profile.
Import CSV file with users directly to your WordPress
Import thousends of users in only some seconds
You can also import meta-data like data from WooCommerce customers using the correct meta_keys
Send a mail to every new user
Use your own
You can also update data of each user
Assing a role
Create a cron task to import users periodically
Edit the metadata (you will be able to edit the metadata imported using metakeys directly in the profile of each user)
Read our documentation
Ask anything in support forum, we try to give the best support
Moreover this plugin is compatible with:
WooCommerce: to import the customer data
WooCommerce Membership: to import memberships
BuddyPress: to import custom BuddyPress fields, groups and roles
Paid Membership Pro: to import memberships
Indeed Ultimate Membership Pro: to import memberships
Allow Multiple Accounts: plugin will allow the same rules importing than this plugin
New User Approve: you can import users and approbe/wait for approve them
Users Group: to assign users to groups while importing
WP LMS Course: to enroll users in the courses while importing
WP Members: to import memberships
WP Users Group: to assign users to groups while importing
In Codection we have more plugins, please take a look to them.
RedSys Gateway for WooCommerce Pro a plugin to connect your WooCommerce to RedSys (premium)
Ceca Gateway for WooCommerce Pro a plugin to connect your WooCommerce to Ceca (premium)
BBVA Bancomer for WooCommerce Pro a plugin to connect your WooCommerce to BBVA Bancomer (premium)
RedSys Button for WordPress a plugin to receive payments using RedSys in WordPress without using WooCommerce (premium)
RedSys Gateway for Contact Form 7 a plugin to receive payments using RedSys in WordPress using the popular contact plugin Contact Form 7 (premium)
Ceca Gateway for Contact Form 7 a plugin to receive payments using Ceca in WordPress using the popular contact plugin Contact Form 7 (premium)
RedSys Gateway for WP Booking Calendar Pro a plugin to receive payments using RedSys in WordPress using WP Booking Calendar Pro (premium)
RedSys Gateway for Goodlayers Tourmaster Pro a plugin to receive payments using RedSys in WordPress using Goodlayers Tourmaster Pro (premium)
Clean Login a plugin to create your own register, log in, lost password and update profile forms (free)
Import users from a CSV easily
And also extra profile information with the user meta data (included in the CSV with your custom fields)
Just upload the CSV file (one included as example)
All your users will be created/updated with the updated information, and of course including the user meta
Autodetect delimiter compatible with
semicolon ; and
Once the plugin is installed you can use it. Go to Tools menu and there, there will be a section called Insert users from CSV. Just choose your CSV file and go!
You can generate CSV file with all users inside it, using a standar spreadsheet software like: Microsoft Excel, LibreOffice Calc, OpenOffice Calc or Gnumeric.
You have to create the file filled with information (or take it from another database) and you will only have to choose CSV file when you “Save as…” the file. As example, a CSV file is included with the plugin.
Plugin will automatically detect:
Charset and set it to UTF-8 to prevent problems with non-ASCII characters.
It also will auto detect line-ending to prevent problems with different OS.
Finally, it will detect the delimiter being used in CSV file
Install Import users from CSV with meta automatically through the WordPress Dashboard or by uploading the ZIP file in the plugins directory.
Then, after the package is uploaded and extracted, click Activate Plugin.
Now going through the points above, you should now see a new Import users from CSV menu item under Tool menu in the sidebar of the admin panel, see figure below of how it looks like.
If you get any error after following through the steps above please contact us through item support comments so we can get back to you with possible helps in installing the plugin and more.
Please read documentation before start using this plugin.
You should fill the first two columns with the next values: Username, Email.
The next columns are totally customizable and you can use whatever you want. All rows must contains same columns. User profile will be adapted to the kind of data you have selected. If you want to disable the extra profile information, please deactivate this plugin after make the import.
You can use a column called id in order to make inserts or updates of an user using the ID used by WordPress in the wp_users table. We have two different cases:
If id doesn’t exist in your users table: WordPress core does not allow us insert it, so it will throw an error of kind: invalid_user_id
If id exists: plugin check if username is the same, if yes, it will update the data, if not, it ignores the cell to avoid problems
We can use a column called “Password” to manage a string that contains user passwords. We have different options for this case:
If you don’t create a column for passwords: passwords will be generated automatically
If you create a column for passwords: if cell is empty, password won’t be updated; if cell has a value, it will be used
Plugin can import serialized data. You have to use the serialized string directly in the CSV cell in order the plugin will be able to understand it as an serialized data instead as any other string.
Plugin can import lists as an array. Use this separator: :: two colons, inside the cell in order to split the string in a list of items.
WordPress default profile data
You can use those labels if you want to set data adapted to the WordPress default user columns (the ones who use the function wp_update_user)
user_nicename: A string that contains a URL-friendly name for the user. The default is the user’s username.
user_url: A string containing the user’s URL for the user’s web site.
display_name: A string that will be shown on the site. Defaults to user’s username. It is likely that you will want to change this, for both appearance and security through * obscurity (that is if you don’t use and delete the default admin user).
nickname: The user’s nickname, defaults to the user’s username.
first_name: The user’s first name.
last_name: The user’s last name.
description: A string containing content about the user.
jabber: User’s Jabber account.
aim: User’s AOL IM account.
yim: User’s Yahoo IM account.
user_registered: Using the WordPress format for this kind of data Y-m-d H:i:s.
You can upload as many files as you want, but all must have the same columns. If you upload another file, the columns will change to the form of last file uploaded.
Free and premium support
You can get:
Customizations, addons, develops…