English (US)
  1. Zendesk help
  2. Support
  3. Advice and troubleshooting
  4. Users, groups, and organizations

How do I export a list of users?

Zendesk Team
  • Edited

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. 

  1. Use the Zendesk Rest API Users endpoint to capture the list of users from your account.
  2. 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.
  3. Accounts with the customer lists can export their user list in a CSV file.
  4. There might be a third party alternative that works for your use case in the Zendesk Marketplace.
Return to top

5 Comments

  • Jiri Kanicky

    Export users into CSV

    Export users into JSON in Zendesk -> Admin -> Reports

    Adjust JSON file to make it validated array:

    • add "," add the end of each line, but the last one
    • add "[" at the beginning of the file
    • add "]" at the end of the file

    JSON to CSV:

    I use VS Code with Python and Panda. Here is the simplest code you can use to transform JSON to CSV.

    import pandas as pd

    # read JSON file

    df = pd.read_json('./zd_user_all.json', orient='records')

    # create CSV file

    df.to_csv('zd_user.csv', index = None, header=True)

     

     

    0
  • Jonathan Morland

    Hello - for Option 3

    1. Accounts with the customer lists can export their user list in a CSV file.

    Could you detail the steps for this please?

    Thank you

    0
  • Josh
    Zendesk Customer Care
    Hi Jonathan!
     
    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
  • Tetiana Belevska

    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.

    0
  • 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?

    0

Please sign in to leave a comment.

Related articles

Powered by Zendesk