Download user data and metadata to CSV
The download includes all your user settings and information including custom user data in comma-separated value (CSV) format. This download contains most of the data available from a user's profile.
Use a spreadsheet to view and filter all users based on criteria you create in the spreadsheet.
Availability: all customers
Note: this downloadable CSV is different from the downloadable CSV about users, available from Users > Batch Upload. The two CSVs aren't interchangeable.
The two CSVs contain different data, and the batch upload CSV is designed to make batch uploads easy. See Batch user upload: overview and options explained for background about the batch upload feature.
Set filters to download a subset of user data
Within the Users page, you can set filters to select a subset of users, and then export that subset to a CSV. For example you can select:
- usertype learner only
- users created after a specific date, aka most recent users
- by membership type
- by group
The following screenshot shows the filter available on Users. In this example the filter selects data for learners with enabled accounts, who belong to the Communications group.
Access permissions to export user data
- All admins: can export all users and all their data in a portal
- Managers: can export data for all the users they manage in groups
The rule of thumb: if the manager can view the user's profile, then the manager has permissions to download the user's data.
If users belong to additional groups outside the manager's remit, the data related to those groups is not included in the manager's download.
The exported data for managers lists the date that users were created or invited, but doesn't include who created or invited them.
Export user data
- From main navigation, go to Users.
- Optional: set filters to select a subset of users in the portal.
- From the Actions menu, select Export to Excel.
- From the dialog that appears, select the link to download the file.
The following screenshot shows the option for admins, in Actions.
See:
- Add users to your portal
- Upload users by batch CSV file
- Custom user data: set up custom fields
- Dynamic rules: use custom user data or email domain to assign users to groups