Is it possible to import issues from an Excel file into JIRA Server and how?

Maria Victoria Martinez Torino March 30, 2017

Hi,

We are using JIRA Server 7.1.x, both Software & Core, and we would like to know 1) if JIRA issues can be imported from an Excel file, 2) how can those issues be imported? is it via add-on/plugins installation?, and 3) if there are some specific permissions/access the user should have in order to perform this task.

Look forward to your answer.

Thanks in advance!

Victoria

 

2 answers

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2017

Save the excel file as CSV, then use the CSV importers.

Project admins have one option for importing CSV, but JIRA administrators also have the importers options.

Maria Victoria Martinez Torino March 30, 2017

So is this the workaround for using excel files? save the data in the *.xls file as CSV?

Another question -  is this functionality something that comes OOTB with JIRA or is it a plugin? I ask this because I have an option in JIRA Server to import issues, it's under menu "Issues > Import Issues from CSV." Is this what you call "CSV importers"?

One last question - do you have a link to specific documentation talking about those other importer options a JIRA admin has?

 

Thanks very much!

Victoria.

 

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2017

It's not a "workaround", it's "using a known standard (instead of a broken proprietary one that would cost a fortune to support)".  Excel files are a complex mass of intertwined data items that are hard to read and harder to understand, especially as there's very little in the way of logic in them.  Every time MS releases something, there's some tweak to the format that might break anything trying to read them.  CSV is a standard format for plain tabular data.  So it's supportable, unlike Excel.

The importers are technically add-ons, but they're ones distributed "off the shelf", so yes, you have them.

Start at https://confluence.atlassian.com/adminjiraserver071/importing-data-from-csv-802592885.html

Maria Victoria Martinez Torino March 31, 2017

Thank you @Nic Brough [Adaptavist]! I will take a look at the link you have provided.

Cheers,

Vicky

0 votes
Joe Pitt
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2017

I haven't done it for a while, but you used to have to have the file on the server JIRA was running on. 

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 30, 2017

Still true.

Maria Victoria Martinez Torino March 30, 2017

Could you please specify a little more about this?

Suggest an answer

Log in or Sign up to answer