How to export test cases from Xray to Excel

[Shraddha Misri]

Hi I want to export the Xray test cases to excel in the below format.

Test Case Identifier

Summary

Description

Action

Expected Result

Test Type

Status

I am able to export with Action, Data, and Expected Result fields. Is there any way to include the above fields. As when we are importing the Test cases we are importing in the above format. I want to export in the same format. Kindly help me with this. 

Thanks in advance.

Shraddha Misri

[Manoj Gangwar · Accepted solution]

Hi @Shraddha Misri ,

We are using this plugin to export the x-ray issues along with the required fields.

https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?tab=overview&hosting=cloud

[Shraddha Misri]

Hi @Manoj Gangwar 
I am not able to see the Issue Navigator in my Jira, do I need to add the plugin first , then will be able to see the it?

[Manoj Gangwar]

Hi @Shraddha Misri , 

Issue navigator, you can see at the header of Jira. 

If you are using Jira cloud then at the top click on Filters> advanced issue filter. 

For Server, you can click on Issues at the header then select option to search JQL. 

You can use the JQL. 

Project = your project name and Type= Test

After that you have to switch from basic search to advanced search and you will see the export option. 

[Shraddha Misri]

Thanks, and is there any subscription to use the better excel Exporter. Is it free or we need to pay for it?

[Shraddha Misri]

When running the JQL Project = your project name and Type= Test, getting no result found

[Manoj Gangwar]

You can use the traiil version of Better Excel. 

If you have test cases in your project then it should be show the results. 

[Shraddha Misri]

I am using Xray for writing the test scripts. I don't think my company will allow to use the trial version of better excel. Is it a paid plugin?

[Manoj Gangwar]

Yes, it is.

[Shraddha Misri]

Any other way to export the testcases with the above mentioned fields?