Question
How can I export our tickets (including all the ticket details: comments, email addresses, etc.) from Zendesk Support?
Answer
There are two options to perform a full data ticket export from your Zendesk Support account:
-
If you are an administrator of your account on the Plus/Professional or Enterprise plans, you can do a full XML export by going to Admin (
) > Manage > Reports > Full XML export. You will then receive an email providing a link to download your report. For more information, see Exporting data to a CSV or XML file.Important: Data export must be enabled by Zendesk for your account. If you are on Professional or Enterprise and want to enable this option, your account owner can email support@zendesk.com. -
A second option if you are on our Regular/Team or Starter/Essential Plans, would be to export your data via our API.
For more information on exporting data via the API, see our documentation below:
Comments
18 comments
Hi Lucia, we do Zendesk services for a large number of Zendesk clients. Many clients do not have "Reports" under the manage section even though they are on Professional or Enterprise plans. Can you advise how to do this under these circumstances? Thanks!
Hey Brendan!
Just a quick point of clarification here: do mean that your users aren't seeing the Reporting option when they go to their admin settings? It should look like this:
I just want to make sure that we're talking about the same thing!
Hi Jesse,
I am having the same problem. I am on professional and I do not see the 'Reports' option under 'Manage' like your screenshot above. Any advice?
@ryan I emailed support@zendesk.com and they were able to enable the option for me. It is not turned on by default, though there's no documentation on that or any reason it isn't.
Hi Brendan,
Thanks for helping out! I added a note to option #1 to say that the option must be enabled by Zendesk for your account. We have that note in our product docs, but it was missing from this article.
Thanks!
Hi All,
I wanted to share some work that our team has done that is related to exporting tickets.
We recently created a free Zendesk Support app to easily capture ticket data in Google Sheets. It automatically creates rows for new tickets and keeps them in sync when there are updates made to the ticket.
It'd be great to get feedback if this is helpful and what would make it more useful. You can install it here: https://www.zendesk.com/apps/support/google-sheets-by-azuqua/
Best,
Phill
Hi everyone,
I see there is an option to export a .csv file for recent tickets. Does this work if we want to export tickets from a specific organization? Currently we are on the Team plan.
Thank you,
Cristina
Thanks for sharing your solution, @Phil!
@Cristina - unfortunately there's no way to export by organization. Your best bet is to sort by org following the export.
Also, I see that this is your first post - Welcome to the Zendesk Community! I encourage you to head over to the Welcome Thread in The Lounge to introduce yourself.
We look forward to seeing you around the Community. Happy Zendesking!
@Cristina -
One of my colleagues mentioned to me that you could potentially use the Advanced Search App instead of a view, and would then be able to export the results from that. This would allow you to search for tickets by organization and then export from there. I'd suggest giving that a try - seems like it could work out great for you.
Hi Nicole!
Thank you so much for this solution. I've tried it and works perfectly for us.
Hey Cristina! You're welcome. So glad to hear that solved it for you!
Hi,
Lucia's original question was regarding "all the ticket details" including comments.
Seems the option to export comments, however, is not yet available?
Hey Nicole -
Lucia is the author of the tip - she's a support agent from Zendesk. I know this formatting is confusing; I've talked to the team about the design.
You can export ticket comments via the API or via that export tool if you're on Professional or Enterprise.
Is there anyway to select a date range for the CSV export? I can see that option is available for JSON
Hi!
Onna integrates with Zendesk and lets users collect and export the following:
Historical information and related metadata, including:
Exports can be in csv, txt, or dat files.
Here's a guide with more details: https://intercom.help/onna/integrations/web-integrations/how-to-collect-from-zendesk
Hi Darren!
The CSV can be filtered externally, eg via Excel. We don't offer the filter for the CSV format. You may also export in JSON and convert it to csv, through one of the tools available online, like the one below
https://json-csv.com/
Thanks for your suggestion Diogo.
Unfortunately that site only allows a max 1mb file unless we upgrade to a pro version. I tried a days worth of tickets and it exceeds the 1mb limit.
Hey All,
The easiest way to import to Zendesk is to use Help Desk Migration service.
You can easily manage:
Please sign in to leave a comment.