Microsoft Excel + Microsoft Entra ID

Microsoft Excel + Microsoft Entra ID integrations

Create new Microsoft Entra ID 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 Microsoft Entra ID 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 Microsoft Entra ID.

When this happens...
New RowTriggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create UserCreates a new user.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Microsoft Excel and Microsoft Entra ID

Discover other triggers and actions you can use with Microsoft Excel and Microsoft Entra ID

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write
- Group
  Required
- User
  Required
Action
Write
- Display Name
  Required
- Given Name
- Surname
- Email Nickname
  Required
- User Principal Name
  Required
- Password
  Required
- 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 Name
  Required
Action
Write
- Group
  Required
- User
  Required
Action
Write
- User ID or User Principal Name
  Required
- 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

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write
New User
Triggers when a new user is created.
Trigger
Polling
Try It
- Display Name
  Required
- Description
- Group Type
  Required
- Mail Enabled
  Required
- Email Nickname
  Required
- Security Enabled
  Required
- Is Assignable To Role
Action
Write
- Group
  Required
Action
Write
- User Id or User Principal Name
  Required
Action
Write
- Group ID
  Required
- Display Name
  Required
- Description
- Mail Nickname
- Visibility
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write

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 moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About Microsoft Entra ID

Microsoft Entra ID is a cloud-based identity and access management service that lets employees access Microsoft 365, Azure, and thousands of SaaS apps.

Learn moreLearn moreHelpHelp

Related categories

Microsoft

Premium

Security & Identity Tools

Related Zap Templates

Add new users to an Excel Sheet

Related Zap Templates

Add new users to an Excel Sheet