Export your data
Partly availableDownload a full copy of a helpdesk's data as an owner, or CSV files from reports, macros and the logs, and what to do when you need ticket-level rows.
On this page
There are two kinds of export. An owner can download everything in a helpdesk as one file. Several pages also offer a CSV of what they show. Exporting the tickets in a view as a spreadsheet is not available yet; Ticket-level data below has the ways around it.
A full copy of a helpdesk#
Only owners of your organization can ask for or download a full export.
Open the helpdesk menu at the top left and choose All helpdesks, then Organization settings beside your organization's name.
Under Data export, select Export beside the helpdesk.
Wait while it is made. Its status reads Waiting to start, then Being made with counts so far, then Ready with its size and the date it stops being available. A large helpdesk takes longer; you can leave the page and come back.
Select Download.
A helpdesk can have one export in progress at a time. A finished export can be downloaded for seven days, then it expires and you ask for a new one.
What the file holds#
The file is JSON, compressed with gzip, named after the helpdesk and the date. Inside, each part uses the same shape the REST API returns, and a readme section explains each part:
the helpdesk's settings;
users and their away statuses, teams, tags, ticket and customer fields, views and view sections, macros and rules, including archived, private and switched-off ones;
customers, with their contact details and field values;
tickets with all their messages and satisfaction surveys, including trashed and spam tickets;
a list of attachments with their names, sizes and links, but not the files themselves;
help center statistics from the last 400 days.
Left out on purpose: passwords and two-factor secrets, API keys, mailbox and store connections, HTTP integrations with their addresses and secrets, the records of imports, drafted replies, the audit log and the data access log. Deleted tickets and customers erased on request are not in it either.
Attachment links open without signing in, the same as in email. Keep the file somewhere private, and download any attachments you need before the helpdesk is deleted. A deleted helpdesk cannot be exported.
CSV files from other pages#
| Where | What you get | Who |
|---|---|---|
| Every analytics report, Export CSV | The report's figures with your current filters and date range. The satisfaction CSV leaves out customer comments. | Anyone who can see reports |
| Help center report | The articles, the top searches and the searches with no results, each as its own CSV | Anyone who can see reports |
| Workflows > Macros, Export CSV | Every macro with its language, intent, tags, use count and reply text. See Import and export macros | Anyone who can open the macros page |
| Settings > Audit log and Settings > Data access, Export shown entries | The log entries shown with your current filters | Admins |
Filter, compare and export reports covers the report exports in detail.
Ticket-level data#
Exporting a list of tickets with their details, for example from a view, is not available yet. The Export item in the bulk action menu is greyed out. Until it is built:
an owner's full export has every ticket and message;
the REST API returns tickets page by page with
GET /api/tickets, including all the tickets in one view (view_id), if someone on your team can run a script. See The REST API and API keys.
Related articles
- The REST API and API keysFind your API address, create and revoke keys, and connect your own scripts and tools to the helpdesk, including tools written for Gorgias.
- Filter, compare and export reportsPick a date range and a comparison, narrow a report to one channel, tag, agent or team, count business hours only, share the view and download it as CSV.
- Import and export macrosDownload every macro as a CSV file, and bring your macros over from Gorgias or Zendesk with the helpdesk import.
- Customer data and privacyErase a customer's data when they ask, what happens to card numbers and other sensitive details in messages, and how long the helpdesk keeps what.
Still stuck?
Write to the Growth Dept team and a person answers. Say which helpdesk you work in and what you were trying to do.