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

One per line: Role;people;plan;add-ons (comma-separated). Headcount is a whole number.

One per line: License;count;unit price (opt.). License names must match the roles.

Display only.

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

  1. Write one role per line: Role;headcount;base plan;add-on1,add-on2.
  2. Enter current licenses as License;count;unit price (price optional, per user per month or per year — be consistent).
  3. 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

InputValue
Roles
Ofis çalışanı;60;Microsoft 365 Business Premium
Yönetici;8;Microsoft 365 Business Premium;Microsoft Teams Phone
Üretim (paylaşımlı PC);12;Microsoft 365 F3
Current licenses (optional)
Microsoft 365 Business Premium;63;22
Microsoft 365 F3;15;8
Microsoft Teams Phone;0;10
CurrencyUSD

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

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

Systems online tools · See all online tools