nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can I extract Xray 'Step Details' of 'Tests' from JIRA in bulk?

Omer Yaylagul

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?

Accepted answers

All comments

Viswanathan Ramachandran

hi @Omer Yaylagul

did you try the Xray GraphQL API - https://getxraydocs.atlassian.net/wiki/x/hgWoAg

zoltanersek _outpostlabs_dev_

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.

Mikael Sandberg

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.

Viswanathan Ramachandran

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.

Martin Luethi _Mobility Stream_

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

Omer Yaylagul

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

Omer Yaylagul

Thank you for sharing the information @Martin Luethi _Mobility Stream_

Omer Yaylagul

Thank you for the sharing information @zoltanersek _outpostlabs_dev_

Levente Szabo _Midori_

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:

Collect all your Tests in Issue Navigator (a JQL query works fine for 500+ at once).
Add the "Manual Test Steps" field as a column.
Use the app's "Better Excel" export option.

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

xray

jira

cloud

jira-cloud

xray-cloud