Reports
Learn more how to set up recurring reports
Overview
Recurring reports contains statistics and data about all your tickets within Suptask. It enables you to continuously retrieve data on tickets to perform your own calculations and visualizations.
As the reports are delivered in a raw format using Comma Separated Values (CSV), it is very easy for anyone to feed this data into a spreadsheet application like Excel, or to a separate Business Intelligence (BI) reporting tool.
Reports are delivered via email and can be sent to multiple recipients.
Here is how to set up reports
Log in to your Suptask account.
In Account Settings, navigate to Reports.
Activate the Enable report delivery checkbox
Select the email delivery day and time
Be aware that the timezone is UTC.
Enter the email addresses of the recipients who will all receive the report email.
Done!
Troubleshooting
If you are not receiving your reports, they are very likely being blocked by a email protection service (such as the built in spam filter). Here is what you can do in on your email account to help receive the emails:
Make sure to check your junk and spam folder in your email client.
Mark the email from Suptask as not being spam or junk.
Whitelist the email domain suptask.com to avoid emails being blocked.
How to Open and Interpret a CSV File in Microsoft Excel
When you open a CSV file in Excel, sometimes the data does not display correctly, for example, special characters might appear garbled, or the content might all appear in one column. This often happens because Excel guesses the file’s encoding or delimiter incorrectly.
Below are two recommended methods to correctly interpret a CSV file in Microsoft Excel.
Alternative 1: Using Excel's Text-to-Columns Feature
This method works if you have already opened the CSV in Excel and see all data in a single column.
Open the CSV in Excel (or paste its contents into a worksheet).
Select the column containing the combined data.
Go to the Data tab in the Excel ribbon.
Click Text to Columns.
In the wizard:
Choose Delimited and click Next.
Select the delimiter used in your file (usually Comma). (You can also check “Tab” or “Semicolon” if your file uses those instead.)
Click Next, then choose the correct Column Data Format (often General or Text).
Click Finish. Your data should now be split into columns correctly.
Alternative 2: Using Power Query (Recommended for UTF-8 Files)
This method is ideal when:
The CSV contains special characters (like accented letters or symbols)
You want to load the data into a structured Excel table, ready for filtering and pivoting.
Download the CSV file from its source.
Open a blank Excel workbook (do not open the CSV directly).
Go to the Data tab.
Click Get Data → From File → From Text/CSV.
Navigate to the downloaded file and select it.
In the Preview window:
Ensure File Origin is set to 65001: Unicode (UTF-8).
Verify the data preview shows the correct characters and column separation.
Click Load. The data will be imported into a formatted Excel table, perfect for filtering, sorting, and creating pivot tables.
Learn more
Ticket data can also be exported via the API, to empower automatic integration export.
Suptask APILast updated
Was this helpful?