Sync Google Sheets and Excel with JIRA
Bi-directional sync between Excel / Google Sheets and JIRA. Bulk sync, create, and map JIRA issues with the powerful analytical capabilities of spreadsheets
Trusted by teams at
Everything you need to keep Excel & Sheets & JIRA in sync
Powerful features for project managers, engineers, and other users who live in spreadsheets and JIRA.
Real-time Sync
Bi-directional sync between your spreadsheets and JIRA. Changes propagate automatically in both directions on demand or a schedule.
Bulk Import & Export
Move hundreds of JIRA issues into a spreadsheet or push rows to JIRA in one click. Excellent capability for team planning in worksheets.
JQL, JQL Update, and Filters
Run JQL or saved filters queries directly in worksheets, show desired columns, and update issues using enhanced JQL syntax.
Roadmap Planning
Automated exports on your schedule. Fresh JIRA snapshots in Google Sheets or Excel — hourly, daily, or weekly.
Capacity Planning
Smart conflict detection when data changes on both sides. Keep JIRA, keep Sheet, or merge — your choice.
Label Management
Complete history of every sync. See what changed, when, and who triggered it. Exportable logs for compliance.
Up and running in three steps
Connect to JIRA, map your data, and let Sheet Sync handle sync issues while you show your worksheet skills
Install and Configure
No need to bug your JIRA administrator. Simply install the addon from Microsoft or Google Marketplace. Configure it with your JIRA username and API Key or password.
Synchronize Issues
Once connected to JIRA, specify JQL or saved filters, configure display columns, and with one click, download issues to the specified worksheet for further analysis.
Analyze in Excel or Sheets
Once the data is in spreadsheets, use the addon's builtin roadmap and capacity planning, custom formulas, and the endless analytical capabilities of Excel and Google Sheets.
Simple pricing
Start for free. Upgrade when you need unlimited syncs and enterprise features.
Starter
Get up and running in 5 mins
- Unlimited Projects
- Unlimited Scheduling
- 150 Issues sync/update/create
- Capacity Planning
- Roadmap Planning
- Bulk Issues
- JQL Update
- Label Management
- Pivot Tables
- 1 User
- Low Speed Sync
Professional
For single users who want a better JIRA
- Unlimited Projects
- Unlimited Scheduling
- Unlimited Issues sync/update/create
- Capacity Planning
- Roadmap Planning
- Bulk Issues
- JQL Update
- Label Management
- Pivot Tables
- 1 User
- Parallel High Speed Sync
Enterprise
For teams with large number of users
- Unlimited Projects
- Unlimited Scheduling
- Unlimited Issues sync/update/create
- Capacity Planning
- Roadmap Planning
- Bulk Issues
- JQL Update
- Label Management
- Pivot Tables
- Unlimited Users
- Priority Support & SLA
- Parallel High Speed Sync
Loved by teams everywhere
“Sheet Sync saved our PMs hours every week. They used to manually copy JIRA tickets into spreadsheets — now it just happens.”
“We manage sprint planning in Google Sheets and push everything to JIRA in one click. The field mapping is incredibly flexible.”
“Spreadsheets will never go away because they are so powerful. We can now easily create dashboards, pivot tables, and custom formulas with this addon.”
Frequently asked questions
- Does Sheet Sync work with both Google Sheets and Microsoft Excel?
- Yes. Sheet Sync is available as a Google Workspace add-on for Google Sheets and as a Microsoft Office add-in for Excel. Both support the same core features: bi-directional JIRA sync, JQL queries, bulk import/export, dashboards, and scheduled exports.
- Do I need a JIRA admin or a JIRA plugin installed?
- No JIRA plugin or admin access is required. Sheet Sync connects directly to your JIRA instance using your JIRA username and an API key (or password). As long as you have JIRA access, you can sync data immediately.
- How does bi-directional sync work?
- Sheet Sync lets you pull JIRA issues into your spreadsheet using JQL or saved filters, edit them in the spreadsheet, and push changes back to JIRA in one click. You can also create new JIRA issues directly from spreadsheet rows using the bulk create feature.
- What is JQL Update and how is it different from regular JQL?
- JQL (JIRA Query Language) lets you fetch issues matching specific criteria. JQL Update is an enhanced feature in Sheet Sync that lets you filter issues with JQL and then update those issues' fields — like status, assignee, or custom fields — directly from your spreadsheet in bulk.
- Can I schedule automatic syncs?
- Yes. Sheet Sync supports scheduled exports so your spreadsheet always has fresh JIRA data — hourly, daily, or weekly. This is especially useful for management dashboards and reports that need to stay up to date without manual effort.
- How many JIRA issues can I sync at once?
- The Starter plan supports up to 150 issues per sync/update/create. The Professional and Enterprise plans support unlimited issues. Enterprise users also get parallel high-speed sync for large datasets.