Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Importing issues from excel to JIRA

Mohamed Khairy November 18, 2019

I need to know how to import issues from excel to JIRA Software Project, as i have around 200 tasks and dont want to add them manually one by one 

2 answers

1 vote
Ollie Guan
Community Champion
November 18, 2019

Hi @Mohamed Khairy ,

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.

https://confluence.atlassian.com/adminjiracloud/importing-data-from-csv-776636762.html

Mohamed Khairy November 18, 2019

Thanks alot, in fact its very complected method, hope if they have better one 

0 votes
Pete Singleton
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2019

As above, you can only import from CSV.  However, it's very simple to save your Excel file in CSV format.

As a minimum you only need one column in your import file, the Summary field of the new Jira issue.

Mohamed Khairy November 18, 2019

The problem not from save Excel to CSV, the problem after having CSV file i dont find direct method to import it 

Pete Singleton
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 18, 2019

I'm not sure where the import option is in Cloud version, but on Jira Server it's in the System Admin section called "External System Import".

Suggest an answer

Log in or Sign up to answer