TestRail provides the ability to export test cases, which allows teams to share, collaborate, and analyze test cases outside of the TestRail environment. In this article, we will provide a comprehensive guide on how to export test cases in TestRail.
You can export test cases in three different formats.
- XML
- CSV
- Excel
Exporting test cases to Excel
Below are the steps to export the test cases in TestRail in Excel format:
- Open your project and go to the Test Cases page.
- Click on the Export icon at the top right corner of the test case list. Select the Excel format.
- In the Export to Excel dialog, you can choose the Sections and Columns you would like to export.
By default Export all sections radio button is selected, but you can also choose specific sections by checking the Export the following sections only radio button. You can select multiple sections by holding Ctrl/Cmd on your keyboard.
You can also check the Include separated steps on separate rows checkbox if you would like to include separated steps of test cases in separate rows of Excel file.
We recommend you leave Include separator hint for maximum Excel compatibility checked.
- Click on the Export button to start the export process. Depending on the size of your test cases and the selected export format, TestRail may take a few moments to generate the export file.
- The Excel file should be downloaded. You can see a sample reference.xlsx file to inspect what the export looks like.
Exporting test cases to CSV
Below are the steps to export the test cases in TestRail in CSV format:
- Open your project and go to the Test Cases page.
- Click on the Export icon at the top right corner of the test case list. Select the CSV format.
- In the Export to CSV dialog, you can choose the Sections and Columns you would like to export.
By default Export all sections radio button is selected, but you can also choose specific sections by checking the Export the following sections only radio button. You can select multiple sections by holding Ctrl/Cmd on your keyboard.
You can also check the Include separated steps on separate rows checkbox if you would like to include separated steps of test cases in separate rows of CSV file.
- Click on the Export button to start the export process. Depending on the size of your test cases and the selected export format, TestRail may take a few moments to generate the export file.
- The CSV file should be downloaded. You can see a sample reference.csv file to inspect what the export looks like.
Exporting test cases to XML
Below are the steps to export the test cases in TestRail in XML format:
- Open your project and go to the Test Cases page.
- Click on the Export icon at the top right corner of the test case list. Select the XML format.
- The XML file should be downloaded. You can see a sample reference.xml file to inspect what the export looks like.
The XML export format is most useful for further processing or integration with other tools. Exporting as XML also allows seamlessly importing back to TestRail, maintaining all the original sections and test cases structure.