How to Export Jira to Excel Using Power Automate

Managing tasks in Jira is great for tracking agile work, but when it comes to reporting or sharing project insights with stakeholders, Excel remains the tool of choice for many. Automating the export of Jira issues to Excel can save you time and ensure data accuracy.

In this post, I’ll walk you through how to automate Jira to Excel exports using Power Automate—ideal for weekly status reports, sprint summaries, or backlog analysis.

---

✅ Prerequisites

Before we start, make sure you have:

• A Jira Cloud account with API access.
• Microsoft Excel (OneDrive or SharePoint-based file).
• Access to Power Automate.
• Jira API Token (for authentication).

---

🔄 Step-by-Step: Exporting Jira to Excel with Power Automate

🔹 Step 1: Create an Excel File with a Table

1. Open Excel (OneDrive or SharePoint-based file).
2. Create a worksheet with columns such as:
   • ID
   • Summary
   • Status
   • Assignee
   • Created Date
3. Format it as a Table and name it (e.g., JiraIssues).
4. Save it to OneDrive or SharePoint.

🔍 Power Automate only works with Excel Tables hosted on OneDrive or SharePoint.

---

🔹 Step 2: Generate Jira API Token

1. Go to https://id.atlassian.com/manage-profile/security/api-tokens.
2. Create a new token and copy it.
3. You’ll use this in your HTTP headers in Power Automate.

---

🔹 Step 3: Build Your Power Automate Flow

1. Go to Power Automate.
2. Click Create > Scheduled cloud flow (e.g., daily/weekly export).
3. Add a new HTTP action.

🔸 Configure HTTP Action:

• Method: GET
• URI: bashCopyEdithttps://your-domain.atlassian.net/rest/api/3/search?jql=project=ABC&maxResults=100 Replace ABC with your project key.
• Headers: pgsqlCopyEditAuthorization: Basic <base64encoded(email:api_token)> Content-Type: application/json

📌 Use https://www.base64encode.org/ to encode your email:api_token.

---

🔹 Step 4: Parse JSON Response

1. Add Parse JSON action.
2. In Content, pass the body from the HTTP action.
3. Use a sample JSON response from Jira to auto-generate the schema.

---

🔹 Step 5: Loop Through Issues and Add Rows to Excel

1. Add an Apply to each action.
2. Inside the loop, add Add a row into a table (Excel Online).
3. Map Jira fields to Excel columns:

Excel Column	Value from Jira JSON
ID	item.key
Summary	item.fields.summary
Status	item.fields.status.name
Assignee	item.fields.assignee.displayName
Created Date	item.fields.created

---

🧪 Optional: Clear Table Before Writing

If you’re running this flow periodically and want to overwrite the previous data:

• Add Delete rows (via Office Scripts or using a helper script in Excel).

---

🧾 Use Cases

• Sprint closure reports.
• Weekly team dashboards.
• QA bug tracking snapshots.
• Stakeholder briefings with Excel exports.

---

💡 Tips

• You can add filters to your JQL for date ranges, assignees, or custom fields.
• Extend the flow to send an email with the Excel file attached.
• For large datasets, paginate the API results using startAt and loop logic.