excelvisual-studio-2010azure-pipelinesmicrosoft-test-managerazure-pipelines-release-pipeline

How to Export and Import Test Cases from Visual Studio Team Services into MS Excel

I have a requirement to import the Excel Based Test Cases into VSTS and Export Test Cases from VSTS into MS Excel. VSTS(Not TFS)

Solution

  • You can use below way to export test cases from VSTS to MS excel:

    1. Define a query for the test case you want to export. Create new query for all test case -> specify Work Item Type = Test case.

      enter image description here

    2. Connect in MS excel. MS excel -> Team ribbon -> New List -> Servers -> add -> input VSTS URL(https://account.visualstudio.com) -> OK -> Close -> select a team project -> connect -> choose Query list -> select the query you just created -> OK.

      enter image description here

    Now all the test cases are export to MS excel. And you can click Choose Colums to add or remove displayed columns.

    enter image description here

    Import to VSTS: You can add new WIT in MS excel, and then click Publish to import new created WIT to VSTS.