--- title: "Generate Optimised Test Cases and Test Data into Excel" slug: "generate-optimised-test-cases-and-test-data-into-excel" description: "Learn how to generate test definitions for your test infrastructure in an auto-populated Excel sheet directly from Test Data embedded in Test Cases." tags: ["Test Modeller", "Feature Overviews"] updated: 2025-08-11T07:34:08Z published: 2025-08-11T07:34:08Z --- > ## Documentation Index > Fetch the complete documentation index at: https://knowledge.curiositysoftware.ie/llms.txt > Use this file to discover all available pages before exploring further. # Export Tests to Microsoft Excel Learn how to generate test definitions for your test infrastructure in an auto-populated Excel sheet directly from Test Data embedded in Test Cases. [Embedded content](https://www.youtube.com/embed/7WK6gBFNSZU?&wmode=opaque&rel=0) Created an Excel template according to the columns and rows you require. The following are the keywords which can be used in the Excel templates. | **Keyword** | **Description** | | --- | --- | | $[test_case_no] | Index number of the test case. | | $[test_case_no_repeated] | Number of times the test case is repeated. | | $[test_case_name] | The original name of the test case. | | $[test_case_name_repeated] | The original name of the test case - repeated for every step. | | $[test_case_description] | The description of the test case. | | $[test_case_description_repeated] | The description of the test case - repeated for every step. | | $[test_case_step_no] | The index of the test step within the test case. | | $[test_case_step_name] | The test step name. | | $[test_case_step_name_last] | The name of the last test step in the test case. | | $[test_case_step_desc] | The test step description. | | $[test_case_step_desc_last] | The description of the last test step in the test case. | | $[test_case_step_expected_result] | The test step expected result. | | $[test_case_step_expected_result_last] | The expected result of the last test step in the test case. | | $[test_data_variable_names] | List of variables assigned within the test step. | | $[test_data_variable_values] | List of values assigned within the test step. | | $[test_data_variable_value][] | A specific test data value. Replace with the variable name. | ### **Register the Excel file** First off is to register the Excel sheet in Quality Modeller. To do so, along the left Dashboard menu, go to Workspace > Configuration and click the Code Templates tab. Click the blue button New Template and in the New Code Template pop-up complete the info for Name, from the Type drop down menu select Excel. Finally, browse to choose the original Excel file. Notice the new specified Code Template is listed at the bottom as most recently added, with three actions to either edit, delete or download. --- ### **Identify Test Steps** Only nodes indicated as Test Steps export to the Excel Code Template. To activate a waypoint as a Test Step, first select one on the model canvas, then in the Explorer pane on the right-click the i icon, then in Properties toggle to activate as a Test Step. ***Note:****Condition blocks may not be necessary to indicate as a Test Step, since their purpose on the canvas is more to indicate a choice along a path. Test Steps refer more to the outcomes of those decisions.* --- ### **Give parameters to Descriptions and Expected Results for export** In the Properties pane, add Descriptions and Expected Results. In this example, a Description is given as: Enter a valid username '$[Username]' and Expected Result as: '$[Username]' appears in the username field. These are the Test Data Variables specified to be injected. To do so, click the Insert Variable dropdown. --- ### **Generate, export and download the Data** Click Generate and then Export Test Suite, selecting Connector Profile as Excel Template and specify the Template as the one you originally created. Open the downloaded file and see the Test Steps, along with ant other specified fields are populated including any Test Data Variables, with the Test Type and Status. Test cases are equivalent to paths through the model of a system under test. They are generated automatically from a model, with or without test data and test automation associated with them. Test Modeller has coverage techniques using advanced algorithms to generate the smallest set of test cases needed to test given features with a required level of rigour. The Explorer section of Quality Modeller is the main location for finding all your models, data sheets, scans and variables. This will be the main view you use in Modeller and where you create new models and edit existing ones. Test Data Variables are sets of data that can be attached to blocks in models. This data can be custom, synthetic, automated etc. Variables are basically assigned data values and rules to blocks, and this data is used when automation is run. ## Related - [Microsoft Excel](/microsoft-excel.md) - [Import Tests from Microsoft Excel](/import-tests-from-microsoft-excel.md) - [Import Models from Microsoft Excel](/import-models-from-microsoft-excel.md)