How do I import tests from Excel into Testuff?
- Arrange your Excel file to fit the import format:
- Please click here to download an example of an import Excel file.
- The sheet name should correspond to the project name.
- The first row on each sheet should have the header line containing column names.
- Suite names should appear in the first column with no other info on the same row. There’s no need to repeat the suite name on the next rows.
- Test names should appear in the second column. There’s no need to repeat the test name either.
- Preconditions should appear in the third column. Each should appear on a separate row. Note that you can add only one precondition per test. Make sure it is on the same row as the test name.
- Test steps should appear in the fourth column. Each step should appear on a separate row.
- Expected results should appear in the fifth column next to the test step they relate to.
- Priority, Estimated time, and category parameters can be entered in the Properties column (comma separated).
- Labels can be also imported. Make sure to enter them in column J (follow the sample file).
- Go to the Testuff home screen via the home icon at the top of the Testuff window.
- Click the Import from Excel link.
- Choose the Excel file you wish to import. If importing into an existing project, tick the overwrite check box to update existing tests within that project. Provide the test ID for each test you are going to update inside the spreadsheet.
- Click Next.
- An HTML preview of the imported Excel file will be displayed. Make sure that it matches the data from your Excel file. If it doesn’t, please click Back, edit your Excel file and check for any mistakes. Then try to import the file again.
- Click Import to start importing the file.
- Projects will be created based on the sheet name. If the project already exists, then a new branch called Excel import will be added to it with the imported Excel data.
Import is also available for requirements. Read more here.