User Management 
Help Index Backing Up Your Test Data
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 imported Excel file.
- The sheet name should correspond to the project name.
- The first line 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 line. There’s no need to repeat the suite name on the next lines.
- 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 line. Note that you can add only one precondition per test. Make sure it is on the same line as the test name.
- Test steps should appear in the fourth column. Each step should appear on a separate line.
- Expected results should appear in the fifth column next to the test step they relate to.
- To set a suite as a Requirement, add requirement=true in the suite name row, properties column. To add a description to this requirement, enter the description text in the same row, precondition column.
- 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.
