Azure Active Directory + Microsoft Excel

Create new Azure Active Directory users from new rows in Microsoft Excel

Boost efficiency in managing your organization's user database with this automation. When you add a new row in Microsoft Excel, a new user will be created in Azure Active Directory instantly. This workflow optimizes your user management process and eliminates the need for manual data entry, saving your team valuable time. Showcase your organizational abilities with this seamless integration between Microsoft Excel and Azure Active Directory.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerScheduled
automatically do this!
Create User
Creates a new user.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
New User
Triggers when a new user is created.
Trigger
Scheduled
Try It

- Display NameRequired
- Description
- Group TypeRequired
- Mail EnabledRequired
- Email NicknameRequired
- Security EnabledRequired
- Is Assignable To Role
Action
Write
- GroupRequired
Action
Write
- User Id or User Principal NameRequired
Action
Write
- Group IDRequired
- Display NameRequired
- Description
- Mail Nickname
- Visibility
Action
Write
- Api Docs Info
- Apply standard error handling?Required
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Additional Request Headers
- Body
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- GroupRequired
- UserRequired
Action
Write
- Display NameRequired
- Given Name
- Surname
- Email NicknameRequired
- User Principal NameRequired
- PasswordRequired
- Force Password Change
- Force MFA Password Change
- Job Title
- Department
- Mobile Phone
- Email
- Street Address
- City
- State
- Postal Code (Zip Code)
- Country
Action
Write
- User ID or User Principal NameRequired
Action
Write
- GroupRequired
- UserRequired
Action
Write
- User ID or User Principal NameRequired
- Display Name
- First Name
- Last Name
- User Principal Name
- Job Title
- Department
- Street Address
- City
- State
- Postal Code (Zip Code)
- Country
- Mobile Phone
- Email
- Mail Nickname
Action
Write

About Azure Active Directory

Azure Active Directory Service

Learn more

Related categories

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more