Easy Tech TutsHow to Import Issues From Excel to Jira
By Impran M N
Migrating from a spreadsheet to Jira, or bulk-adding a large batch of issues, is much faster through the built-in import tool than creating each one by hand. This guide covers importing issues from Excel into Jira.
01Prepare your Excel file
Format your spreadsheet with clear column headers matching, as closely as possible, the Jira fields you want to populate.
02Save the file as CSV
Convert the Excel file to CSV format, since Jira's external import tool typically expects CSV input.
03Open the external system import
Go to Jira administration and find the CSV import option under system settings.
04Map your columns to Jira fields
Match each spreadsheet column to the corresponding Jira field, such as summary, description, or assignee.
05Run the import and verify results
Start the import, then check the created issues to confirm data landed in the right fields.
Frequently asked questions
Does Jira support importing directly from an XLSX file?
Jira's import tool generally requires CSV format, so an Excel file typically needs to be saved as CSV first.
Can I import issues into an existing project?
Yes, the import wizard lets you choose an existing project as the destination for the imported issues.
What happens if a column doesn't match any Jira field?
Unmatched columns can usually be mapped to a custom field or simply left unmapped and ignored during import.
Is there a limit to how many issues I can import at once?
Very large imports may need to be split into smaller batches to avoid timeouts or performance issues.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
