If you have your test cases in CSV or a spreadsheet, then you can simply get them imported (added in bulk) in your TestCollab project following some simple steps.

You start by selecting the datasource. As of now we support CSV and spreadsheet like XLS/XLSx/ODS formats.

In this article we would be referring the selected file as datasource.

Tip: Most of the spreadsheet management software like MS Excel, LibreOffice allow you to get the spreadsheets exported in CSV format.

Here, we upload the file with test cases to be imported.

Tip: You can also download a sample file (using the link provided) that can be referred for the format that is expected by the application. A copy of the sample file is also attached with this article.

Once the file is selected, you can select the suite options and Steps parsing options.

Only needed if you have all steps in a single row.

Note: Expected results are optional that means steps can exist without expected results but it should not be vice versa.

Here, you select 'Yes' if your datasource contains the column headers (it usually is the top most row that is by default shown selected)

This is an important step as the columns in datasource are to be mapped with the test case's fields including the custom fields.

Note: All mandatory fields for test case should have a column mapped with them. Columns that are not mapped with any of the fields will not get their data imported. Similarly the non-mandatory fields that are not mapped to corresponding columns from datsource will be left blank or would have their default values.

The second part of this step requires mapping of values for fields (that have options) with the values present for columns mapped.

If you had earlier opted to map the suites then you would be mapping data present in datasource (for column mapped to suite field) with suites already present in project.

Preview the test cases' data before it gets imported.

Tip: Till this point, you can use the "Back" link provided with the step title to switch to the previous steps to review the selections made.

The import operation is taken care of by a background process so you would see progress of completion of task (in percentage).

All errors/issues with data rows would be reported when the import process finishes, it consists of row index number of record that failed and the reason of failure. The issues may arise due to inconsistent or invalid data present in datasource.

Note: If you are on the free plan then the maximum number of test cases that can be imported will be :

Maximum no. of test cases allowed for free plan - Test cases already present in all projects.