It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Importing issues from excel to JIRA

Hello,

We currently have a requirement where in we have bulk amount of issues tabulated in an excel file. Each row in excel has to be created as an issue in JIRA. Is there any sort of plugin or anything which would help us out? Currently we are manually creating issues and since the count of issues to be loaded into JIRA is increasing everyday, we are looking out for an issue importer.

Please guide us

Thank you.

8 answers

1 accepted

6 votes
Answer accepted

I'm not sure if you can import a xls(x)-file, but you could use the csv-Importer. Please check the documentation

Thanks for thr reply Udo Brand.

I went through the documentation and proceeded as guided. I am able to import the issues from the excel to JIRA.

thanks again

Glad I could help.

could you please guide me.. how to import multiple issues from excel to JIRA

Hi guys,

With JExcel  you can import issues from Excel using the usual Ctrl+C, Ctrl+V

https://marketplace.atlassian.com/plugins/com.moresimp.jexcel

I hope it helped,

Regards,

Janos

Try Administration > System > External System Import > CSV to import data from Excel. I ran into some challenges with this, and documented my findings in a blog at Importing a project plan with subtasks from Excel into Jira

Hello Hemanth,

Can you please explain how could you import from excel?

 

 

could you please guide me.. how to import multiple issues from excel to JIRA

Hi @Hemanth Kumar BH,

can u please help us here to import data from Excel format into jIra.

as u mentioned in ur above comment, you provide this documentation, but i went through this article here will find CSV to JIRA. 

Realise this is a pretty old request but for those that stumble back across it this is certainly now possible in the Admin area (server and cloud).

You are looking for a "External system import" which will allow you to map your excel columns to Jira fields etc.

Is this possible to migrate transition history as well?

Hi Amit,

 Not that I am aware of, these are essentially newly created issues.

I've only every done fairly basic imports but I guess if you try it and see what the mapping options are you could potentially import additional detail such as comments or history. I would be surprised if you could though.

Thanks

Lewis

0 votes

Is it possible to do an import of defects into JIRA without having admin privileges ? Any option alternative ? 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you