How to export Jira issues to a CSV file

Jira can save any list of issues as a CSV file. Our printer turns that file into index cards or a tidy list. Here’s every click, plus the spots where people usually get stuck.

Before you start

• You need: a computer and access to the Jira project. Exporting may be turned off by your Jira admin.
• Time: about 2 minutes.
• Tip: decide which issues you want first (for example, the current sprint). The export only includes what’s in your search results.

Step by step

1. Open the issue search. In Jira, open Filters in the top bar and choose View all issues (on some sites it’s called Search or Issues).
   You’ll see: a list of issues with search boxes or filter buttons above it.
2. Narrow the list to what you want to print. Use the filters (Project, Status, Assignee…), or switch to JQL and type, for example: project = SHOP AND sprint in openSprints()
3. Open the export menu. At the top right of the results, click ••• More actions, then Export.
4. Choose the CSV option with all fields: Export Excel CSV (all fields). On older sites it’s called Export CSV (all fields).
   You’ll see: a short wait, then a .csv file in your Downloads folder, named like Jira.csv.

All fields or current fields?

• All fields includes story points, labels, sprint, description and parent. Choose this for cards.
• Current fields only includes the columns showing in your list. Use it if all fields is very slow or fails.

Check that it worked

• There’s a .csv file in Downloads. If you open it, you’ll see one row per issue and some repeated column names (several Labels or Sprint columns). That’s normal; the printer merges them.

What might confuse you

• “There’s no Export option.” Your admin may have turned exports off, or you’re on a board view. Go to Filters › View all issues first; the export lives there.
• “The file is empty or the export fails.” Try current fields, or narrow the search. Very large “all fields” exports can time out.
• “Some issues are missing.” The export follows your search. Check the filters, and remember that one export holds up to 10,000 issues; split bigger sets into several searches.
• “My story points don’t show on the cards.” Your site may use a different field. In the printer, open Card fields and pick the right column for Points.

Next: print it

Drop the file on Print Jira cards. Choose 2, 4, 6 or 8 cards per page and print at 100% scale so the cut lines line up. Nothing is uploaded.

Print the issues as cards →