hey guys! jira is a bit alien to me , can any one plz help me, how to upload test cases which are written in excel

hey guys! jira is a bit alien to me , can any one plz help me out, how to upload test cases which are written in excel,

as v generally desing test cases in excel and upload them with results so iam expecting the same is possible with jira too.........help me out guys

4 answers

You can import data into Jira using CSV as explained here http://confluence.atlassian.com/display/JIRA044/Importing+Data+From+CSV

But remember this is an admin funtionality and not for regular users. So doing this on a continuous basis is not a practical solution.

If you are looking at regular sync between Excel and Jira you need to explore other options like writing a SOAP based program to do the same.

You could try to use the Jira Command Line Interface also.

Specifically, Renjith's last point is discussed in more detail here - https://answers.atlassian.com/questions/28223/jira-issue-excel-import-external-user/28241

thanx a lot bro for such an useful stuff u shared vd me hope il get used to jira soon as u guys r....


Your comment about "...and upload them with results ..." makes me wonder if you really/actually even need to upload the Test Cases. Why not use the excel sheet as the basis of tracking your regression testing, and in event of defects being found create bug report issues on the fly using JIRA - and importantly: including the screenshots and details, assign to the right person, etc ... all in realtime (rather than having to wait for some upload).

However, if the purpose is to also be able to portray the status/progress of planned regression testing then of course import them as issues using the mechanism already described by others above.


  • I'd *strongly* suggest you develop and test your approach to doing the import on a test instance of jira first.
  • There will probably be a fair amount of data sifting/augmenting in your csv before it's suitable/successful. Particularly: alignment of the assignee username/s, dates, fixVerion (release), special character encoding in the description+summary, etc.

thanx buddy dat was an useful stuff u xplained.......sry fr making u wonder bt wt i meant was about QC in dat v generally upload the test cases by using excel add-in along with d screenshots .........i was jz looking the same in jira anyways thanx for ur time bro



In case you have not heard or checked it out, Zephyr for JIRA would really help you out in this situation. Zephyr for JIRA allows you to import test cases from an excel file into your JIRA. Below is a link to the Zephyr for JIRA product. There is a 30 day free trial too to make sure that the product is right for you:


And below this is a link to the Zephyr for JIRA Tests Utility Importer:


Kind Regards,


Suggest an answer

Log in or Sign up to answer
Community showcase
Published Friday in Agile

Are you a Jira Service Desk agent? We want to talk to you!

Are you a whiz at handling tickets and looking at how you can further optimize your workflow with automation? Do you tackle detailed customer support questions while simultaneously getting flooded wi...

95 views 0 5
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you