How to Export Data Using BoldDesk Reports Module
This article explains how to export ticket data from BoldDesk using the Reports module. While the Ticket module limits exports to 1,000 records per action, the Reports module allows you to export up to 5,000 records at once. You’ll learn the steps to export complete ticket data from reports, as well as specific metrics from dashboards, using both Export and Advanced Export options.
Report exports may fail due to timeouts caused by large data volumes, broad date ranges, or high system traffic during the export process. If an export fails, try reducing the date range (for example, to 10-15 days) and run the export again. This helps minimize the amount of data being processed and can improve export success.
Steps to Export Data Using a Report
The following instructions are applicable to the Ticket Metrics Report, Customer Satisfaction Report, and the Work Log Report within the Reports module:
- Navigate to the Reports module.
- Select the report that contains the data you need.
- Click the Export icon. A dialog box appears where you can choose which ticket fields to include in the export file.
- Use the Search bar to quickly find specific fields.
- Select the required ticket fields by checking the boxes (e.g., Ticket ID, Created On). You can also click Select All to include all fields.
- Click Next.
- Choose the desired file format for the export (CSV or Excel).
- Enter the Email Subject, specify CC recipients, select the Time Zone, and decide whether to export time fields in minutes format.
- Click the Export button.
- Once the export is confirmed, an automated email from BoldDesk will be sent to you with a download link.
- Click the provided link to download the file to your local device.
Steps to Export Data for Specific Metrics in a Report
The following steps outline the process to export data for the relevant reports available in the Reports module, including: Support Monitoring Dashboard, Support Traffic Dashboard, SLA Dashboard, Agent or Group Performance Dashboard, Contact Dashboard, Activity Dashboard, Knowledge Base Dashboard, and AI Usage Dashboard.
- Log in to your BoldDesk account.
- Navigate to the Reports module.
- Select the desired report for which you wish to export data.
- Identify the specific metric you want to export (e.g., Unsolved Tickets, On Hold Tickets, Response Overdue, Resolution Overdue, Available Agents).
- Click the Columns button to choose which ticket fields should appear in the export file.
- A Choose Columns dialog box will appear.
- Use the Search Column bar to quickly find fields.
- Select up to 50 fields (e.g., Ticket ID, Subject, Status, Priority, Category, Agent, Group, Requester, Contact Group, Created On).
- Click Apply to confirm your column selection.
- After selecting columns, click the Export dropdown menu. You have two options:
Option A. Export
- If you select Export, the system immediately processes the export using the selected columns.
- The following steps will follow:
- Once the export is confirmed, you will receive an automated email from BoldDesk containing a download link.
- Click the provided link to download the file to your local device.
Option B. Advanced Export
- If you select Advanced Export, follow these steps:
-
Select the desired file format (CSV or Excel).
-
Enter the Email Subject, specify CC recipients, and select the Time Zone.
-
Click the Export button.
-
Once the export is confirmed, you will receive an automated email from BoldDesk containing a download link.
-
Click the provided link to download the file to your local device.
-
How to Import an Exported File into Google Sheets
After you download the exported file (CSV or Excel), you can import it into Google Sheets. Direct export of BoldDesk reports to Google Sheets using Google Apps Script or API access is not supported. BoldDesk report export links are secured using cookie- and session-based Agent Portal authentication, which cannot be accessed by Google Apps Script or other external automation running outside the browser context. As a result, automated downloads or scheduled syncs to Google Sheets are not available. The supported approach is to manually export reports in CSV or XLSX format from the Agent Portal and then upload or import the file into Google Sheets as explained below.
Option 1. Import CSV (recommended for large exports)
- Open Google Sheets.
- Click File → Import.
- Select the Upload tab.
- Upload the exported .csv file.
- Choose how to import:
- Create new spreadsheet (recommended), or
- Insert new sheet(s) (adds the data as a new tab).
- Click Import data.
Option 2. Import Excel
- Open Google Sheets.
- Click File → Import.
- Upload the exported .xlsx file.
- Choose Create new spreadsheet or Insert new sheet(s).
- Click Import data.
- A maximum of 5,000 records can be exported at a time.
- The Ticket Conversation Report and AI Conversation Report currently do not have the option to export data contained within them.
- Only the selected columns will be included in the exported file.
- You can use filters to customize the data to be exported.
- Advanced Export in the export dropdown menu enables users to specify the “export format,” “email subject,” “CC recipients,” and “time zone” prior to exporting the data.
- BoldDesk does not support direct database access, read-only database connections, full database dumps, internal schema exports, or ER/data model diagrams. Direct database access is restricted to protect data security, privacy, and platform integrity.
- To access or move BoldDesk data into an external system, use supported options such as REST APIs, report exports, ticket exports, and webhooks. BoldDesk REST APIs can be used to access supported resources programmatically, while Reports and Ticket exports can be used to export available data in supported formats.
Troubleshooting report exports
Export fails or times out
Symptoms
- Export does not complete
- Export fails during processing
What to do
- Reduce the date range (example: 10–15 days).
- Apply filters to reduce the number of records.
- Retry the export when system traffic is lower.
“Unable to process your request. Please try again”
Common causes described for this scenario
- Missing export permissions
- Hitting export limits (for example, the 5,000 record cap)
- Temporary processing issues
What to do
- Reduce the dataset size using filters/date range.
- Verify required permissions are granted for the data you are exporting (for example, exporting agent-related data may require Manage Agents permission, depending on the export context).
Frequently Asked Questions
-
Why can’t I export more than 1,000 tickets from the Ticket module?
The Ticket module enforces a limit of 1,000 records per export action. Use the Reports module to export up to 5,000 records per export action. -
What is the maximum number of records I can export from the Reports module?
The Reports module supports exporting up to 5,000 records per export action. -
What is the difference between Export and Advanced Export on dashboards?
- Export: Immediately processes the export using the selected columns.
- Advanced Export: Lets you set file format, email subject, CC recipients, and time zone before processing.
-
Which file formats are supported?
BoldDesk exports from the Reports module support CSV and Excel (XLSX). -
Can I choose which ticket fields appear in the export?
Yes. In report exports, select fields in the export dialog. In dashboard metric exports, use Columns (up to 50 fields) and export only those selected fields. -
What happens if I select more than 50 fields in Choose Columns?
You must reduce the selection to 50 fields or fewer before you can proceed. -
How do I receive the exported file?
BoldDesk sends an automated email containing a download link after the export is confirmed and processed. -
Why don’t I see an export option in some reports?
Ticket Conversation Report and AI Conversation Report currently do not support exporting the data contained in those reports.