# 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

1. Log in to your Suptask account.
2. In Account Settings, navigate to [**Reports**](https://app.suptask.com/account/reports).
3. Activate the **Enable report delivery** checkbox 
4. Select the email delivery day and time
   * Be aware that the timezone is UTC.
5. Enter the **email addresses of the recipients** who will all receive the report email.
6. Done! 

{% hint style="info" %}
The email contains a download link which is valid for 7 days.
{% endhint %}

***

### 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.

1. **Open the CSV in Excel** (or paste its contents into a worksheet).
2. Select the column containing the combined data.
3. Go to the **Data** tab in the Excel ribbon.
4. Click **Text to Columns**.
5. In the wizard:
   * Choose **Delimited** and click **Next**.
   * Select the delimiter used in your file (usually **Comma**).\
     \&#xNAN;*(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**).
6. 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.

1. **Download the CSV file** from its source.
2. **Open a blank Excel workbook** (do not open the CSV directly).
3. Go to the **Data** tab.
4. Click **Get Data** → **From File** → **From Text/CSV**.
5. Navigate to the downloaded file and select it.
6. 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.
7. 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.

{% content-ref url="../../integrations-automations-and-workflows/integration-guides/api" %}
[api](https://support.suptask.com/integrations-automations-and-workflows/integration-guides/api)
{% endcontent-ref %}