Export Git commit details from Jira to Excel

Git Integration is the most feature-rich Jira app to integrate the Git version control system with the Jira platform. It supports all major Git servers, including Git itself, GitHub, GitLab, BitBucket, Microsoft Azure DevOps Repos, AWS CodeCommit and Gerrit.

Better Excel Exporter can export the Git commits (all details!) associated with the Jira issues, and all Git Integration specific custom fields to Excel. It also offers a report template to create custom development-focused reports from Jira and Git information.

Next steps

Export samples

Issues with selected fields and Git commits

Using the issue-navigator-with-git-commits.xlsx template, you can export your Jira issues using the Issue Navigator columns plus additional columns that contain the Git commits linked to the issues. Git commits are exported to Excel with these details in the right: repository, branch, commit ID, author, creation time, commit message, commit notes, and changed files.

jira-issues-selected-fields-with-git-commits.xlsx

Development task list with Git branches

This status report document lists the state of all the Jira issues in a Scrum sprint in an Excel spreadsheet. Using the two Git Integration custom fields, it also shows whether an issue has Git commits associated with it (gitCommitsReferenced column) and which Git branches were affected if any (gitBranch column).

jira-development-task-list-with-git-branches.xlsx

Git development metrics report

The git-report.xslx template allows reporting on the Git commits linked to your Jira issues, in order to measure every step of your development process. This sample has the following reports: commit count per issue, code changes (lines added and deleted) per issue, commit count per author, commit activity per repository (timeline per year and week) and author activity (timeline per year and week). Feel free to customize these Excel reports or add your own!

jira-git-development-metrics-report.xlsx