Is it possible to bulk export the Step Details for Test issues from Jira?
Each test contains multiple test steps (for example, 10 or more), and I would like to export all step information, including the step description, test data (if available), and expected results, into an Excel file CSV and I need to perform this export for 500+ test cases in a single operation, with all associated test steps and expected results included in the output.
Is there a way to achieve this using Jira or a supported export method?
Yes, this is doable. Native Jira/Xray export won't give you step-level detail in bulk, but Better Excel Exporter for Jira handles it:
You get one Excel file with every test's full step table (step, data, expected result) for the whole batch. Save as CSV afterward if that's the format you need.
Docs: Xray integration (Cloud), Xray integration (Data Center), and a walkthrough with screenshots.
Hi @Omer Yaylagul,
I'm not aware of a good way to export Xray test steps directly to Excel. Your best option is to check whether Xray provides a native export, use their REST APIs, or use one of the exporter apps mentioned.
If this is something you need to do regularly, or if you want always up-to-date data for reporting and analysis, you may be better off exporting your Jira and Xray data automatically to a cloud data warehouse.
Our apps, Snowflake for Jira, Databricks for Jira, and Microsoft Fabric for Jira, export Jira, Xray Test Management, and many other data sets, keeping them continuously synchronized. From there, you can easily analyze, enrich, visualize, or export the data in any format you need.
Feel free to reach out if you would like to learn more.
Best regards,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for sharing the information @Martin Luethi _Mobility Stream_
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't think the native Jira CSV export includes Xray test steps, since those live in Xray rather than standard Jira fields.
For that much tests, I'd look at Xray's REST API or any built-in Xray export/reporting options, they're generally the supported way to bulk extract step details and test data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the sharing information @zoltanersek _outpostlabs_dev_
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did you try the Xray GraphQL API - https://getxraydocs.atlassian.net/wiki/x/hgWoAg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
GraphQL can do it, just keep in mind that the returned result is paginated with a max of 100 test cases, so if you have a lot of them you have to do it multiple times. I just cloned ~3200 test cases between spaces using it this week. Once you have the output from GraphQL you have to convert it to a JSON file that the Xray Test case importer except, Rovo can help you with that. Another option is to create a doc that exports the test cases with the test details, if you contact Xblend support they can send you an example of what the doc should look like.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Agree, pagination is the most scalable option for large migrations. You can approach this as export pipeline rather than a one-off GraphQL query. Use pagination to retrieve tests in batches, then transform the JSON into a flat CSV/Excel format. This makes the process scalable, repeatable, and easier to rerun for large exports.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I haven't tried exporting with GraphQL yet, but I'll be working on that. Thank you both for your help and for sharing the information.
@Viswanathan Ramachandran
@Mikael Sandberg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.