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. In case you have a Test Set with potentially many Test Cases inside, some of which are parameterized, you can still proceed. Below are the steps that you need to follow to run a test in Excel:
1. Create a Test Run for the Test Set you want to run.
2. In the Test Run detail page, click on the 
which will generate an Excel document After the action is executed, the Test Run status gets converted to SUSPENDED.
which will generate an Excel document After the action is executed, the Test Run status gets converted to SUSPENDED.
Running Tests in Excel and filling the Test Results
The Test Set exported in Excel generates a testRun.xlsx file which appears as:
For each Test Case there are at least two rows added to the Excel sheet. For Test Cases with multiple steps each step goes in a new row. The Name/Description/Pre-Action and all other necessary data from the Test Case is exported and appear in 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, steps, and then enter the Test's results. The results are shown in the:
• Actual Result column: Any text here will be loaded into the corresponding Test Steps' Actual Result field.
• Run Result column: A choice field with the NOT RUN YET, PASSED, FAILED, BLOCKED with the possible values here. That becomes the Step's Result field if that is a Test-step's row, or the Result of the Test Case if the Test Case has no steps at all.
• 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 (1:10:05 means 1 hour 10 min 5 seconds).
• Conclusion: This is optional comment wiki text, 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 Excel's Test Run is complete, go back to Codebeamer, use the link from the exported excel document.
After the page is displayed, you can see an upload section under the Test Results panel.
If all the Test Cases of the original Test Run have been completed inside Excel, then the original Test Run will be completed, and the Results are loaded appropriately into the steps.
If you forgot to run some Test Cases inside the Excel sheet, meaning that some Run Result cells are set to 'NOT RUN YET' then those Test Cases are not completed, but will remain open. These Test Cases can later be completed inside Codebeamer using the built-in Test Runner tool.