nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Maria Victoria Martinez Torino

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

Accepted answers

Nic Brough -Adaptavist-

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.

All comments

Nic Brough -Adaptavist-

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.

Joe Pitt

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-

Still true.

Maria Victoria Martinez Torino

Could you please specify a little more about this?

Maria Victoria Martinez Torino

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-

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

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

Cheers,

Vicky

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-administration

jira-server

jira-core

import