Question
I want to get a list of users we have in Zendesk Support. How can I export a list of users?
Answer
There are three options available for you to export a list of users from your account.
- Use the Zendesk Rest API Users endpoint to capture the list of users from your account.
- For Support Professional and Enterprise plan, export users in XML or JSON format. For more information about exporting data from your Support account, see the article: Exporting data to a JSON, CSV, or XML file (Professional and Enterprise).
- Accounts with customer lists Add-on can export their user list in a CSV file.
25 Comments
Hi Rebecca,
This isn't accurate. Only JSON export is allowed for end user exports. CSV is just for ticket data.
Just as a point of clarification, user data and the full data export are both done in XML format, which is detailed in the article Rebecca linked above.
I was able to find out that only Professional and Enterprise accounts have access to exporting users as XML, but account owner needs to apply for access by writing to support@zendesk.com:
https://support.zendesk.com/hc/en-us/articles/203662346-Exporting-data-to-a-CSV-or-XML-file-Professional-and-Enterprise-
Also read the article on how to use the Customer Lists add-on, however, I'd like to see more information about cost/how to get it.
Thanks!
Hey Gina!
Your account manager (if you have one) can get you pricing information on Customer Lists. If you don't know who your account manager is, or if you don't have one, you can contact Support and they'll be able to help you out!
Thanks!
Hi. We have professional and the customer list is not an option. I was told the following about an add on I needed.
o get customer lists add to your account, you'll have to purchase our customer lists+NPS survey add on. The add-on is a starting cost of $250/month and will be $25/agent/month once you reach 10 support agents or above. Let me know if you'd like to add this to your account, I'll have to send over a service order.
Seems a bit miseading. Am I missing something? Or do I need to pay an extra $250 a month on top of my professional fees for a customer export feature?
Hey Jeff!
As you'll see on our pricing page, the Customer Lists feature is a paid add-on for the Professional plan. So the information you were given is correct.
We're not really able to answer billing questions here in the Community, so if you have additional questions about this our Support team will be able to help you out in your ticket. :)
Hey Jeff -
You can pull that data out of the Zendesk Rest API via the Users endpoint. I'm working on getting some additional information for you, but hopefully that's a start to get you headed in the right direction.
Hi
This is really frustrating.
I have added a new user field and I want to update all of my users with the correct value.
The way to do so without write code (I think it is a reasonable request) is to export the user list, edit the values and import.
Here is where I was pulling hairs from my head:
So Actually, if you don't write code or haven't got the time to write code for a one time action such as user maintenance, you are stuck.
No way to update the users with information which were supposed to be used in triggers and reporting...
Thanks
Yoram
Greetings Yoram,
It should be possible to perform a JSON export of users. The resultant JSON file should be able to be converted into a CSV file (there are a number of services/websites that can do this), after which you could add values to this field in bulk for re-import.
There are a few ways to accomplish this same sort of task using an external system as well (Salesforce + bulk-sync within our integration, or having users auth in via SAML which could push custom-field information over from the identity provider), but the JSON export is likely the easiest way to accomplish what you're looking to do.
Apologies for not having a more graceful way to accomplish this bulk-user updating task. Hopefully this is somewhat helpful!
You don't need to be a programmer or use complicated scripts to export data from your Zendesk (even User List).
Use this tool to export data to CSV easily and quickly.
Hope that will help.
You can fully automate the process of mass data exporting from Zendesk with the help of 3rd-party services like Skyvia. It doesn't require any coding knowledge.
Huge disappointment and huge time waster! After 4 years we're leaving Zendesk because of this.
Reason? Zendesk is keeping our Customer Data Hostage.
We're paying 500$ a year and cannot export our customer data???
We have to use and or pay a third party service to export our data???
We have to upgrade to a higher account to get access to our data???
You are hiding an essential feature behind an account upgrade when exporting customer data should be, not only by law a given.
This hardly is GDPR compliant and most probably Zendesk is in violation of GDPR compliance laws.
Hi Corrado,
I'm sorry that this limitation of automated exports to higher plan-levels is frustrating. We're not trying to keep your customer data hostage, as all accounts should always have access to all of their customer information through the API at no additional cost. As such, you shouldn't need to upgrade or pay a 3rd party for access to that information. What you'd be paying for in either case is the convenience of having the handling of a large volume of data parsed into the filetype of your choosing. This is one of the incentives of our higher plan-levels, but by no means a requirement to access said information.
For more information on our GDPR compliance, please see our general article, or more specifically, the article dealing with Support data (to which User information belongs).
Hello All,
Our Bulk User Export app is now live on the Zendesk app marketplace,which allows you to export user data into various formats like
CSV
Excel
PDF
Copy User Data
https://www.zendesk.com/apps/support/bulk-user-export
Please feel free to try this app.
Regards,
Sushant
Hi Sushant ,
Thanks for that app sharing.
btw, why zendesk does not provide the same functionality from out of the box?
UPD: app is stucked on 16k user export :(
Any other suggestion ?
Cheers,
Gonchik Tsymzhitov
Hey Gonchik Tsymzhitov -
As stated in the article above, Zendesk does allow some functionality around exporting users ootb for pro and enterprise users, and those on lower plans can pull via the API.
As a point of clarification, Sushant is a community moderator but not an employee of Zendesk.
Can you tell us more about why you need to export 16k+ users? We may be able to offer a better suggestion if we have more context around what you're trying to accomplish.
Hi Nicole,
Thanks for answer.
I have exported using the API.
I did for understand the usage of our instance.
Cheers,
Gonchik Tsymzhitov
Glad to hear you got things sorted, Gonchik. Let us know if you have any additional questions!
Gonchik Tsymzhitov Nicole S. the team and I at Playlist are also working on a free Data Loader app, which should hopefully be available on the marketplace by end of year. App will be 100% GDPR compliant and always free :)
Gonchik Tsymzhitov, our service allows exporting data from Zendesk to the CSV file.
Check out this page https://help-desk-migration.com/zendesk-to-csv-migration/
You choose objects for migration: Tickets, Contacts, Organizations, Groups, etc.
Moreover, there is another app GDPR Compliance https://www.zendesk.com/apps/support/gdpr-compliance/ with the functionlaity you need
Please, let me know if I can help you in any other way!
I'm able to get almost all the data I need from our Customer List, EXCEPT for if the User is Suspended or not. Can I tell that from Customer List?
Hello Angie Culp,
There are a couple of ways you can accomplish this.
How can I view a list of my suspended end users without exporting?
suspended
true
orfalse
.To search for suspended users:
To search for users that aren't suspended:
You can find more about this process in the following articles.
Zendesk Support search reference
Searching users, groups, and organizations
Best regards.
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.
Please sign in to leave a comment.