What are my ticket export options?

Return to top

12 Comments

  • Pedro Reis

    What about exporting tickets via zendesk explorer?

     

    0
  • Dave Dyson
    Zendesk Community Manager

    Hi Pedro -

    You can schedule a Dashboard to be delivered via CSV or Excel format, so if you have a table of tickets, then that will include the columns present in the dashboard reports. This could be a way to get a list of ticket IDs that match a particular set of criteria, but it's not really a full ticket export. Hope that helps!

    Scheduling dashboard deliveries

    -2
  • CJ Johnson

    This article is incorrect. The question states, "including all the ticket details such as comments or email addresses " -- This absolutely is not possible in Explore. You cannot get all comments in Explore. 

    2
  • Dave Dyson
    Zendesk Community Manager

    Good point, CJ, thanks for the heads-up. I'll see if we can adjust the answer there. I don't believe JSON export includes ticket comments either.

    0
  • Tetiana Belevska

    It all depends on how you want to export your tickets with all the details. If you want to export them as backup data, then the options above are just good for you. 

    But, if you want to move them to a new Zendesk account or another help desk solution, it would take a lot of time to export data in CSV, JSON, or XML files. For merging Zendesk accounts or migrating to a new help desk solution, you can try Help Desk Migration.

    0
  • Sarah Owens

    Hello,

    Is it possible to use Zendesk Connector to export tickets that have particular tags, for instance,  exporting into Google Sheets?

    0
  • Dave Dyson
    Zendesk Community Manager
    HI Sarah, I think there are multiple things called "Zendesk Connector" out there -- which one are you referring to?
    0
  • Sarah Owens

    Hi Dave,
    Thank you for your prompt response.
    We are looking at using Zendesk Connector with Google Sheets. We’d like to export specific tags in our Zendesk tickets into a Google Sheets file. We’ve managed so far but the result is not pretty. Can you offer some advice?
    Best,
    Sarah

    1
  • Oliver Cyples

    Hi

     

    Is there any work planned to improve this process with out the use of API or a custom paid app. We have a number of Subject Access Requests that are dealt with by a specific team, they are not comfortable using the API and need to export tickets 1 by 1; which as you can guess is considerably time consuming. It'd be a great to go to be able to select multiple tickets and export all.

    Alternatively can role permissions be added to allow particular individuals to bulk export natively with out needing to be given full admin permissions?

     

    Thanks

    0
  • Silas Johnson

    is there any way to extract the comments using the api? I have tried looking everywhere. For Example, i would like to extract all tickets from a group and make a csv row called comments so I can see the comments for that ticket. Is this possible?

     

    0
  • Roger

    Sarah Owens

    Did you have any progress on exporting the tag data?

    We are facing the same issue in here. We can get a lot of information about the ticket, but we can't get the tags information.. 

    I'm dont understand if this is a exportation type problem or if we need to create and ID_PROBLEM for each tag. 
    Any ADMIN could light us down here? hehe :P  

     

     

    Roger A.

    0
  • Gustavo Oliveira
    Hi Sarah,
     
    If you are talking about this connector Developed by Google, so I will not get in too deep on this one.

    But you could use our API for it instead.
     
    Or, you can create a report based on tags in Explore, and then proceed to export the results. Here some article related to Reporting in Explore with tags: https://support.zendesk.com/hc/en-us/articles/4408838151450-Reporting-with-tags
     

    Hi Oliver,

    Apologies, but I couldn't see anything about it so far.


    Hi Silas,

    You could export the tickets JSON export described in this article.
     

    It's very similar to the information you'd get from the Ticket Comments API.

     

    Since tickets and comments can get quite large, we usually recommend smaller JSON exports. You can use the date range tools to limit the size of each file. You'll also need to use a text editor to adjust the formatting slightly, so the file as a whole can be viewed as JSON. (Each exported ticket has proper JSON formatting, but they aren't grouped together in the file.)

     

    Or you could use a 3rd party App from the Marketplace, like this one. Just a reminder, it is a 3rd party app, so it is out of scope of Support if you need any help.


    Hi Roger,

     
    Let's talk about it over a private ticket. 


     

    0

Please sign in to leave a comment.

Powered by Zendesk