Microsoft Excel + Microsoft Entra ID

Microsoft Excel + Microsoft Entra ID integrations

Add new users to an Excel Sheet

We often use Excel Sheets to manage employee onboarding. Whenever a new user is registered in Microsoft Entra ID, they're automatically added to an Excel list, ensuring you're always aligned with onboarding steps.

When this happens...
New UserTriggers when a new user is created.
TriggerPolling
automatically do this!
Add Row to TableAdds a new row to the end of a specific table.
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 Entra ID and Microsoft Excel

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

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

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

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

Create new Microsoft Entra ID users from new rows in Microsoft Excel

Related Zap Templates

Create new Microsoft Entra ID users from new rows in Microsoft Excel