excel to testlink

{

Transferring Test Cases From Excel to TestLink step by step

By Erol Selitektay

First, click a Test Suit, then click Export button that is under Test Case Operations. Note. You need at least 1 test case under the Test Suit.

Click Export button. Also, you can give a suitable name for your xml file.

Now we have an xml file. After that create a new Excel file.

Select first cell then click Data from the tab menu

Click Other Resource then click XML Data Import. Note: The excel captures are Turkish but I believe you can figure out where you should click.

Select the xml file that we export from TestLink. Then click Open button.

After import the xml file, you should have something like in the capture. You can add test case what number you need. Of course you must follow the structure. Note: execution_type can be 1 or 2. 1 refers to Manual and 2 refers to Automated type. And importance can be 1,2 or 3. 1 refers to Low, 2 refers to Medium and 3 refers to High.

After adding test cases you must save the excel file as XML. In this case, I saved as DemoTCs.xml

Go back TestLink and import the xml file.

Click Select File button.

Finally, we add our test cases to TestLink.