---
title: "Exporting Users"
slug: "exporting-users"
updated: 2024-05-28T21:01:24Z
published: 2024-05-28T21:01:24Z
canonical: "support.smarteru.com/exporting-users"
---

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

# Exporting Users

If you'd like to perform additional analysis on the user data contained in the grid, you can export the grid to a comma-separated file (CSV). The CSV file may be opened and manipulated in Microsoft Excel and saved as an .XLS or .XLSX file.

Any column filters that you've applied to the grid will be ignored by the export.

To export the users to a CSV file:

1. From the Admin menu, select **User Admin**.
2. Select **Users**.
3. View users either [by surname](/v1/docs/viewing-users#viewing-users-by-surname) or [by group](/v1/docs/viewing-users#viewing-users-by-group).
4. From the list located on the right above the grid, select one of the following:

- **Export to CSV** - exports the [columns visible in the grid](/v1/docs/account-grid-columns) with the exception of the Enrollments and Certifications summary data.
- **Export to CSV (full)** - exports [all user columns](/v1/docs/exporting-users#user-columns).
- **Export Licensing** - if [licensing](/v1/docs/licensing) is [enabled for the account](https://support.smarteru.com/docs/account-settings#enable-licensing), exports [all user columns](/v1/docs/exporting-users#user-columns), plus the user's [licensing information](/v1/docs/exporting-users#licensing-columns).
- **Export Licensing (full)** - if [licensing](/v1/docs/licensing) is [enabled for the account](https://support.smarteru.com/docs/account-settings#enable-licensing), exports [all user columns](/v1/docs/exporting-users#user-columns), plus the user's [licensing information](/v1/docs/exporting-users#licensing-columns) and [learning plan columns](/v1/docs/exporting-users#learning-plan-columns).

![Export Options](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/exporting-users-image-y1wj5ucd.png)

The Export Notification window displays.

![Export Notification](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/exporting-users-image-e0bwp5ut.png)

1. In the **Send Email To** field, enter the email addresses of the users who should receive the link to the file.
2. Click **Confirm**.

When the export file is ready to be downloaded, an [email is sent to the specified email addresses](/v1/docs/system-email-templates-report-emails#queued-exports-notification). Refer to [Understanding the Export Files](/v1/docs/understanding-the-export-files) for details on the differences between a summary and full export.

## **User Columns**

- Profile ID
- SCORM Student ID
- Surname
- Given Name
- Employee ID
- Email Address
- Title
- Division
- Home Group
- Teams
- Organization
- Supervisor Name
- Supervisor Email
- Send Physical Mail To
- Address 1
- Address 2
- City
- Region
- Postal/Zip Code
- Country
- Phone (Primary)
- Phone (Alternate)
- Access Level
- Language
- Last Login
- Organization Address Line 1
- Organization Address Line 2
- Organization City
- Organization Region
- Organization Postal Code
- Organization Country
- Send Email To
- Allow Feedback
- Link to User Photo
- Status
- Alternate Email
- Time Zone
- Organization ID
- AUR Created Date - This is the date that the user was added to the account and not necessarily the date that the user was created.
- API Key - This is only included when [API access is enabled for the account](/v1/docs/account-api-setup) and will only be populated if a user's API access has been enabled.
- Authentication Type - This is only included when [external authorization is enabled for the account and the account's Master Control Login is set to *User-Specified*](/v1/docs/account-external-authorization-sso).
- Custom fields - The fields included will vary based on the [custom user fields defined for the account](/v1/docs/account-custom-user-fields).

## **Licensing Columns**

- User Location
- Area/Region
- Agency
- License Type
- License Number
- License Expiry
- Notes

## **Learning Plan Columns**

- Learning Plans

## Related

- [Account: Customize Grid Columns](/account-customize-grid-columns.md)
- [System Email Templates: Report Emails](/system-email-templates-report-emails.md)
- [Understanding the Export Files](/understanding-the-export-files.md)