Question
I want to get a list of users we have in Zendesk Support. How can I download my user information to share outside of my account?
Answer
The following options are available for you to export a list of users from your account:
Data export
Customer list add-on
API
Use basic data export
For Professional plans and above, accounts come with basic data export functionality. Any account admin or custom role agents with export permissions can export a list of users in an XML or JSON format. This option will export all user data, but once the file is downloaded, you can manually filter it with software like Excel or Google Sheets.
Use an add-on
Accounts that have purchased the customer lists add-on can export their user list in a CSV file. This gives you the flexibility to target specific groups of users and to decide which information is included in an export.
Use the API
The Zendesk Rest API Users endpoint is also available in all Zendesk accounts but is a more technical solution. It gives you a lot of flexibility and control but usually requires the assistance of someone with basic knowledge of coding to implement effectively. However, if you have developer resources on your team this would be a good option.
14 comments
Jiri Kanicky
Export users into CSV
Export users into JSON in Zendesk -> Admin -> Reports
Adjust JSON file to make it validated array:
JSON to CSV:
I use VS Code with Python and Panda. Here is the simplest code you can use to transform JSON to CSV.
1
Jonathan Morland
Hello - for Option 3
Could you detail the steps for this please?
Thank you
1
Josh
Thank you for messaging us. Customer list is a legacy add-on which is currently available for Suite plans. However, the steps in performing this is available here.
0
T B
As for option 4, you can find export and import apps on the Zendesk marketplace if you want to export your list of users in CSV.
Or there is an automated data migration app, called Help Desk Migration. They have their app on the Zendesk marketplace.
1
Clive Carmock
Seriously there is no download to CSV in Zendesk? We have to mess with add ons, or JSON files and convert? I see you have bulk import options. The cynic in me would say exporting users (key activity in truing up user counts) is made hard to make it harder for admins to ensure licences are recovered.
Is an export to CSV on the roadmap? if so when is it due? if not - why not?
8
Sarah H.
Exactly. I have no idea why I have to be some sort of programmer just to export a list of emails for my customers who have booked tickets. Its honestly ridiculous.
7
Scott
Sarah H. Agreed. Ideally, you should just be able to run a report and export. I usually recommend our clients to export from their reporting tool (Looker, Tableau, PowerBI, etc.) if they have access to one. That's probably the easiest and most robust workaround.
0
Andrea Rochira
It seems possible to export users in a CSV file; when requested, it is sent to your email address:
However, it doesn't seem to include all the users... in my case it's listing only 492 users out of 46633...
0
Giuseppe
Hi Andrea,
CSV export is only applicable to tickets. Tested this out just now and I can confirm that only tickets are exported. Although, if you open the CSV file in a spreadsheet app, it could look like you are exporting a "Users" report because it lists ticket details including the ticket requesters. If you double-check the headers, it should look something like this:
The 'Id' in this case refers to the ticket ID.
More information about CSV Export:
Reference: Understanding the data export options
0
Tom Wix
Seriously - there is no way to get a report of customers (end users and their attributes) or organizations (customers and their attributes like external id, tags, etc) ?
There must be in Explore or worst case - a simple CSV dump ?
1
Dane
You can use the Full XML export option for users.
0
Roman Sheydvasser
Agent CSV export script:
https://support.zendesk.com/hc/en-us/community/posts/4409217556506/comments/5071076068890
0
Zak Khalid
Really need to re-evaluate Zendesk as a product, If I can't do a simple tasks as export users.
9
Derek Pinkston
I used the following python script with my API credentials to export all end-users:
1