Import Users from CSV

Description

This plugin allows you to import users from an uploaded CSV file. It will add users with basic information as well as meta fields and user role.

You can also choose to send a notification to the new users and to display password nag on user login.

Check out our other free plugins.

Features

  • Imports all users fields
  • Imports user meta
  • Update existing users by specifying ID field
  • Allows setting user role
  • Sends new user notification (if the option is selected)
  • Shows password nag on user login (if the option is selected)

For feature request and bug reports, please use the forums.
Code contributions are welcome on Github.

Import Users From Any CSV/Excel/XML with WP All Import Pro

WP All Import Pro can import WordPress users, WooCommerce products, ACF, custom post types, custom fields, taxonomies, and everything else:

  • Drag & Drop to Import Any File: Give any CSV or XML to WP All Import, then drag and drop to map data from your file into WordPress.
  • Any Custom Post Type, Every Data Type: Import data to custom post types, with support for WooCommerce, ACF, custom fields, taxonomies, and everything else.
  • Import Images & Galleries: Images can be uploaded, downloaded, or matched to media already in WordPress. Full support for WooCommerce product images and variation galleries.
  • Import Files from URL: Download and import files from external websites, even if they are password protected. URL imports are can be re-run to add, edit, and delete posts.
  • Scheduled Imports: WP All Import Pro can check periodically check a file for updates and then add, update, or delete to the imported posts accordingly.
  • Developer Friendly: Pass data through custom PHP functions. For example, use something like [my_function( {user_email[1]} )] in your template, to pass the value of {user_email[1]} to my_function and display whatever it returns.
  • Priority Support: Personal support from our team of expert developers with over a decade of experience importing and exporting WordPress data.
  • 90 Day Money Back Guarantee: Not 100% happy? Let us know, and we’ll promptly send you a refund. No questions asked.

Check out WP All Import today.

Screenshots

  • User import screen

Installation

For an automatic installation through WordPress:

  1. Go to the ‘Add New’ plugins screen in your WordPress admin area
  2. Search for ‘Import Users from CSV’
  3. Click ‘Install Now’ and activate the plugin
  4. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

For a manual installation via FTP:

  1. Upload the import-users-from-csv directory to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ screen in your WordPress admin area
  3. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

To upload the plugin through WordPress, instead of FTP:

  1. Upload the downloaded zip file on the ‘Add New’ plugins screen (see the ‘Upload’ tab) in your WordPress admin area and activate.
  2. Upload your CSV file in the ‘Users’ menu, under ‘Import From CSV’

FAQ

How to use?

Click on the ‘Import From CSV’ link in the ‘Users’ menu, choose your CSV file, choose if you want to send a notification email to new users and if you want the password nag to be displayed when they login, then click ‘Import’.

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.

Look at the example.csv file in the plugin directory to have a better understanding of how the your CSV file should be organized.

You can try importing that file and look at the result.

Credits

Thanks to Ulrich Sossou for initially creating this plugin. Be sure to check out his other WordPress plugins or GitHub profile.

Reviews

☀️ 8️⃣ 21, 2024
If you have a list of 2-3 users, things work fine. If you scale up to anything larger than that, it times out pretty quickly. At that point, just create them manually.
🌸4️⃣ 9, 2024
The external plug-in used to work perfectly, since they force us to use this plugin for Paid Memberships Pro I have had nothing but failures. Constantly exceeds the memory of the server, error 500 constantly, I deleted the import_membership_id field damaging many logical programming that I have on my site with this field … They should give the option to use this or the previous one.
🍂 9️⃣ 1, 2022
Worked really well. Two tips for new users: 1) Use the example CSV file to get your data formatted for import 2) Ensure you use ALL the columns required (you don’t need to worry about the custom ones) Thanks for saving me loads of pain importing multiple users.
🌸5️⃣ 18, 2022
I downloaded this plugin in desperation yesterday and it did exactly what I needed it to. The sample of what the csv file should look like enabled me to merge data from MailChimp and WooCommerce to add user to the site, so they could log in. Terrific plug-in!
☀️ 8️⃣ 11, 2021
It met my need immediately. Thank you for creating and maintaining this plugin.
❄️1️⃣ 21, 2019
Update 1.0.1 works great, definitely recommend this plugin. Thanks
Read all 43 reviews

Contributors & Developers

“Import Users from CSV” is open source software. The following people have contributed to this plugin.

Contributors

“Import Users from CSV” has been translated into 6 locales. Thank you to the translators for their contributions.

Translate “Import Users from CSV” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.3.1

  • bug fix: restore missing notice file

1.3

  • bug fix: don’t instantiate serialized objects

1.2

  • BUG FIX: Ensure user running import has the ability to add users
  • Update tested to
  • minor UI update

1.1

  • ENHANCEMENT: Added support for WPCLI (@mircobabini)
  • ENHANCEMENT: Added support for multiple roles during import, use comma-separated value for multiple roles (@mircobabini)
  • ENHANCEMENT: Removed password nag option as this is no longer supported.
  • ENHANCEMENT: New filter added ‘is_iu_errors_filter’ for throwing error messages. Helpful for third party developers extending onto IUCSV functionality.

1.0.1

  • Fixed timeout bug on import.
  • Improved settings area layout.
  • General code refactor and improved security.
  • Screenshot update.

1.0.0

  • Fixed bug where importing fields with “0” value doesn’t work
  • Added option to update existing users by username or email

0.5.1

  • Removed example plugin file to avoid invalid header error on
    installation

0.5

  • Changed code to allow running import from another plugin

0.4

  • Switched to RFC 4180 compliant library for CSV parsing
  • Introduced IS_IU_CSV_DELIMITER constant to allow changing the CSV delimiter
  • Improved memory usage by reading the CSV file line by line
  • Fixed bug where any serialized CSV column content is serialized again
    on import

0.3.2

  • Fixed php notice when importing

0.3.1

  • Don’t process empty columns in the csv file

0.3

  • Fixed bug where password field was overwritten for existing users
  • Use fgetcsv instead of str_getcsv
  • Don’t run insert or update user function when only user ID was
    provided (performance improvement)
  • Internationalization
  • Added display name to example csv file

0.2.2

  • Added role to example file
  • Fixed bug with users not imported when no user meta is set

0.2.1

  • Added missing example file
  • Fixed bug with redirection after csv processing
  • Fixed error logging
  • Fixed typos in documentation
  • Other bug fixes

0.2

  • First public release.
  • Code cleanup.
  • Added readme.txt.

0.1

  • First release.