Exporting JIRA status via Trello

[Claudia Oddie]

Hi

I'm trying to export (excel or csv) my board so it shows the status of the JIRA task attached.  I've created a field for JIRA URL (cut and paste of JIRA URL) and I attach the same URL to the card which then shows me the JIRA task again PLUS the real time status.

Ideally I'd like to see a report with a header that shows the status.  The standard report has a column "attachment links" but this is just a count.

I have not created a JIRA column as each JIRA task is linked to its own card.

Thanks

Claudia

[Sunny Ape]

Hello @Claudia Oddie 

That's a great question!

Ok, so just to confirm, you’ve got a Trello board where each card links to a Jira issue (via a URL), and you’d like to export a report (Excel or CSV) that includes the live Jira status for each card, not just the attachment count.

Unfortunately, Trello doesn’t natively export that data (since it doesn’t actually fetch metadata from JIRA links), but you have a few realistic options depending on how automated and accurate you need it to be. Here are three options:

✅ 1. Use a Trello export and a script that fetches Jira status (semi-automated via code)

If you’re comfortable running a small script (Python or Google Sheets), you can:

1. Export your Trello board to CSV (via “Print and Export → Export as CSV” or a Power-Up).
2. The CSV will contain your custom field with the Jira URLs.
3. Use a script to:
   • Extract the JIRA issue key from the URL (PROJ-123).
   • Query the JIRA REST API for each issue (/rest/api/3/issue/PROJ-123?fields=status).
   • Write the status back to the CSV.

✅ 2. Use Google Sheets and Jira API integration (no code)

If your Trello export goes into Google Sheets:

• You can use Google Apps Script or the Jira Cloud for Sheets add-on.
• It lets you pull live JIRA data into Sheets and use VLOOKUP to join with Trello export.

Steps:

1. Export Trello board → Import to Sheets.
2. Use the Jira Cloud for Sheets add-on → pull in columns for issue key & status.
3. Use a formula like =VLOOKUP(A2, JIRA!A:B, 2, FALSE) to match by issue key and display live status.

✅ 3. Use a reporting tool (easiest for business users)

Several Trello add-ons can combine Trello and JIRA data automatically:

• Blue Cat Reports
• Screenful
• Placker
• Unito (syncs Trello ↔ JIRA bidirectionally)

These reporting tools can show live Jira status in Trello dashboards or exports with minimal setup.

[Andrew Edwards]

That's really great information @Sunny Ape !

[Jason U]

Hi Claudia,

That’s a great question — and what you’re describing touches on one of the current limitations of the Trello–Jira integration.

Here’s the situation in short:

• Trello can show a live Jira status only inside the card view (via the attached Jira URL or Smart Link).
• However, this information isn’t exposed to board-level exports (Excel/CSV) — meaning the Jira “status” field can’t be included in Trello reports.

So right now, there isn’t a native way to export Jira issue statuses directly into a Trello CSV report.

✅ Possible Workarounds:

1. Use the Jira Power-Up (Premium) – It adds a real-time Jira status badge on the card, but this still doesn’t sync into the export.
2. Use the Atlassian REST APIs – You can export both Trello cards and Jira issue data separately, then join them using the JIRA_URL key in Excel or Power BI for reporting.
3. Try a connector app – Tools like Unito or Zapier can sync Jira fields (e.g., Status, Assignee, etc.) to Trello custom fields — once in a custom field, you can export them.

📘 Docs:

• Jira Power-Up for Trello
• Unito – Jira ↔ Trello sync
• Trello API reference

[Claudia Oddie]

Many thanks, much appreciated

Claudia