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 my 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.

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

August 11, 2021
It met my need immediately. Thank you for creating and maintaining this plugin.
January 21, 2019
Update 1.0.1 works great, definitely recommend this plugin. Thanks
February 19, 2017
Hello, Just I want to say thanks very much for your plugin. it helps me to develop my custom plugin to import a custum database. BIG thanks :))
September 3, 2016
It does what it says, easy to use if used to databases. I did use it in an intallation with lots of user meta and it's behaving really nice. Also the Exporter add on it's working nicely. Thanks a lot!
September 3, 2016
It works like a charm and makes life much easier. Thanks!
Read all 39 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 3 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.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.