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

Header: mailbox,size_gb[,archive_gb,hold,owner,delegates]. Dot as decimal separator.

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

  1. Prepare a CSV: mailbox,size_gb,archive_gb,hold,owner,delegates (hold: yes/no/unknown). Use Get-EXOMailboxStatistics for sizes and Get-Mailbox | select LitigationHoldEnabled for hold.
  2. 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

InputValue
Mailbox CSV
mailbox,size_gb,archive_gb,hold,owner,delegates
[email protected],18.4,0,no,Ayşe Demir,4
[email protected],47.9,0,no,Mehmet Can,6
[email protected],62.3,0,unknown,,0
[email protected],12.0,35.5,yes,Ali Yılmaz,2

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

Related service: Microsoft 365, Azure, AWS and Google Cloud Services

Systems online tools · See all online tools