Importing issues from excel to JIRA

[Hemanth Kumar BH]

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.

[Udo Brand · Accepted solution]

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

[Hemanth Kumar BH]

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

[Udo Brand]

Glad I could help.

[kumar Koppisetti]

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

[Udo Brand]

Start at looking here: https://confluence.atlassian.com/display/JIRA062/Importing+Data+from+CSV

[Janos Biro]

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

[Chuck Diewald]

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

[praga indrakumar]

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

[Lewis Cook]

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.

[Amit Anand]

Is this possible to migrate transition history as well?

[Lewis Cook]

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

[Yogesh Mude[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. 

[kumar Koppisetti]

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

[Rohan Chitre]

Hello Hemanth,

Can you please explain how could you import from excel?