---
title: "Identifying Supervisors"
slug: "identifying-supervisors"
tags: ["supervisors"]
updated: 2022-06-21T15:14:24Z
published: 2022-06-21T15:14:24Z
canonical: "support.smarteru.com/identifying-supervisors"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.smarteru.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Identifying Supervisors

To identify [supervisors](/v1/docs/adding-and-removing-supervisors) in your account:

1. From the Users Dashboard, [export all user columns to a CSV file](/v1/docs/exporting-users).

The remaining steps will need to be completed from Excel.

1. From Excel, [sort the data](https://support.office.com/en-us/article/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654) by Supervisor Name. Be sure the My Data Has Headers checkbox is checked.
2. [Remove the duplicate](https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2) Supervisor Name values. Again, sure the My Data Has Headers checkbox is checked. From the Remove Duplicates window you will need to click Unselect All, check the Supervisor Name checkbox, then click OK.

![Graphical user interface, application Description automatically generated](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/identifying-supervisors-image-p5zy9ib6.png)

If any of your users have multiple supervisors, the supervisor names display in a single cell and are delimited with a semi-colon.

![Application, table Description automatically generated](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/IdentifyingMultipleSupervisors%2020220621.png)

If you need the supervisor names to display in individual cells, you can use [Excel's Text to Columns](https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30B14928-5550-41F5-97CA-7A3E9C363ED7) functionality.

The Text to Columns functionality will replace the data in the cells to the right of the Supervisor Name column. To avoid overwriting existing data in those columns either ensure the Supervisor Name is the last column in the spreadsheet, or insert extra blank columns.

![Graphical user interface, application, table, Excel Description automatically generated](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/IdentifyingSupervisorsTextToColumns%2020220621.png)

## Related

- [Adding a User Manually](/adding-a-user-manually.md)
- [Adding and Removing Supervisors](/adding-and-removing-supervisors.md)
- [Exporting Users](/exporting-users.md)
- [User: Profile Information](/user-profile-information.md)
- [Users Dashboard](/users-dashboard.md)