Active Directory ProActive Directory Pro
Book a demo Free Trial

Bulk Update Microsoft 365 Group Members from CSV

Add or remove members across many Microsoft 365 groups at once from a CSV file. Works with security, Microsoft 365, distribution and mail-enabled security groups.

How to bulk update group members

  1. Click Tools > Groups, then Bulk update members in the toolbar.

  2. Click Download template.

  3. Fill in the CSV. It has three columns: Group, Action (add or remove) and Member. Put one member per row, then save.

    To add or remove several members from the same group, use one row each or list them in a single Member cell separated by semicolons (not commas). Any other columns are ignored, so a Group Members report export drops straight in once you add an Action column.

  4. Click Choose CSV and select your file.

  5. If your file has no Action column, pick Add or Remove to apply to every member listed.

  6. Review the Preview. Each row shows the Group, Action and Member, and updates to a result as it runs.

  7. Click Apply N changes. Each row shows Added or Removed, or the reason it failed, as it finishes.

    Adding a member who is already in the group, or removing one who is not, counts as a success, so you can safely re-run a file.

Columns

The importer matches columns by their header name and ignores any others.

Column Values & matching Required
Group The target group. Matches on display name, email address, or object ID. Yes
Member The user to add or remove. One per row, or several in one cell separated by semicolons. Matches on display name, user principal name, email address, or object ID. Yes
Action add or remove. Optional if you choose a single action for the whole file after uploading (step 5). Optional