Jira to Excel

The fastest way to export Jira issues to Excel is to paste your Jira site URL, account email, and API token below and write a JQL query. The converter fetches all pages automatically (up to 1,000 issues) and downloads a clean .xlsx file. No installation, no OAuth. Your token is never stored.

Just the hostname -- no https:// needed.

Create one at id.atlassian.com → Security → API tokens. Your token is never stored.

Examples: project = MYPROJ ORDER BY created DESC | assignee = currentUser() AND status != Done

How to export Jira issues to Excel

  1. Create a Jira API token. Go to id.atlassian.com → Security → API tokens and click Create API token. Copy it immediately -- it is shown only once.
  2. Paste your credentials. Enter your Jira site hostname (e.g. yourcompany.atlassian.net), the email you use to log in, and the API token in the fields above.
  3. Write a JQL query (or keep the default order by created DESC to pull the most recent issues from all projects).
  4. Click Convert. All pages are fetched automatically.
  5. Click Download .xlsx to save the file.

How to get a Jira API token

Jira Cloud uses API tokens for programmatic access -- not passwords. To mint one: sign in to your Atlassian account at id.atlassian.com, go to Security → API tokens, and click Create API token. Give it a descriptive label, copy the token, and paste it above. The token authenticates as you and respects your project-level permissions -- it can only export issues you can already see in Jira.

Your token is transmitted over HTTPS through a stateless proxy that forwards it to the Jira API and stores nothing. It never touches a database.

Connect Jira to Excel -- what are the options?

There are three common ways to get Jira data into Excel:

  • This tool (free, instant): one-time export using your BYO API token. No install, no recurring subscription. Best for ad-hoc snapshots, sprint retrospectives, and reporting.
  • Jira built-in export: go to a board or backlog, click Export → Export Excel CSV (or Export CSV for all fields). Limited to what is visible in the current view; no JQL filtering.
  • Power Query / live connectors: tools like Coupler.io, Geckoboard, or Excel Power Query with the Jira REST API enable scheduled refreshes for recurring dashboards -- paid, but useful for live reporting.

Jira to Excel free -- what is the catch?

There is no catch. This tool is free and runs entirely in your browser. The only thing you need is a Jira Cloud account with an API token. It exports up to 1,000 issues per query -- if you need more, split your export with JQL date filters (e.g. created >= 2024-01-01 AND created < 2025-01-01) and merge the sheets.

JQL examples for exporting Jira issues

  • All issues in a project: project = MYPROJ ORDER BY created DESC
  • Open issues assigned to you: assignee = currentUser() AND status != Done
  • Issues updated in the last 30 days: updated >= -30d ORDER BY updated DESC
  • Bugs only: project = MYPROJ AND issuetype = Bug ORDER BY priority ASC
  • All open epics: issuetype = Epic AND status != Done ORDER BY created DESC

Frequently asked questions

Is my Jira API token stored?
No. Your token is sent from your browser through a stateless CORS proxy to the Jira API. The proxy forwards the request and discards everything -- no logs, no database, no credential storage. You can revoke the token at any time in your Atlassian account settings.
How many issues can I export?
Up to 1,000 issues per export. The converter paginates the Jira API automatically, so you do not have to configure pagination manually. For larger backlogs, use JQL date ranges to split across multiple exports.
What columns does the export include?
Key, Summary, Status, Assignee, Priority, Issue Type, Reporter, Created, Updated. Nested Jira objects (status name, assignee display name, priority name) are flattened to plain text automatically.
Does it work with Jira Server or Data Center?
This tool targets Jira Cloud (*.atlassian.net). Jira Server/Data Center uses a different authentication model (basic auth with username/password or personal access tokens on newer versions). The CORS proxy allowlist covers *.atlassian.net only -- on-premise instances would need their own proxy.
Can I schedule recurring Jira exports to Excel?
This tool produces one-time exports. For scheduled exports, use Power Query with the Jira REST API, or an automation tool like Zapier, Make, or Coupler.io.

Export other tools to Excel