Question
How can I export a list of users?
Answer
For all plans:
You can use the Zendesk Rest API Users endpoint along with a custom script.
For Professional and Enterprise customers:
You can export users as an XML or JSON.
For customers with the Customer Lists add-on:
You can create a customer list and export the list as a CSV.
12 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.
Please sign in to leave a comment.