How to Get Data from Jira to Excel Automatically

If your weekly routine involves manually exporting data from Jira and wrangling it into Excel spreadsheets, you're spending valuable time on a task that can be completely automated. Creating progress reports, analyzing team velocity, or tracking issues shouldn't require an endless cycle of clicking "Export" and reformatting CSV files. This tutorial guides you through several methods for automatically syncing your Jira data to Excel, so your reports are always up-to-date and you can get back to more important work.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Automate the Jira to Excel Connection?

Before jumping into the "how," it helps to understand the "why." Manually exporting data is more than just a minor annoyance, it introduces several real problems:

• It's a Time Sink: The process is tedious. Logging in, applying filters, exporting the CSV, opening it in Excel, cleaning the data, applying formatting, and updating charts - doing this daily or weekly adds up to hours you'll never get back.
• Data Becomes Stale Immediately: The moment you export your CSV, the data is frozen in time. Any issues updated or created in Jira moments later are completely missing from your report. Decisions are made based on outdated information.
• Human Error is Unavoidable: Did you apply the correct filter this time? Did you copy and paste the values correctly? Every manual step is an opportunity for a mistake that can skew your entire analysis, leading to incorrect conclusions and poor project decisions.
• Reporting is Reactive, Not Proactive: When reporting is a chore, you do it as infrequently as possible. This means you’re always looking backward. An automated, live connection lets you spot trends and address potential issues as they happen, not a week later.

Method 1: Using Excel’s Built-in Power Query

For most users, the most powerful and cost-effective way to get live Jira data into Excel is by using Power Query (often called "Get & Transform Data" in modern versions of Excel). It lets you connect directly to Jira's API, pull exactly the data you need, and refresh it with a single click.

It sounds technical, but it’s surprisingly straightforward. Here’s how you do it.

Step 1: Get Your Jira API Token

For Excel to access Jira, you need to provide credentials. Instead of using your password, it's best practice to create an API token specifically for this purpose.

1. Log into your Atlassian account online (not just your Jira instance).
2. Go to Your Profile > Account Settings.
3. Click on the Security tab.
4. Find the API Token section and click Create and manage API tokens.
5. Click Create API token, give it a recognizable name (e.g., "Excel_Report_Token"), and copy the token. Important: Save this token somewhere safe immediately, as you won't be able to see it again.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Connect Excel to Jira

Now, let's pull the data into Excel. This example assumes you want to get all issues from a specific project.

1. Open a new Excel workbook.
2. Go to the Data tab on the Ribbon.
3. Click Get Data > From Other Sources > From Web.
4. A dialog box will appear. Select the Advanced option.
5. In the "URL parts" section, enter your Jira search query URL. It will look something like this: https://<your-domain>.atlassian.net/rest/api/3/search?jql=project="YOUR_PROJECT_KEY" (Replace "your-domain" with your company's Jira domain and "YOUR_PROJECT_KEY" with your project's key, like "PROJ" or "MKT".)
6. Under "HTTP request header parameters," you need to add two headers:
7. For the Encoded Token: You need to encode your email and API token together. You can use an online "Base64 Encoder" for this. In the text box of the encoder, type your Jira login email and API token separated by a colon, like this: your.email@company.com:YourAPITokenGoesHere. Copy the encoded result. It will look like a long string of random characters, for example: wqurLmV4Yc32zQGdtYWlsLmNvbTpBVEFUVDNYcEFselpiOGZaWEVIdEFwYW....
8. Paste that encoded string after Basic in the Authorization field. Your full entry should look like: Basic wqurLmV4Yc32zQGdtYWlsLmNvbTpBVEFUVDNYcF...
9. Click OK. Power Query will connect to Jira and pull your data.

If you get stuck creating your own complex query URL, just navigate to the filter you want in Jira's "Issues" view and pay attention to the JQL in the search bar. This tells you exactly what to add after the = in your URL.

Step 3: Transform and Clean the Data

The Power Query Editor will now open, showing you the raw data from Jira. It will likely look a little messy because Jira's API sends data in a nested format. This is where Power Query shines.

• Expand Nested Columns: You'll see several columns with "Record" or "List" as their value. To see the useful data inside, click the small expand icon (⇆) in the column header. For example, to get the issue summary, you'd expand the fields column and then select only the summary checkbox.
• Select Key Information: Expand other useful fields like status, assignee, reporter, updated, created, priority, and any custom fields you need. As you expand, uncheck the columns you don't need to keep your table clean.
• Format Columns: You can right-click any column header to change its data type (e.g., from Text to Date/Time), rename it to be more readable, or remove it entirely.

Don't worry about getting it perfect on the first try. Every change you make is saved as a step in the "Applied Steps" sidebar. You can go back and edit or delete any step without having to start over.

Step 4: Load and Refresh

Once you are happy with how your data looks in the Power Query Editor, click Close & Load in the top-left corner. Your Jira data will now appear in a new sheet in your workbook, formatted as an Excel Table.

The best part? To get the latest data from Jira, simply go to the Data tab and click Refresh All. Excel will automatically rerun all your query and transformation steps in seconds.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: Using a Jira Marketplace App

If the Power Query method feels too technical or you need more structured exporting capabilities out-of-the-box, the Atlassian Marketplace is your next stop. Many third-party apps are built specifically to bridge the gap between Jira and tools like Excel.

These apps often provide pre-built templates for common reports and handle the complexities of Jira’s data structure for you. Popular options like "BigPicture," "Exporter," and "Better Excel Exporter" offer features like:

• Pre-formatted templates: Instantly create familiar report types like Gantt charts, timesheet reports, and velocity charts.
• GUI-based setup: Use a graphical user interface to select the fields you want instead of writing JQL manually.
• Scheduled exports: Some advanced apps allow you to schedule exports to a file that can be automatically picked up by other systems.

To find these, just navigate to Apps > Explore more apps within your Jira instance and search for "Excel" or "export." Keep in mind that most of these are paid apps with a recurring subscription fee.

Method 3: Automation Platforms like Zapier or Make.com

This method is less about syncing a full dataset and more about updating an Excel sheet in real-time based on specific events in Jira.

Tools like Zapier and Make.com work on a trigger-action basis ("when this happens in Jira, do that in Excel"). This is perfect for things like building a log of completed tasks or tracking newly created bugs automatically.

A typical automation (or "Zap") would look like this:

• Trigger: New Issue Status Updated in Jira (e.g., status changes from "In Progress" to "Done").
• Action: Add a New Row in Microsoft Excel Online.

Within the setup, you would map the fields from the Jira issue (like Issue Key, Summary, Assignee, and Resolution Date) to the corresponding columns in your spreadsheet. Every time an issue is marked as "Done," your Excel sheet gets a new line item within seconds. This creates a live, automated log without any manual intervention.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for a Healthy Connection

Whichever method you choose, a little planning goes a long way. Keep these tips in mind as you build your automated reporting:

• Be Specific with Your Queries: Don't try to pull your entire Jira instance into one spreadsheet. Use targeted JQL filters to pull only the data you need for a specific report. This makes your refresh faster and your files smaller.
• Focus on Data, Not Formatting: The goal of the connection is to pull raw data. Do your chart creation, conditional formatting, and PivotTables in Excel after the data has loaded. This keeps your query clean and focused on one job.
• Set Refresh Schedules: In Excel, you can configure your connection to automatically refresh on a schedule (e.g., every 60 minutes) or whenever the workbook is opened. Right-click your data table, go to Table > External Data Properties, and set your preferences.

Final Thoughts

Moving away from manual CSV exports is a game-changer for anyone who reports on project management data. By using methods like Excel’s native Power Query, dedicated Marketplace apps, or automation tools, you can create reports that are accurate, self-updating, and save you countless hours of work. It’s a small investment of time upfront that pays huge dividends in efficiency and data quality.

While connecting Jira to Excel is a huge step forward, your reporting is often still scattered. We built Graphed to solve this very challenge. Instead of pulling raw data into a spreadsheet for manual analysis, we allow you to connect sources like Jira, Salesforce, and Google Analytics in one place. You can then ask questions in simple, natural language - like "show me all completed Jira issues by assignee last month as a bar chart" - and get a live, interactive dashboard built for you instantly. This eliminates the need for Power Query, complex VLOOKUPs, or rebuilding pivot tables, freeing your team to focus on insights instead of data wrangling.