Share via


Use your organizational data in Microsoft 365 and Microsoft Viva

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:

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 Email
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.