XIA Automation Tutorial

Bulk Import Users into Active Directory from CSV

This tutorial describes how to bulk import users into Active Directory from CSV using XIA Automation.

Download Free 30-Day Trial

Learn about the CSV import feature

Tutorial Outcomes

Learn how to use XIA Automation to:

  • Green tick Bulk provision Active Directory user accounts onto a network from a CSV file
  • Green tick Create a new intake year in Active Directory within a school network

1. Create the Automation Profile

In the XIA Automation Administration Tools, create a new automation profile and add the variables and tasks required to create users in Active Directory.

View the create users in Active Directory tutorial to learn how to do this.

2. Create the CSV File

Create a CSV file with headers that match the variables defined in your Active Directory automation profile.

Note: Within a school environment, you can extract the data from SIMS using a simple report that exports directly to CSV.

Screenshot of a CSV file containing users open in Microsoft Excel
Add the users you want to bulk create in Active Directory to a CSV file

3. Import the CSV into XIA Automation Server

Open XIA Automation Server, press the CSV Input button for your Create Active Directory User Account Automation Profile, then upload your CSV file. XIA Automation Server will automatically validate the contents of the CSV file and report any errors.

Screenshot of a CSV file being imported into XIA Automation
Import the CSV file into XIA Automation Server

4. Provision your Active Directory Users

Press Start Profile to provision the users from the CSV file into Active Directory. The file import feature can be used to automate the process of importing CSV files.

Screenshot of the CSV import progress in Automation Status
View the CSV import progress in XIA Automation Server

CSV import can also be used to provision into Microsoft Exchange, Office 365 and Google.

Supported Platforms

CSV import into Active Directory is supported on the following domain versions:

  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2

For more information about CSV import, please view the administrator's guide.

Try XIA Automation for free