GROUP / MEMBERSHIP REVIEW

Review group membership

Open a membership export. Check it for duplicate or missing members, or compare it with an older export to see who was added or removed.

01 / OPEN FILE

Open the current membership export

Choose the CSV or TSV you want to check.

CURRENT EXPORTChoose the current membership CSV or TSVUp to 25 MB · processed locally

Choose file

Compare with an earlier exportTurn this on to see members that were added or removed.

Choose the current membership export. It stays in this browser.

No export yet? Create an AD group export or create an Entra group export.

02 / COLUMNS

Choose the member column

Pick the column that contains the user or member. That is enough when this file is for one group.

Member columnUPN, email, account name or object ID all work.

More matching optionsOnly needed for multi-group exports or special matching

Group columnChoose a group column only when one file contains several groups.

Ignore uppercase/lowercase differencesRecommended for UPNs, email addresses and account names.

Opselith checks the current membership export. It looks for missing and duplicate memberships.

03 / REVIEW

Review the membership

Your review will appear here.

Rows0

Memberships0

Fix first0

Check0

Rows to review

Start with Fix first. Other member types are shown as Check items.

Source	Row	Member	Group	What to check
Run the membership review to see results.

CONTINUE IN OPSELITHKeep working with this membership export

Create a fresh AD group export →

Your source exports are not changed.

Back to Command Center

About membership review

What files work best?

Use a CSV or TSV where each row is one group membership. Opselith can work with exports from Active Directory, Microsoft Entra and similar admin systems as long as there is a column that identifies the member.

For one group, choose only the member column.
For exports with several groups, also choose the group column so the same person can safely appear in different groups.
When comparing two exports, both files need matching column names for the member and optional group columns.

What counts as a problem?

A missing member value or the same membership appearing twice needs fixing before Opselith can safely compare two exports. Groups, service principals or other non-user members are shown as check items rather than treated as errors.