Skip to main content

How to Bulk Import Users into AutoRFP

Import multiple users from Excel or CSV files

Saul Bard avatar
Written by Saul Bard
Updated today

Article Summary

Bulk import users to AutoRFP using an Excel or CSV file with required columns (firstname, lastname, email, role, jobtitle, team). The system automatically creates users, assigns roles, and sends invitations to all users in the file.


Estimated Time

~ 5-7 minutes depending on team size


Prerequisites

  • Administrator permissions

  • User data organized in Excel or CSV format

  • AutoRFP import template

  • Understanding of role types and team structure


Step-by-Step Instructions

Step 1: Download the Import Template

  1. Navigate to your Organizational Settings > Users.

  2. Select Bulk Import Users

  3. Download the file in the popup modal (the file template can also be found at the bottom of this article)


Step 2: Prepare Your Import File

Add user data with the following required columns:

Required Columns (case-sensitive):

  • firstname: User's first name

  • lastname: User's last name

  • email: User's email address

  • role: Must be admin, contentmanager, or user (default is user)

  • jobtitle: Job title to display in user's profile

  • team: Team name or department

📝 Important Note

  • Column headers are case-sensitive—use exact labels as shown

  • For Excel files with multiple sheets, rename the import sheet to "Users" or ensure it's the first sheet

  • Columns not in the template will be ignored during import

  • All fields should be completed for each user


Step 3: Fill in User Data

  1. Open the template file.

  2. Add one row per user.

  3. Complete all columns for each user.

  4. Verify email addresses are correct.

  5. Ensure role values are spelled exactly: admin, contentmanager, or user.

  6. Save the file.


Step 4: Import the File

  1. Navigate to Organizational Settings > Users.

  2. Click Add User.

  3. Select Import Users.

  4. Click Add File and select your prepared import file.

  5. Click Import.


Step 5: Verify Import Results

  1. System processes the file and creates user accounts.

  2. Review the user list to confirm all users were imported.

  3. Check that roles and teams were assigned correctly.

  4. Users appear with "Invite Sent" status.


Step 6: Monitor User Activation

  1. Imported users receive email invitations immediately.

  2. User status changes from "Invite Sent" to "Active" after they accept invitation and log in.

  3. Monitor activation progress in the Users list.


💡 Tips & Best Practices

  • Use the official AutoRFP template to avoid formatting errors

  • Verify all email addresses before importing - typos prevent invitations

  • Use lowercase for role values: admin, contentmanager, user


✋🏼 Common Mistakes to Avoid

  • Modifying column headers. AutoRFP won't recognize columns with different names

  • Using incorrect role values (e.g., "administrator" instead of "admin") - causes import errors

  • Missing required fields for users - incomplete rows fail to import


Need Help?

💬 Live Chat: Available in-app

📧 Email: [email protected] or contact your Success Manager directly for urgent support.

📚 Learning Centre: learn.autorfp.ai/en


File Template ⬇️

Did this answer your question?