Jira 백로그를 Excel로 내보내는 방법 – 빠르고 쉬운 단계

This document provides a comprehensive process for exporting backlog data from Jira into an Excel file. Follow these steps to efficiently transfer your backlog information.

1. Access Your Backlog

• Open your Jira project.

• Go to the “Backlog” view (under the Board menu if you're using Scrum).

2. Filter Issues (Optional)

• Use available filters (e.g., sprint, label, assignee) to narrow down the backlog items you want to export.

3. Open Advanced Issue Search

Jira's backlog itself doesn’t have a direct “Export” button, so you need to:

• Go to the top navigation bar → Issues > Search for Issues.

• Use JQL or the filter used in your backlog view (e.g., project = YOUR_PROJECT AND statusCategory != Done).

4. Export to Excel

• Once the filtered issue list appears:

  • Click the “Export” button (top right of the issue list).

  • Choose one of the following:

    • “Export Excel CSV (current fields)” – exports only visible fields.

    • “Export Excel CSV (all fields)” – includes all available issue fields.

5. Download and Open

• The CSV file will be downloaded to your computer.

• Open it using Microsoft Excel, Google Sheets, or any spreadsheet editor.

Step-by-Step-Guide: How to Export Jira Backlog to Excel

Step 1

Click on Filters.

Step 2

Then click on view all issues,

Step 3

Then click on Status,

Step 4

Select blocked.

Step 5

Click on the projects,

Step 6

Then select the particular project.

Step 7

And click on the export,

Step 8

Then select the export file type.