Black Friday Offer: 10% off with promo code BF2022    Learn more

How to export tickets from Desk365

Exporting tickets from your helpdesk can be a valuable way to analyze and manage customer support data.

It is also helpful for creating reports, tracking ticket volume data, sharing information with other team members, and identifying areas for further improvement in your support team operations.

When you export tickets from a helpdesk, you are essentially creating a copy of your ticket data in a different format, such as a CSV file or an Excel spreadsheet that can be easily accessed, analyzed, and manipulated in a variety of ways.

In this blog post, we will discuss the steps involved in exporting tickets from Desk365 and some best practices for doing so.

Here are the general steps you need to follow:

1. Log in to your helpdesk account and navigate to the ticket list view.

2. Click on the ‘Export’ button at the top in the Agent Portal.

export button in the agent portal

3. Select the time period for which you want to export the tickets and choose the necessary ticket fields and contact fields that you would require.

You’ll receive the exported file in your email inbox that will be in the .CSV format.

Several types of exports options are available in Desk365 such as:

* All Tickets
* Time Entries
* Current Ticket View
* Custom View
* Search Tickets

Let’s cover all these different export options in detail below.

You can export all the tickets that are coming into your helpdesk.

Here are the steps you need to follow to exports all your tickets in Desk365:

1. In the Tickets tab, choose ‘All Tickets’ from the Views list on the left.

2. Click on the ‘Export’ button at the top in the Agent Portal.

export all tickets in the agent portal in Desk365
3. ‘Export – All Tickets’ dialog box appears. Here you can filter the export by choosing one of the following time period options: ‘Created Time’, ‘Resolved Time’, and ‘Closed Time’.
filter the export by choosing one of the following options

Created Time: Tickets that were created during the time-frame specified will be exported.

Resolved Time: Tickets that are currently in ‘resolved’ status and resolved during the time-frame specified will be exported.

Closed Time: Tickets that are currently in ‘closed’ status  and closed during the time-frame specified will be exported.

4. Choose the required ticket fields, contact fields, and even the custom ticket fields that you would like to export.

choose the required ticket fields you want to get exported
5. Click on the ‘Export’ button at the bottom to begin the export process. Once the export is completed, you’ll receive the exported file in your email inbox that will be in .CSV format. You can also export time entries to a ticket which we’ll be discussing next.

Export - Time Entries

Tracking time spent on tickets is critical for any helpdesk. It is especially useful when you bill clients for time spent on tickets.

Desk365 makes it easy to log time spent on tickets and to report on them. You can enter the exact time spent on a ticket or use a timer to keep track of it.

You can export tickets which have time entries recorded on it and download useful information such as ticket number, time spent on a ticket, billable information, and more.

Here are the steps you need to follow to export time entries in Desk365:

1. Click on the ‘Export’ button at the top in the Agent Portal.

export button in the agent portal

2. Choose the ‘Export Time Entries’ Tab in the ‘Export – All Tickets’ dialog box.

export time entries in Desk365

3. Select the time period for which you want to export the tickets and choose the required ‘Time Entry’ fields that you would like to collect in the report.

4. Click on the ‘Export’ button. Once the export is completed, you’ll receive the exported file in your email inbox that will be in the .CSV format.

Here is a sample screenshot of how it appears in an Excel sheet.

time entries data

Export Tickets - Current Ticket View

You can export your current view in your helpdesk. Let’s say you’re taking a look at your ‘Open’ and ‘Pending’ Tickets and you want to export just that information in an excel sheet.

Here are the steps you need to follow to export your current ticket view in Desk365:

1. Go to ‘My Open and Pending’ view and click the ‘Export’ button at the top in the Agent Portal.

open and pending tickets view

2. ‘Export – My Open and Pending’ dialog box appears. Choose the time period and the required ticket fields, custom fields, and contact fields that you want to export.

exporting my open and pending tickets

Tickets from the ‘My Open and Pending’ ticket view will be exported in CSV format and you’ll notice only 6 tickets which are your ‘Open’ and ‘Pending’ tickets appear in the CSV file.

Exports Tickets - Custom View

You can export tickets for any Custom Views as well. This is pretty useful as you don’t want to export all the tickets every time and carry out some manual tasks in excel to get the custom view you’re looking for.

You can export tickets belonging to a Custom View and get them in an .CSV format.

1. Choose the ‘Custom View’ that you want to export and click on the ‘Export’ button at the top. For this example, let’s say you wanted to download only the urgent tickets from a particular company called ‘ATX’.

atx urgent custom view

2. ‘Export – ATX Urgent’ dialog box appears. Choose the time period and the required ticket fields, custom fields, and contact fields that you want to export.

exporting atx urgent tickets

3. Click on the ‘Export’ button. Tickets from the ‘ATX Urgent’ ticket view will be exported in .CSV format and you’ll receive it via email.

Similarly, you can also export time entries for a Custom View if needed.

Export Tickets - Search Tickets

One more way to export tickets is using the ‘Search’ function.

You can search for a ticket by ‘Subject’, ‘Description’, and ‘Ticket Number’ and download the tickets related to them.

For this example, I want to export the tickets that are related to ‘Printers’.

printer related tickets

2. ‘Export – Search Tickets’ dialog box appears. Choose the time period and the required ticket fields, custom fields, and contact fields that you want to export.

export printer related tickets

3. Select the ‘Export’ button and you’ll receive the ‘Printer’ related tickets that are in ‘Resolved’ status in a .CSV file.

Please note that the following filters alone are not applicable while exporting:

– Status (If Created Time is chosen during export, filters will be applied. However, if Resolved Time or Closed Time is chosen, then only tickets in Resolved or Closed status will be exported)
– Created (Will be based on the Created Time chosen during export)
– Due By
– First Response

Exporting all of your tickets may be tempting, but it can be overwhelming and might not be useful if you are looking for a particular information.

You can make use of the filters to narrow down your ticket list based on different ticket fields, such as contact name, customer email, groups, channels, and more.

Using these filters can help you find the ideal tickets you want to export.

This can help you identify opportunities to strengthen your customer service, such as by addressing common customer issues or offering additional resources and support.

Hope you find the ‘Export’ feature option useful for your business.

How Tos

Articles on specific tasks

Updates & News

Release notes and product updates

Getting Started

Setup guides that help you get started.

By using this website, you agree to our use of cookies. We use cookies to provide you with a great experience and to help our website run effectively.