Import Users

This article will show you how to import users into your site from an existing user spreadsheet.

File Format Rules

For Sites On CivicPlus Organizations

The file must be a text file with a file name extension .TXT or .CSV

Format Rules

• Fields must be comma-delimited
• Each record should be placed on a separate line
• All fields must be present, even if empty
• Only the Groups field may be empty
• Blank lines will be ignored
• Duplicate entries will be ignored
• Groups should be in one field and delimited by a pipe ( | )

Fields, in order:

1. First Name
2. Last Name
3. Email Address - Limited to 255 characters
4. Groups (all groups that users should be added to)

For Sites Off CivicPlus Organizations

The file must be a text file with a file name extension .TXT or .CSV

User Type

• Standard: Default user type used by the CivicPlus Content Management System (CMS) application
• Lightweight Directory Access Protocol (LDAP): User type when integrated with an LDAP system

Format Rules

• Fields must be comma-delimited
• Each record should be placed on a separate line
• All fields must be present, even if empty
• Only the Groups field may be empty
• Blank lines will be ignored
• Duplicate entries will be ignored
• Groups should be in one field and delimited by a pipe ( | )

Fields, in order:

1. First Name
2. Last Name
3. Username
4. Password should be at least 5 characters long
5. Email Address (limited to 255 characters)
6. Groups (user should be added to)

Instructions

1. Sign in to your site
2. Navigate to Modules and on the Site Tools tab, select User Administration
   
   
3. Select Import Users
   
   
4. Select Choose File and select the file on your computer
   
   
   Note: View a template at the bottom of this article.
5. Select Import File
   
   
6. View Successful Import prompt
   

Resources