How to Run-in-Excel: Exporting the Tests for Running Outside
To perform tests in Excel, the first step is to create an Excel document that has all of the information required for testing. This can be done even with a test Set having many test cases inside, some of which are parameterized.
To run a test in Excel, complete the following steps:
1. Create a test run for the test set you want to run.
2. On the test run details page, click 
to generate an Excel document. After performing this action, the test run status is changed to SUSPENDED.
to generate an Excel document. After performing this action, the test run status is changed to SUSPENDED.
Running Tests in Excel and Filling In the Test Results
Exporting the test set to Excel generates a testRun.xlsx file similar to the following image:
At least two rows are added to the Excel sheet for each test case. For test cases with multiple test steps, each test step goes into a new row. The Name,Description,Pre-Action fields, and all other necessary data from the test case is exported and added to the Excel sheet. If the test case has parameters, then a test case with the resolved parameters appears in the Excel sheet as you would see in the normal test runner. The test parameters are merged into the text of the test case.
All editable fields, such as Actual Result, Run Result, Running Time, and Conclusion have a light-yellow background.
While running the tests in Excel, you should read the test case's description and steps, and then enter the test's results. The results are shown in the following columns:
• Actual Result–Any text added in this will be loaded into the corresponding test steps' Actual Result field.
• Run Result–A choice field with possible values of NOT RUN YET, PASSED, FAILED, and BLOCKED. The selected value becomes the test step's Result field if it is in a test step's row, or the Result field of the test case if the test case has no test steps.
• Running Time–This is an optional field. Enter the time it took to execute the test case. This is a text cell, the data should be in HH:MM:SS format, where 1:10:05 means 1 hour 10 min 5 seconds.
• Conclusion–This is optional comment wiki text. Any text added here will be added to the test run as a new comment.
Once all Test Results are filled in, the Excel document is ready to be imported back to Codebeamer.
Importing the Test Results from Excel
Once the test run in Excel is complete, return to Codebeamer using the link from the exported Excel document, as shown in the following image:.
On the test results page in Codebeamer, there is an upload section in the Test Results panel.
If all test cases of the original test run have been completed in Excel, then the original test run will be completed, and the results are loaded appropriately into the steps.
If not all test cases inside the Excel sheet were run, meaning that some Run Result cells are set to NOT RUN YET, then those test cases are not completed, and will remain open in Codebeamer These test cases can later be completed inside Codebeamer using the built-in test runner tool.