Importing Test Cases from Excel to TestLink

Importing Test Cases in Test Link

As part of a migration of test cases from Excel to TestLink 1.9.14, we had to import existing test cases from our current test cases repository (Microsoft Excel).

Out of the box, there was no easy way to do this as TestLink will only import xml and the xml needed to be in the correct format, which was not easy to manually do, especially for the large number of test cases we required to import.

This is just a short blog explaining the best method I found whilst searching the web, to Import existing test cases from Excel into TestLink. This worked really well in our environment.

Downloads required:

https://sourceforge.net/projects/ex-converter/

EX-Converter is a windows application that converts the test cases from Excel into the appropriate TestLink XML Formats. 

The only columns this will import are:

Name

Importance (Priority)

Summary (eg. Title)

Preconditions

Actions (Steps)

Expected Results

The spreadsheet should be in the following format:

After running Ex-Converter fill it in like the below:

Click on convert and go to the location where you saved the file: testcasessample1.xml

Log into Test Link and select a test suite you want to import the test case into.

Click on the import option: