Export List of Users & Data | Voters

Export List of Users & Data

Sophia Kaminski

I want to be able to export a list of emails from the project so I can update them all about a change in the project. Also want to export the "last active" information you can see in People settings.

October 5, 2018

Ian Daubney

This is a requirement for security minded admins...

Such a case is to: periodically review to pick up on users who have left the company but who still may be able to access the site.

Cristina Conde Tkatchenko

I'm looking for a function to block my Calendar based on form submissions.

Daniel Urbano

How I see it:

There should be an export option in admin settings that allows you to export as needed, meaning: Having filters to decide which data and users I would like to export. Most of the time it will be the whole workspace, but sometimes you just want one or two spaces, folders, or lists.

Also, the data that should be in that report needs to include the following:

User ID
Location to which it has access to
Permissions to those locations
Email
Role Name (Include custom roles and not only regular ones)
Status (Active or Pending/Invitation Sent)
Domain (What ones after the @ in the user email)
Date invited to Workspace for first time (Date format)
Date accessed Workspace first time (Date format)
Teams

At least those are important for an Enterprise Workspace.

Include some other filters for exporting, like:

Last [time] changes (last month, this month, range, etc.)
Only [role name] (Member, Admin, guests, etc.)
Only from [Domain] (mycompany.com, guestscompany.com, etc.)
Only from [Location] (Space XYZ, Folders ABC and CDE, List OPQ, etc.)
Invited by [user] or [user role] (Me, Team, Admins, Members, etc.)

Feel free to add different and new ideas...

Nick Day

I really need this to meet audit requirements of my company, as well. I need to be able to list all the users, their level of access (Member, Guest, Admin), and their email address.
I'd been manually doing a horrible cut-n-paste process, taking the text from the "Manage People" screen and pasting it into my own parser to get a list of users and emails. That just broke as my number of Guests has grown. Now when I select and copy all the Guests in the table, my clipboard only gets the rows that are visible on screen plus a few more. I don't actually get the full table.
I'd like _any_ easy way to export the list of users: export to CSV, Excel, access via API, anything.
I have a reddit post about this here: https://www.reddit.com/r/clickup/comments/192kr01/how_to_get_a_list_of_all_members_and_guests_in_a/
EDIT: u/dgreger on reddit gave a solution based on an undocumented endpoint in the API that does this reliably, at least for now.
GET {base_url}/team/{workspace_id}
In the response, look for the “members” array.

Riki Ishikawa

I really want this feature! We need this for an audit.

Tamlyn Koga

Merged in a post:

Export users in workspace

Anu Bulusu

Provide an option to export a list of active, inactive and pending users (admins, members and guests) in workspace to excel from the admin panel / workspace settings.

December 29, 2023

Randy Ventura

Hi, I am in need of this feature as well. Thank you!

Peter Hue

In order to fulfill the audit requirement, there is a requirement to export the list of users with access authority. I think at least a report to print access matrix and user listing are required..

Tatiane Cristina Ferreira dos Santos

I urgently need this feature to be able to manage access

Michelle Campbell

This is an absolute must for us. This is an audit requirement for my company.

→