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

[Sean Martin]

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?

[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:

1. Go to Exports → Scheduled exports
2. Select your saved filter
3. Choose CSV or Excel format
4. 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:

1. Create an automation rule
   • Trigger: Scheduled (e.g. every Monday 09:00)
   • Action: “Lookup Issues” using your JQL filter
2. 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! 🚀

[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:

1. Create a scheduled Jira automation rule (weekly) that runs your filter using Lookup issues.

2. Add a Send web request action to call your own webhook (e.g. via Zapier, Make, or a lightweight script).

3. 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! 

[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