Microsoft 365, AD and Windows · #42
Online Shared Mailbox Migration Planner
Tabulates whether mailboxes need a license after conversion to shared mailboxes and where ownership is missing.
- Data is processed in your browser and not sent to a server
- Export: CSV
Tool
What does this tool do?
Converting leavers' or department mailboxes to shared mailboxes saves licenses, but Microsoft documents conditions: mailboxes over 50 GB, with an archive or on litigation hold need a license (Exchange Online Plan 2 or Plan 1 + Exchange Online Archiving). If the hold state is unknown, no decision is possible; the tool marks that as 'verification needed'.
How to use it
- Prepare a CSV:
mailbox,size_gb,archive_gb,hold,owner,delegates(hold: yes/no/unknown). UseGet-EXOMailboxStatisticsfor sizes andGet-Mailbox | select LitigationHoldEnabledfor hold. - Paste it and press Calculate; download the plan as CSV.
Fields
- Mailbox CSV
- Header: mailbox,size_gb[,archive_gb,hold,owner,delegates]. Dot as decimal separator.
Worked example
| Input | Value |
|---|---|
| Mailbox CSV | |
Expected result: muhasebe: no license; satis: 47.9 GB, near the limit; eski.calisan: 62.3 GB → license needed, hold unknown, no owner; hukuk: archive and hold → license needed.
An unlicensed shared mailbox stops receiving mail at 50 GB. For eski.calisan assign an owner, verify the hold state and either archive and delete old content or keep a Plan 2 license.
Method and assumptions
License needed: size_gb > 50 or archive_gb > 0 or hold = yes. If hold is unknown and no other condition applies, the result is 'verification needed'. 45–50 GB is also flagged as 'near the limit'.
The rules are based on Microsoft Learn 'About shared mailboxes' and 'Remove a license from a shared mailbox'; check the current documentation before applying, as it may change.
Using the result and troubleshooting
Shared mailboxes without an owner cause audit findings; give every mailbox a responsible owner and at least one delegate.
After conversion, verify size below 50 GB and no hold/archive before removing the license.
Limits and common mistakes
- It does not connect to the tenant; it evaluates the CSV values.
- In-place holds and Microsoft Purview retention policies are not evaluated separately; reflect them in the hold column.
Frequently asked questions
Can someone sign in to a shared mailbox as a user?
It is not recommended; Microsoft advises blocking direct sign-in to the shared mailbox account. Grant access through delegates.
Related tools and service
- Microsoft 365 License CalculatorCounts the Microsoft 365 licenses your roles need, compares with current counts and prices the shortfall.
- UPN and SMTP Address Change PlannerBuilds the proxyAddresses value for users' new UPN and primary address, keeps the old address as an alias and shows conflicts.
Related service: Microsoft 365, Azure, AWS and Google Cloud Services