Skip to main content
All CollectionsMicrosoft Excel - Technical Guides
Configuration Guide for the AI Test Case Generator for Microsoft Excel
Configuration Guide for the AI Test Case Generator for Microsoft Excel

This guide will help you understand how to generate test cases in Excel using AI Test Case Generator.

Updated over 6 months ago

To download the latest version of the excel file, you must have an account on the BakeQA API Portal and have an existing API key.

1. Open the BakeQA API Portal - https://portal.bakeqa.com/

2. Navigate to the ‘Templates’ page.

2. Download the file.

3. Open the Excel sheet.

4. Click the ‘Enable Editing’ button.

5. Navigate to the Config Tab.

6. Paste the API key from the BakeQA API Portal in Config tab of the Excel file.

API Portal key:

7. Open the Stories tab.

8. Paste your Stories on the tab using the Summary and Description column.

Note: You can be descriptive on the description column if there are specific requirements you want to include.

9. Go to the Test Cases tab.

10. Right click on the sheet and click ‘Refresh’.

11. Select the Anonymous tab and click the ‘Connect’ button.

12. Click the ‘Ignore Privacy Levels’ checkbox and click the ‘Save’ button.

13. Check the generated test cases.

Did this answer your question?