Import Test Cases from Excel to VSTS RRS feed

  • Question

  • Hi Team

    I am trying to Import Test cases from excel to VS Server using Excel Add-ins, I am able to do this successfully for test case having only one step but when it comes to multi steps in on Test case they are getting uploaded to single step in Microsoft test Manager.

    Please let me know how would I be able to do this.

    I am using Microsoft Test Manager 2013


    • Moved by Tingting MO Wednesday, February 8, 2017 6:41 AM
    Tuesday, February 7, 2017 3:06 PM

All replies

  • Hi!

    Excel Add-n does not support test cases. You have to use Web Access Test section, switch it to grid view and copy past from excel (Q:  Can I copy test cases and test steps from an existing Excel worksheet?):  https://www.visualstudio.com/en-us/docs/test/manual-exploratory-testing/getting-started/create-test-cases

    Tuesday, February 7, 2017 4:40 PM
  • Hi Alex

    Thanks for the answer, but I am looking for a solution to export test case using excel and by using Grid method we can only saved 200 line at a time. I have tried Test Migrator plus but it didn't work correctly and get hanged up while I am trying to run it. Is there any solution apart from these to migrate test case from Excel or HP ALM to TFS which is a freeware ?

    Thanks in Advance

    Wednesday, February 8, 2017 6:45 AM
  • You may install Visual Studio 2012 and try that http://tcmimport.codeplex.com/
    Wednesday, February 8, 2017 8:13 AM