Import people properties from a file

Who can do this

Admin, in the browser only.

If your organization’s directory is in Microsoft Entra ID or Google Workspace, you can give people their people properties from its user export: one CSV file, one row per person.

Export your users

Microsoft Entra

1. In the Microsoft Entra admin center, go to Entra ID → Users → All users and click Download users.
2. Click Start, then the link to download the CSV file once it is ready.

If you use the newer Download users (Preview) button instead, the file has the columns the All users list shows, so show the ones you want, such as job title and department, before you download. Its column names can differ from the classic download’s.

Google Workspace

1. In the Google Admin console, go to Directory → Users and click Download users.
2. Under Select columns, choose All user info columns and currently selected columns. With only the currently selected columns, job title and department may be missing.
3. Under Select format, choose Comma-separated values (.csv), click Download, and save the file when it is ready.

If you edit the file in Excel

Save it as CSV UTF-8 (Comma delimited). Ronja can read a file saved another way, but it then says “This file isn’t UTF-8; read it as Windows (Western) text. Check the names below look right.” Check the names in the preview before you apply.

Import the file

1. On People properties, click Import from file, then Choose CSV file. A file can be up to 1 MB and 1,000 people. Ronja reads it in your browser and sends only the columns you match.

2. Identify each person. Under Identifies the person, choose the column with each person’s email address. Under Otherwise, try (optional), you can choose a second column for rows where the first is blank or matches no one. From the classic Entra download, Ronja picks mail and then userPrincipalName for you, since Entra can leave mail blank, for example for an account with no mailbox. From any other file, check both choices and pick the columns yourself if they are empty or wrong.

3. Match columns to properties. Each column is listed with an example value from the file. Under its What “…” becomes, such as What “jobTitle” becomes, choose:

   • Skip, to leave it out (the default).
   • An existing property.
   • New property, which creates one named after the column (you can change the New property name). A new property has One value per person. If a property with that name already exists, the column sets that property instead.

   A property can be set from one column only. A column matched to a Several values property splits each cell on ;.

4. Click Preview. Nothing has changed yet. The preview shows what changes, including who moves from which value, and what is left out and why. If the import would pass a limit, it says This import can’t be applied and names the limit.

5. Click Apply. If anything changed since the preview, for example someone edited a property or a person left, nothing is imported. Click Preview again to see the change as it is now.

An import only sets and adds

• An empty cell leaves that person’s value as it is, and people missing from the file are left alone. An import never clears a value.
• On a Several values property, an import only adds. Someone who no longer covers a site keeps it until you remove it.
• An import never creates or invites people. Rows for people who aren’t members yet are listed and left out: import the file again after they join.