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

how to export and import test cases in Jira


I have around 100 plus test cases which were created in an Excel. But i dont want to execute and maintain them using Excel. I want the test cases to be maintained in Jira. all the updated, status, concerns, fixes, etc of each test cases need to be shown in jira. Could someone suggest and instruct me?

10 answers

1 accepted

1 vote
Answer accepted
Kiran Atlassian Team Jul 11, 2013

You can try out Zephyr for JIRA plugin which is available in the Market place at

And here is the documentation on using Zephyr for JIRA Test Importer Utility to import excel test cases to JIRA.

And here is the documenation to export the testcases from JIRA to Excel using Zephyr

Hi Kiran, Thanks for getting this one. I want to add that we have the import process documented as well. It is only located on our community forum so here is the link for a PDF on how to use the importer tool.


Hi Kiran,

I am on trial version and would like to start using Zephyr. I am wirting test cases but want to have option to export test cases with each step to excel.

I cant export detailed test cases steps, Test Step, Test Data and Expected Result.

Is that possible?

Hi there, 


I am also struggling to import my test details (steps, data and expected results). 
How do I remedy this problem?


Thank you for your time. 


Kind Regards,


Hi Kiran,

I also want to import test cases from excel to Jira using Zephyr.

How should a correct excel design (format) be?.

Thanx in advance.



@Nabil, Zephyr provides great features "out-of-the-box" but if you already have workflows and such set up the way you want them and just need to get the content from Excel to JIRA, you can simply save your Excel sheet as a CSV and use JIRA's built-in CSV importer to import all of the test cases as issues in JIRA.

If that is what you are asking, see or the documentation for whatever version you are using.

Thank a lot everyone.

I'm on the impression that Zephyr has got a cost involved which is hassle for me to get approvals.

@Randhall, i prefer the excel conversion menthod. Can you guide me to video or something which shows how testcase from excel is imported to Jira and vise versa.

Randal, Nabil,

The Excel Import method you mentioned doesn't import test steps. If you want to import test steps, use the Zephyr Import tool.

Also, yes, there is a cost for Zephyr. We're just another company out there with employees who make a product and want to get paid for their work!

Chris <-Works at Zephyr!


First, define your import configuration. Documentation here. This is where JIRA looks at your CSV file and asks you to define how the contents of the CSV file connect to the projects, issuteypes, workflows and fields in your JIRA system. You have to set up your JIRA the way you want it before you can import anything.

Our testing team uses a custom issuetype with a custom workflow and a few standard fields. The issuetype and workflow are included in every project we create test cases for. The few videos I have seen about CSV import for JIRA assume that you already have your projects, workflows, issuetypes and fileds created. Zephyr does a lot of this for you, which is one reason many feel it is worth paying for. If you want to set these up yourself, you need to answer some questions:

  1. What JIRA project will I put my test cases in? Create the project or projects in JIRA, if necessary.
  2. What issuetype will I use for test cases in JIRA? Create issuteypes in JIRA, if necessary. Make sure they are associated with your project(s).
  3. What is my team's workflow for test cases? Create the necessary workflow(s) in JIRA and associate them with your project(s) and issuetype(s).
  4. What fields do I need for my test case issues? Create custom fields in JIRA, if necessary. Associate them with your issuetype(s). Field Configuration is important, but Screen Configuration should not affect the import process.

After you set up JIRA, you can run the CSV Import Wizard to map the Excel information to the structure you created in JIRA. JIRA walks you through that process, but refer to steps 6 through 12 here the first time or two. Check the Preparing your CSV file documentation, too.

Once you've done that, you are ready for the second part, which is simply to run the import, which is step 13 in the CSV Import Wizard instructions. Best to use only a few test cases in your Excel file the first time to test.


i am succesfully importing test case in jira but it didnot showing all the steps.

Hi @geomatani

I want to answer your question hidden in this thread:

Q - "I am on trial version and would like to start using Zephyr. I am wirting test cases but want to have option to export test cases with each step to excel.

I cant export detailed test cases steps, Test Step, Test Data and Expected Result.

Is that possible?"

A - Yes it is possible. You will need to export out your test cases from the Issue Navigator. Go to issue navigator and search for the test cases you wish to export. Once they are on the screen go to the top right and select either 'Export' or the image of the gear depending on what version of JIRA you are running. In the drop down select "Export current". You will then get an excel file that has all the informaiton you seek.

Kind Regards,


Thanks Emily.

Thats exactly what I needed.

As far as importing files, what would you suggest.?

I have excel and XML testcases woudl like to import to Zephyr

Hi @geomatani,

We have the Zephyr for JIRA tests utility importer that allows you to import in test cases from an excel file. You can get the download and the instructions on how to use the importer at the link below:

We also have a beta version for XML importing that you can test. Since it is in beta we ask that anyone who does use it please provide feed back to us. In order for the XML import to be a success the XML file does need to be generated by Testlink.

As for the XML importer, if you have any questions or issues please email me at 'support at getzephyr dot com'. I will be able to assist you further via email regarding this. The same with importing via the excel importer. Any issues you run into email me.

Kind Regards,


Hi Emily, Did use the Zephyr for JIRA tests utility importer as said but facing issue as below Mon Jan 05 16:40:44 IST 2015 file:///C:/APTRA Mobile Banking/Connections/TestsWithStepsInExcel/Test Import.xls normalization success..! Mon Jan 05 16:40:48 IST 2015 Unable to add testcase ending at rowNumber - 2. Error:Unexpected response code: 400 {"errorMessages":[],"errors":{"customfield_11920":"Operation value must be a number"}} Mon Jan 05 16:40:49 IST 2015 Unable to add testcase ending at rowNumber - 8. Error:Unexpected response code: 400 {"errorMessages":[],"errors":{"customfield_11920":"Operation value must be a number"}} Mon Jan 05 16:40:50 IST 2015 Test Import.xls imported successfully..! Not sure which customfield is it refering to? Can you help me provide a solution?

Hello Sunil We would like to gather additional information from your end in order to troubleshoot this issue. Hence i would like to know your email id in order to open up a new case for you in our system . Additionally this issue persists because one of your custom field in Jira instance has input of numeric type only. However the excel file containing the testcase which you are trying to import has a non numeric value for the same custom field. Hence you are unable to import the test case inside zephyr for Jira Kind Regards Pooja

Hi Pooja, Thanks for your response and here is my emailid - And also here is the link for my issue where I have even pasted snapshot of excel sheet used and of error shown on utility - Regards, Sunil

Hi Pooja, Is there any update on the I belong to QA team not sure about which custom filed is it talking about. But as said understood that it is caused due to mismatch of data type for a specific custom field. Thanks Sunil Runkana

Hello Sunil I have opened up a new case for you in our system and will be communicating on the same Kind Regards Pooja

Hello, is the XML importer stable and released now?


We are trying to import test cases into Jira from Testlink. 

Hi @geomatani,

It is completely up to you. Like I had said the XML importer is in testing (they both are but the XML importer more than the excel) and we are looking for feed back. It also only accepts XML files that were generated by TestLink. If you meet that crieteria then give it a shot. We also are looking for feed back on the XML importer.

The excel importer is pretty solid.

Kind Regards,


thank you

Hi Admed,

Can you please email us a sample of the XML file you are attempting to import? Also, a screen shot of the missing test steps in JIRA? Please email it to 'support (at) getzephyr (dot) com'. We will be able to help you further there.

Kind Regards,


Hi there,

With add-on JExcel,  you can import and export your issues (even by copy and pasting the selected cells) with 1 click! And its free.

Feel free to give it a try:

Hope it will help you, too.

Best Regards, Mark 



i would like to know, how is posible upload test cases in JIRA by file, im using qmetry as a test management tool, however im not recongnize where i try to doing this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

[Survey] Development tools and DevOps - share your thoughts!

Hey Community! I work at Atlassian in product marketing and we are conducting a survey to better understand how people feel about their development tool chain and DevOps. We would love if you could...

50 views 0 0
Read article

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