Microsoft 365, AD and Windows · #41
Online Microsoft 365 License Calculator
Counts the Microsoft 365 licenses your roles need, compares with current counts and prices the shortfall.
- Data is processed in your browser and not sent to a server
- Export: CSV
Tool
What does this tool do?
In license planning one person may need several add-ons (Teams Phone, Visio, Defender) and some roles need different plans (F3, Business Premium, E3). The tool distributes roles to license types, sums identical types and returns the gap against what you own. It does not invent Microsoft prices; you enter unit prices.
How to use it
- Write one role per line:
Role;headcount;base plan;add-on1,add-on2. - Enter current licenses as
License;count;unit price(price optional, per user per month or per year — be consistent). - Enter the currency and press Calculate.
Fields
- Roles
- One per line: Role;people;plan;add-ons (comma-separated). Headcount is a whole number.
- Current licenses (optional)
- One per line: License;count;unit price (opt.). License names must match the roles.
- Currency
- Display only.
Worked example
| Input | Value |
|---|---|
| Roles | |
| Current licenses (optional) | |
| Currency | USD |
Expected result: Business Premium: 68 needed, 63 owned → 5 short (110 USD); F3: 12 needed, 15 owned → 3 surplus; Teams Phone: 8 short (80 USD); total shortfall cost 190 USD.
Surplus F3 licenses can be reduced at the next renewal; Business Premium has a 300-user limit, so if growth approaches it, assess the cost of moving to E3/E5 separately.
Method and assumptions
For each role line the headcount is added to the base plan and to every add-on; licenses with the same name (case-insensitive) are summed. Shortfall = needed − owned; shortfall cost = shortfall × unit price.
Shortfall rows without a price are excluded from the total and flagged.
Using the result and troubleshooting
Before using the result as an order list, check whether shared mailboxes, meeting rooms and service accounts need licenses (Shared Mailbox Migration Planner).
Limits and common mistakes
- Microsoft license terms (plan contents, user limits, regional prices) are not verified; you name the plans.
- Commitment term, discounts and tax are not calculated.
Frequently asked questions
Where do I get unit prices?
From your own CSP or EA quote. List prices vary by region, currency and term; the tool does not suggest prices.
Related tools and service
- Shared Mailbox Migration PlannerTabulates whether mailboxes need a license after conversion to shared mailboxes and where ownership is missing.
Related service: Microsoft 365, Azure, AWS and Google Cloud Services