How to import test cases from Excel to VSTS/Azure DevOps

azure-devops migration testcase
S K picture S K · Mar 13, 2019 · Viewed 8.5k times · Source

I have a lot of test cases which are currently in Excel that I need to migrate those to VSTS/Azure DevOps. Can someone recommend me a good way to do that.

Answer

Shayki Abramczyk picture Shayki Abramczyk · Mar 13, 2019
  • Install Team Foundation Server Office® Integration (Excel Add-In)
  • Open Excel and go to Team Tab and then click on New List
  • Connect to your TFS
  • Choose Input List then click OK
  • Click on choose columns so we get all the necessary ones for creating test cases
  • The Work Item item is set to "All Work Item Types", change this to "Test Case"
  • Click Add Required and you should have about 8 columns, then click ok
  • Now you should see a slightly different excel worksheet. -Change the work item type on the first line to "Test Case" and it should auto-populate the defaults

Related questions

How can I push my existing Git repository to Team Foundation Service

Microsoft now has support for Git repositories on their Team Foundation Service. I have an account on Team Foundation Service, and I'd like to push my existing Git repository to a project there. Whenever I try to do searches, I …

Read More
Error TF30063: You are not authorized to access ... \DefaultCollection

I'm using TFS Preview (Team Foundation Service) with one of my projects with Visual Studio 2012. I'm also using an on-premises TFS server with most of my projects. When I use my on-premises TFS after using TFS preview and go back …

Read More
Visual Studio 2017 - Git failed with a fatal error

I am using Visual Studio 2017 Community Edition (CE), and I have signed into my Microsoft account and I am connected to VSTS. I can see all my projects and repositories, but when I attempt to pull/fetch/push any changes …

Read More