How to import Test Cases from Excel in qTest Manager

Learn now how to import Test Cases from Excel in qTest Manager using the Import Excel functionality.

Do you work with qTest Manager but create your Test Cases using Excel spreadsheets? No worries! These Test Cases won’t be left outside of qTest!

This 5-minute video is a deep dive on importing Test Cases in qTest Manager at the click of a button. It covers everything you need to know to be able to use the IMPORT EXCEL functionality properly. You’ll not only hear about it, but also see how to do this, along with best practices meant to simplify your workflow when importing bulk Test Cases.

From using naming conventions, filling in your Test Case information in Excel to mapping your fields in qTest, everything is covered in this video. You’ll even get an insight into some Admin work.

Software Version used in this video: 10.3.

#TricentisAcademy #Tricentis
To make the most of your educational journey through certification courses, Role-Based and Product-Based Learning, live events and more, visit our website.

[deejoetc]

Excel has a 32 character limit to worksheet name, so when target folder name is more than the import wont work

[maruthi]

In the video you said you are adding to existing folder, how come a new folder is created?

[mohammadbhuiyan]

While i was doing the same way, it asked app code? where I can get the appcode?

[hienhuynhxuan]

Hi there,
I have a case where test cases have more than 200 steps and to execute state select takes a long time.
Batch importing from excel can improve that.
Can anyone tell me how to update status for multiple test cases at the same time by importing from excel to qtest? Is there any suggestion?
Thank you so much for your attention and participation. I am very honored for that.

[avinashpagunta]

How can we mention sub folders also while uploading as we want the tests to be uploaded to different folders not just on the main project folder.

[bediatahan]

Hi there, I want to embeded some knowledges from excel to SAP GUI. How can I do? For example I want to create user on GUI but
it will do from excel automatically with tricentis.