Export a list of your site's users

You can download a CSV of all the users on your site: everyone who has signed in to it with their Koordinates ID. The CSV from the Users tab always contains the full user list. It doesn’t follow the group, search or filters you’ve chosen.

To export only one group’s members, select the group in the groups panel, then select Export users as CSV on the group’s page. That CSV lists only the group’s users.

Note: Exporting a list of users is available on Team Cloud Plan, Business Cloud Plan, Enterprise plans.

1. Open Users & Groups

Open the Manage menu in the top navigation and select Users & Groups. You can also select the Users & Groups tab in the Data Manager.

2. Select ‘Export users as CSV’

On the Users tab, select Export users as CSV.

3. Confirm and select ‘Generate CSV’

Tick the box to confirm that you’re generating the CSV in line with the Koordinates Terms of Use and Privacy Policy, then select Generate CSV.

Koordinates emails the CSV to your email address.

Understanding the fields in your CSV

The CSV has these columns for each user. The column name is shown in brackets.

Name (first_name and last_name):
The user’s first and last names, as entered when they signed up.

Seat type (seat_type):
paid for users with a Paid Seat on your site and ai for users with a KxAI Seat. Empty otherwise.

Blocked users (is_suspended):
True for users who have been blocked from your site.

Country (country):
The two-letter code for the country the user chose when they signed up for their Koordinates ID.

Site administrators (is_site_admin):
True for your site’s administrators.

Email address (email):
The email address the user signed up with.

Date joined (date_joined_site):
The date and time the user joined your site.

Last active (last_seen):
For all activity after 18 July 2018, the date and time the user was last active on your site. If a user hasn’t been active on your site since 18 July 2018, this is the date and time they last signed in.

Mailing list status (mailing_list_subscriber):
True for users who have opted in to receiving emails from your site.

User security (is_email_verified, is_3rd_party_auth and is_mfa_enabled):
True for users who have verified their email address, who sign in with third-party authentication, or who have multi-factor authentication turned on. For more, see Understanding user security.

Groups (groups):
The groups the user belongs to, separated by ;.

Group administrator (admin_of_groups):
The groups the user administers, separated by ;.

If you’re a group administrator but not a site administrator, these columns list only your groups.