Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Organizational data is employee data that describes the users in your organization - their name, location, and job role. You can import this information into Microsoft 365 and Microsoft Viva through a feature called Organizational Data in Microsoft 365.
Organizational Data in Microsoft 365 is a reliable and scalable online service that:
Enables rapid ingestion of organizational/HR data through connectors from multiple HRIS systems using a single unified ingestion point
Provides organizational data for use across Microsoft 365 Copilot and Microsoft 365 apps to power a variety of features
Delivers a robust data quality framework that detects, communicates, and provides solutions for data quality issues before data is used
Organizational Data in Microsoft 365 supports the ingestion of public, confidential, and custom data through multiple connector options.
Public attributes (such as work email, name, job title, department) – Well-known attributes that are generally allowed to be seen by all users in the tenant. The attributes uploaded by the tenant are usually made available to the Microsoft 365 profile and can be accessed by all of the tenant's users and any Microsoft 365 apps.
Confidential attributes (such as hourly rate and supervisor indicator) – Well-known attributes that contain data that's more sensitive and that you can choose which apps to share this data with.
Custom data (like badge-in count) – Data that has special meaning to the tenant but isn't uniformly known or used across different organizations. You'll get similar controls to those available for Confidential attributes on how to choose which apps can access this data.
This data adds to and updates existing information in Microsoft 365 and Viva apps and services to refresh and extend your data with additional information that currently resides in an external system, like your HR system.
Use the following information to understand, import, and manage your organizational data:
- Understand what organizational data is
- Import your organizational data with a .csv file
- Import your organizational data with Azure Blob Storage Connector
- Import organizational data from SAP SuccessFactors
- Import organizational data from Workday
- Understand how organizational data is retained and managed
- Attribute reference
Note
If you have Microsoft 365 Copilot, check out Use organizational data in the Microsoft Copilot dashboard for important information about configuring and accessing the organizational data.
Organizational Data in Microsoft 365 requirements
There's one required attribute for Organizational Data in Microsoft 365: Microsoft_PersonEmail, which associates the organizational data with a specific person.
Microsoft 365 User Profile
The Microsoft 365 User Profile is a collection of attributes that describe each user, referred to as Microsoft 365 User Profile Data (the data stored in the Microsoft 365 User Profile). This information includes the email address, phone number, job title, and other descriptive information.
Microsoft 365 User Profile Data comes from two main sources: either Microsoft Entra ID (formerly Azure Active Directory), which is the default setting; or from Organizational Data in Microsoft 365, which you upload manually as a .csv file.
Note
Three name-related attributes (Microsoft_FirstName, Microsoft_LastName, and Microsoft_DisplayName) are treated as a group in the Microsoft 365 User Profile, so if any one of them has a value in the input .csv file, the other two also need to have values. Otherwise, the specified value isn't stored in the Microsoft 365 User Profile.
Important
In the Microsoft 365 User Profile, by default, Microsoft Entra data takes precedence over Organizational Data in Microsoft 365. This means that when a service queries a Microsoft 365 User Profile, if there is both organizational data and Microsoft Entra data for a single attribute, the Microsoft Entra value is used.
You can, however, change this setting. Learn how to customize the data precedence for your tenant.
Viva Insights and Microsoft Copilot Dashboard
The Viva Insights web app combines organizational data with Microsoft 365 data to provide detailed, actionable insights into the company's communication and collaboration trends. Learn more.
There are four required attributes:
| Name in Organizational data in Microsoft 365 | Name in Viva Insights |
|---|---|
| Microsoft_PersonEmail | PersonId |
| Microsoft_ManagerEmail | ManagerId |
| Microsoft_Organization | Organization |
| N/A | EffectiveDate |
Learn more about how to prepare organizational data for Viva Insights.
Viva Glint
There are five required attributes:
| Name in Organizational data in Microsoft 365 | Name in Viva Glint |
|---|---|
| Microsoft_PersonEmail | |
| Microsoft_FirstName | First Name |
| Microsoft_LastName | Last Name |
| Microsoft_EmployeeID | Employee ID |
| Microsoft_GlintEmploymentStatus | Status |
To learn how to import organizational data, see Prepare and import your organizational data.
See Attribute reference for more details about the specific attributes, and Attribute to property mapping for information on how the Organizational Data in Microsoft 365 attributes map to Microsoft 365 User Profile data.
Important
If you upload organizational data through the Microsoft 365 admin center, that data is also accessible to and used across Microsoft 365 and Viva apps and services.
Now that you understand what organizational data is and where it comes from, you're ready to import your organizational data into Microsoft 365.