nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I email the results of a filter as a CSV attachment?

Sean Martin_ag7m8n

I want to send a list of the open tickets to a specific email address each week. I have a filter that gets me the list.

I can export the results of the filter as a CSV file, but that doesn't get emailed.

I can create a subscription that emails the results of the filter, but the list is put in the body of the email as a table (html, I assume).

How do I automatically email results of the filter as a CSV file attached to the email each week?

Accepted answers

Ali Umut Terzi

Hi @Sean Martin 👋

That’s a great question — and it’s a very common one!

Unfortunately, Jira’s native filter subscriptions can only send the results as an HTML table in the email body, not as a CSV file attachment.

But there are a few practical workarounds depending on how automated you want the process to be 👇

Option 1) Marketplace app (easiest & reliable way)

You can use apps like:

Better Excel Exporter for Jira (Midori)
Email This Issue for Jira

These apps can schedule reports and send your filter results as a CSV or Excel file attachment automatically.

Example setup in Better Excel Exporter:

Go to Exports → Scheduled exports
Select your saved filter
Choose CSV or Excel format
Add recipients → Done ✅

Every week, your team receives the report as a CSV attachment via email.

Option 2) Automation for Jira + external mail service (semi-custom)

If you prefer to stay fully native:

Create an automation rule
- Trigger: Scheduled (e.g. every Monday 09:00)
- Action: “Lookup Issues” using your JQL filter
Send Email → use {{lookupIssues}} to include results as an HTML table

However, Jira Automation currently can’t attach files —
if you really need CSV attachments, you can extend it with a webhook to tools like Zapier, Make (Integromat) or Google Apps Script, which can turn the lookup data into a CSV and send it as an email attachment.

Option 3) Custom Script (for technical users)

Using the Jira REST API, you can:

Run your JQL query (/rest/api/3/search)
Convert the JSON results into CSV (Python, Node.js, etc.)
Send it via SMTP as an attachment

This gives full control, but it’s best suited if you already have some scripting setup.

But to be honest, If you dont have to export as CSV, a customizable mail will cover the situation I guess.

For example: (sorry for its in my native language 😊)

Hope that helps clarify the options! 🚀

Birkan Yildiz _OBSS_

Hey @Sean Martin

That's a great question, and you've correctly identified a frustrating limitation in Jira's native filter subscriptions. While you can get the results in the body of an email, there's no built-in way to get them as a CSV attachment automatically.

For this kind of automated report delivery, a Marketplace app is usually the most direct solution.

Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira, and our Scheduled Reports feature is designed to solve this exact problem.

You can use your existing JQL filter to create a report in Timepiece and then schedule it to be automatically delivered on a weekly, daily, or monthly basis. The report is sent as a secure download link via email, Slack, or MS Teams, allowing you to get your data in CSV or Excel format. That is giving you the exact functionality you're looking for.

Screenshot 2025-07-10 113202.png
Besides, there are over 15 report types and many other features you can enjoy.

You can check Timepiece on the Atlassian Marketplace. Hope this helps you get your weekly reports automated.

All comments

Prachi Bolar

Hello Sean,

Welcome to the community

Presently, there is no option to customise this while setting up the subscription. The predefined format is the table that we receive in email

https://jira.atlassian.com/browse/JRACLOUD-96401 - Feature request for the same.

Thank You,

Prachi

Kinga_Getint

Hey @Sean Martin Jira Cloud doesn’t currently support emailing a filter as a CSV attachment, filter subscriptions only send an HTML table in the email body. Here’s what you can do instead:

Option A – Use a Marketplace app (fastest, no-code)
Several reporting/export apps can schedule emails with file attachments. For example:

Better Excel Exporter for Jira Cloud – lets you email a saved filter on a schedule as an Excel file (often fine instead of CSV).
Better PDF Exporter – if you’re okay with PDF output.
Other “automated export” or “scheduler” apps on the Marketplace that explicitly mention CSV attachments.

These tools typically let you pick a filter, set a weekly schedule, specify recipients, and send the report automatically.

Option B – Automation + external service (no app, some setup)
If you must have CSV and prefer not to use an app:

Create a scheduled Jira automation rule (weekly) that runs your filter using Lookup issues.
Add a Send web request action to call your own webhook (e.g. via Zapier, Make, or a lightweight script).
The webhook uses Jira’s REST API (/rest/api/3/search) to fetch results, convert to CSV, and email the file through your mail service.

It takes a bit of setup, but it’s reliable and gives you full control.

Hope one of these options will fit!

Ali Umut Terzi

Hi @Sean Martin 👋

That’s a great question — and it’s a very common one!

Unfortunately, Jira’s native filter subscriptions can only send the results as an HTML table in the email body, not as a CSV file attachment.

But there are a few practical workarounds depending on how automated you want the process to be 👇

Option 1) Marketplace app (easiest & reliable way)

You can use apps like:

Better Excel Exporter for Jira (Midori)
Email This Issue for Jira

These apps can schedule reports and send your filter results as a CSV or Excel file attachment automatically.

Example setup in Better Excel Exporter:

Go to Exports → Scheduled exports
Select your saved filter
Choose CSV or Excel format
Add recipients → Done ✅

Every week, your team receives the report as a CSV attachment via email.

Option 2) Automation for Jira + external mail service (semi-custom)

If you prefer to stay fully native:

Create an automation rule
- Trigger: Scheduled (e.g. every Monday 09:00)
- Action: “Lookup Issues” using your JQL filter
Send Email → use {{lookupIssues}} to include results as an HTML table

Option 3) Custom Script (for technical users)

Using the Jira REST API, you can:

Run your JQL query (/rest/api/3/search)
Convert the JSON results into CSV (Python, Node.js, etc.)
Send it via SMTP as an attachment

Hope that helps clarify the options! 🚀

Aron Gombas _Midori_

Let me note that the mentioned Better Excel Exporter app integrates with a free companion app Better Excel Automation.

And, this second app offers the email automation capabilities with Excel spreadsheets.

Birkan Yildiz _OBSS_

Hey @Sean Martin

For this kind of automated report delivery, a Marketplace app is usually the most direct solution.

Full disclosure, I'm on the team that makes Timepiece - Time in Status for Jira, and our Scheduled Reports feature is designed to solve this exact problem.

Screenshot 2025-07-10 113202.png
Besides, there are over 15 report types and many other features you can enjoy.

You can check Timepiece on the Atlassian Marketplace. Hope this helps you get your weekly reports automated.

Robin Kon

I had a similar setup for a weekly Jira report. I used Skyvia to pull the Jira data I needed and export it as a CSV to Google Drive on a schedule. From there I had a small automation pick up the latest file and send it as an email attachment. Jira handled the source data, Skyvia handled the recurring export, and the email was a separate step.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud