Entra org export Coming soon
Every person, their manager and who is below them
Coming soon. This tool is built and shows on its menu, but it does not open in a released build yet. This page describes it as it will ship.
The organisation chart as Microsoft Entra holds it: who each person reports to, how many report to them, and how many people are below them in all. Nothing is changed.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- One row per person: job title, department, whether the account is enabled, member or guest, their manager, how many report to them directly and how many are below them in total.
- A tree sheet that reads from the top down, each level indented, with the chain of managers above each person.
- Whose manager could not be found, and where a chain of managers loops back on itself.
How it runs
- Sign in once. Reports › Entra org export. Sign in as yourself; any account that can read the directory's users will do.
- Everyone, if you want them. Also list disabled accounts and guests. Off: enabled member accounts only.
- Run report. The run screen lists each thing it reads as it goes: Microsoft's reports, the directory, and each site. Stop offers Finish, which reads nothing new and builds the report from what was read, or Stop now.
- Read the result. The Done screen gives the headline and anything that could not be read. The workbook goes into History; Save report keeps a copy where you choose. Its About sheet names every source and what came of it.
What do you need?
- An account that can read users in Microsoft Entra. The report makes no SharePoint call.
What will it not do?
- Someone whose manager is not listed (a disabled account or a guest, with the option off) is shown under the nearest listed manager above them, and their row says so.
- Someone recorded as their own manager is treated as having none.
- A loop of managers (A reports to B, B reports to A) is cut at the person first in alphabetical order, whose row says so.
- A manager known only by name is used only when exactly one person has that name; otherwise the row says the manager was not found.
- A read that did not happen is shown as not read, never as an empty result: a site the report could not open keeps its row, with why, and nothing is concluded from it.