Importing data from Excel

Unfortunately, right now we don't have a built-in JIRA importer for native Microsoft Excel files. But it is still possible to perform a two-stage import using CSV import mechanisms.

How to transform an MS Excel files into a CSV file

Microsoft Excel is capable of saving the spreadsheet in multiple file formats, including CSV. Before you save, we recommend you clean up the spreadsheet from all unnecessary information or macros and make sure that the table columns are labeled correctly.

When ready, select File / Save As and chose the CSV format from the "save as type" drop-down list.

In case of problems please refer to Microsoft documentation for help.

How to import CSV data back to JIRA

If you want to create issues as well as projects, users, etc. please refer to our CSV importer help. If you don't have administrative privileges in JIRA, you can also import CSV data into a single project through the user CSV importer, if enabled. In both cases, the importer wizards will guide you through the steps of mapping fields and values and validating the data before the import.

If you are looking for an easier solution

The import through CSV has some limitations. If the results aren't satisfactory, there are complete third party solutions available which might help you. Please check out the following offers solution from Atlassian Marketplace:

You can also contact your local Atlassian Expert for help.

Why do we have this page?

We are tracking the visits to this page. The intensity of visits will help us prioritize the work on the next set of JIRA importers. It will not help you today, but think of yourself as of a democratic voter who will change the future of JIRA. And for that we thank you.

Last modified on Jan 31, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.