---
title: "Reports: Exporting Output"
slug: "reports-exporting-output"
updated: 2022-04-21T16:07:26Z
published: 2022-04-21T16:07:26Z
canonical: "support.smarteru.com/reports-exporting-output"
---

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

# Reports: Exporting Output

## **Exporting Report Columns to a File**

You can export the output of the [Enrollment Report](/v1/docs/enrollment-report) and [Learning Plan Report](/v1/docs/learning-plan-report) to a comma-delimited file (CSV) or Excel spreadsheet (XLS).

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

To export the report's output:

1. Run the [Enrollment Report](/v1/docs/enrollment-report) or [Learning Plan Report](/v1/docs/learning-plan-report).
2. Click **Export**.
3. Select one of the following:

- **Export to CSV** - exports the columns included in the Enrollment Report or Learning Plan Report to a comma-delimited file (CSV).
- **Export to CSV (full)** - exports [all report columns](/v1/docs/reports-exporting-output#columns-included-with-full-export) to a comma-delimited file (CSV).
- **Export to XLS** - exports the report output to an [Excel spreadsheet (XLS)](/v1/docs/reports-exporting-output#xls-export-file). If the report's output option includes a grid, the columns included in the Enrollment Report or Learning Plan Report are exported.
- **Export to XLS (full)** - exports the report output and [all report columns](/v1/docs/reports-exporting-output#columns-included-with-full-export) to an [Excel spreadsheet (XLS)](/v1/docs/reports-exporting-output#xls-export-file).

The Export Notification window displays.

![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/reports---exporting-output-image-5zoqqmzg.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. The contents of your export file will depend on the export file type (CSV or [XLS](/v1/docs/reports-exporting-output#xls-export-file)).

Refer to [Understanding the Export Files](/v1/docs/understanding-the-export-files) for details on the differences between a summary and full export.

## **Columns Included with Full Export**

The following columns are included in the full export:

- Surname
- Given Name
- Employee ID
- Email Address
- Alternate Email
- Language
- Access Level
- Title
- Division
- Supervisor Surname
- Supervisor Given Name
- Supervisor Email
- Supervisor Status
- Last Login
- Learner Status
- Send Physical Mail To
- Address Line 1
- Address Line 2
- City
- Region
- Postal Code
- Country
- Timezone
- Primary Phone
- Alternate Phone
- Allow Feedback
- Custom fields
- Organization
- Organization Status
- Organization Address Line 1
- Organization Address Line 2
- Organization City
- Organization Region
- Organization Postal Code
- Organization Country
- Send Email To
- Home Group
- Learning Plans
- Teams
- Points
- Enrollment Tag
- Group
- Group Status
- Group Tag
- Course
- Course Status
- Course Tag
- Enrolled
- Started
- Due
- Grace Period
- Session Status
- Session
- Last Accessed
- Progress %
- Completed
- Location
- Skill Profile
- SKU Name
- SKU
- Progress Status
- Duration (seconds)
- Grade
- Pass/Fail
- Subscription
- Subscription Start Date
- Subscription End Date

## **XLS Export File**

The sheets included in the XLS file will depend on the output options for your [Enrollment Report](/v1/docs/custom-enrollment-report-output-options) or [Learning Plan Report](/v1/docs/custom-learning-plan-report-output-options).

At the top of each sheet in the .XLS file are your [account's logo](/v1/docs/account-customization#logo), the [account name](/v1/docs/account-general-information#name), "Enrollment Report" or "Learning Plan Report", and the date and time the report was exported.

![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/Export%20XLS%20Header%2020220127.png)

If your report's output includes a [chart](/v1/docs/charts), the .XLS file includes a Summary sheet. The chart's title and any filters that were applied display above the chart. The chart in the .XLS is a screen capture of the report's chart. Below the chart are the data series and values used for the chart.

![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/Export%20XLS%20Summary%2020220127.png)

The contents of the Details sheet will depend on the export option you selected. The **Export to XLS** option includes the columns selected for the [Enrollment Report](/v1/docs/custom-enrollment-report-columns) or [Learning Plan Report](/v1/docs/custom-learning-plan-report-columns), while the **Export to XLS (full)** export option, includes [all report columns](/v1/docs/reports-exporting-output#columns-included-with-full-export).

![](https://cdn.document360.io/7efaadab-fef6-4186-806a-2ca14c9ce9ea/Images/Documentation/Export%20XLS%20Details%2020220127.png)

## Related

- [Adding a Custom Enrollment Report](/adding-a-custom-enrollment-report.md)
- [Adding a Custom Learning Plan Report](/adding-a-custom-learning-plan-report.md)
- [Custom Enrollment Report: Columns](/custom-enrollment-report-columns.md)
- [Custom Enrollment Report: Output Options](/custom-enrollment-report-output-options.md)
- [Custom Learning Plan Report: Columns](/custom-learning-plan-report-columns.md)
- [Custom Learning Plan Report: Output Options](/custom-learning-plan-report-output-options.md)
- [Enrollment Report](/enrollment-report.md)
- [Learning Plan Report](/learning-plan-report.md)
- [System Email Templates: Report Emails](/system-email-templates-report-emails.md)
- [Understanding the Export Files](/understanding-the-export-files.md)