Is there an easy way or a plugin to import test plans/test cases from QTest to Azure Devops?

Question

I just wanted to know if there's a plugin/tool in ADO that imports test cases/Test plans easily from QTest to ADO.

We are looking for different options to move away from QTest. One option we have is to explore ADO to see if that's a best tool for us. The first step is to determine whether we can migrate all of our test case/plan repository in QTest over to ADO. I looked through all the available documentation to import test cases using csv and excel. But they both require a lot of manual work and it seems a cumbersome task as we have more than 10000 test cases in QTest. See below for more explanation. Please suggest if there's a better tool that can map fields between QTest and ADO for a smoother import.

Method 1: https://learn.microsoft.com/en-gb/azure/devops/boards/backlogs/office/bulk-add-modify-work-items-excel?view=azure-devops&viewFallbackFrom=vsts&tabs=cmmi-process

• Looks like there's a limitation for importing test steps for the test cases. I don't see a way to import test steps. Please correct me if I am wrong.
• Also, when I try to create a new query list in the excel, I get the following error.

Method 2: https://learn.microsoft.com/en-gb/azure/devops/boards/queries/import-work-items-from-csv?view=azure-devops

• All the test cases in our QTest were arranged in folders/subfolders (Modules/submodules). I guess we can mimic that in ADO by creating Test plan > Test Suite structure. Please suggest if there's a better way to maintain test cases in a folder structure in ADO.
• The test cases exported to Excel from our QTest can be used to import in ADO but it requires a lot of modifications as it is not in a format that ADO supports. There are also lot of limitations like importing attachments, preconditions and maintaining the same folder structure.
• To modify QTest Excel file, we need to change the header names which is fairly simple but importing the file as it is into ADO causes the first test step to truncate because ADO reads the test steps for each test case starting the row following the test case title.

For example see the attachment. Please suggest if there's an easy way to modify the csv file.

Answer 1

Hi MJPR,

The questions of Azure devops is beyond our support, and it is not supported in Microsoft Q&A forum. We recommend you could go to stack overflow with azure-devops or developer community, the community members will provide better support.

Thank you for understanding.

Best Regards,
Dylan

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our **documentation to enable e-mail notifications if you want to receive the related email notification for this thread.**