Import users into Drupal, or update existing users, with data from a CSV file (comma separated file). Provides a wide range of features out of the box, and a comprehensive API to customise imports.

Features

Create and Update Accounts

Create an account for each user
Update existing users option (data can be added or replaced)

Support For Many Fields

Match CSV columns to account fields
Roles can be set for users (set for all users, or imported per user with option to create new roles)
Can import passwords from CSV file (plain text only)

Account Info Options

Can create Usernames based on data from the file
e.g. "John" + "Smith" => "JohnSmith"
Usernames can be made of abbreviated data from the file
e.g. "John" + "Smith" => "JSmith"
Can create random, human readable, Usernames
Can create random passwords for each new account
Can set each user's contact form to enabled
Can set each user's account to active
Option to generate email addresses

Upload Options

Upload CSV files through browser
Use file uploaded through SFTP, FTP,...
Drop an import file into a directory to trigger an automatic import

Welcome Email

Can send custom welcome email with account details to each new user
Welcome email can include profile data

Scalable

Processing can be triggered by cron or manually by an administrator
Can stagger number of users imported, so that not too many emails are sent at one time
Designed to be infinitely scalable

Convenient

Drush support
Import settings can be saved for re-use on future imports
Test mode option to check import for basic errors

Add-On Modules

Add additional features with these modules that make use of the User Import API:

User Import Delete (D7)
Options to cancel existing accounts not in an import
Phone Field
Import user fields containing phone numbers

Drupal 7

Core User entity fields supported, except File and Image type fields.

User Import 7.x-2.1

Note that from version 7.x-2.1 'Private files system path' must be set, as all imported CSV files are moved to the private files directory for processing. If updating from a previous version please also run Drupal update.

Sponsorship

Moore Answers
WebWise Solutions
Specsavers
...have a feature you'd like to sponsor? Get in touch

Support

If you've found User Import module particularly useful and want to say thank you, there's a wide range of stuff I'd welcome on my wish list (UK) (US).

Development

Developed by Robert Castelo for Code Positive.

RTBC issues for User Import

Filters