X
28Jan

Bulk Export Import Test Cases to Azure DevOps Test Plans using CSV file

As a user of Azure DevOps Test Plans or TFS Test Management for manual testing, from a long time everyone including me had a wish, that copy of test cases from excel or csv file along with test steps to Azure DevOps/TFS should be provided. Now that wait is over, Microsoft has recently announced this most requested feature in Azure DevOps world Bulk Export Import Test Cases to Azure DevOps Test Plans using CSV file. Using this option, you can export the existing test cases to Excel CSV file, make changes to the CSV file and then import the file back into the suite. Not only that you can bulk add new test cases along with steps and expected results. Let’s see how to use this feature.

1. Once you log into the Azure DevOps project go to Test Plans and choose one of the test plans or create a new one. Post that when you open the plan you can see 3 tabs “Define”, “Execute” and “Charts”. Under Define tab you will see up and down arrows, that is import and export options.

21

 

2. Create a csv file and add the required column names like below. The column names are mandatory fields required to import test cases.

22

 

3. Once the columns are defined, now add the test cases along with steps and expected results and you define other field values. As shown in the below image the ID column should be left blank, the Area path should match to the project Area Paths and to assign the testcase to users, you can either use email-id or username

23

 

4. Now we are ready to import the 2 test cases. Go to the test plan E2E Plan and click on Module 1 test suite. In Define tab click on “import test case from CSV” (up arrow) option.

24

 

5. Click on Choose file, then select the “Test Cases.csv” file and click on open.

25

6. Finally clock on “Import” button to create the new test cases

26

 

7. Upon successful verification the test cases will be imported as shown below. You will see message on how many test cases created or updated and in Define tab you can see the test cases being created. Since 2 new test cases were import the message shows 0 test cases updated and 2 test cases created.

27

 

8. To export the test case from the suite, click on “Export test cases to CSV” (down arrow) option and the csv file will be downloaded to your machine.

28

 

9. Open the excel file to check the details. The file name will be Test Plan + Suite name, ID column will have the work item ID and “Assigned To” has the correct user even though you used two different option username and email-ID, it is parsed correctly

29

 

10. You can import hundreds of test cases easily; I have tested for more the 2 thousand test cases and it was imported in 3-4 minutes.

30

You learnt how to import and export test cases along with step action, step expected and column details. You can also include custom fields in the CSV file, if any defined in the test case.

Related

How Microsoft Dynamics CRM workflow definitions are stored in the SQL Database

Microsoft Dynamics CRM, is one of the prominent offerings from the Microsoft Dynamics family of ERP ...

Read More >

Git Command line Options

Git is a free and open source distributed version control system designed to handle everything from ...

Read More >

Data Mining for Supply Chain Management

IntroductionMarket turbulence arising from factors such as rapid introduction and customization of p...

Read More >

Software Testing

vinay.ramamurthy

Read More >

Introducing Azure DevOps Earlier (VSTS)

Microsoft recently announced Azure DevOps and an evolution of Visual Studio Team Services (VSTS) whi...

Read More >

Extent Reports in Selenium CSharp (C#)

Reports play a fundamental role when it comes to TESTING. Tester can now  know the real-time r...

Read More >

Webinar-subscribe

Subscribe using the form below to get updates on our future webinars!!! We will ensure you to send u...

Read More >

Avoid These 14 Subject Line To Get A Prospect

A blog which highlights on email subject line that most people after reading gives up from opening t...

Read More >

Sonar Integration with TFS for Java Projects

 Sonar Integration with JAVA.1.Download sonar-3.7 and sonar-runner-2.3*** unzip folders and cop...

Read More >

Windows 8 Shortcut Keys -Useful

HotkeysPressing the Windows key and some specific keys can make you life easier. Here are some usefu...

Read More >

Share

Comments

I appreciate your hard work, I will keep visiting it.
7/22/2021 1:25:00 PM | Reply
It is a great post. Keep sharing such kind of useful information.
7/16/2021 5:16:49 PM | Reply
Olá estou realizando uma importação de caso de testes, porém quando vou fazer upload para inserir exibe a seguinte a seguinte mensagem: Double-quote not enclosed in double-quotes at line 2, col 1.Alguém sabe dizer qual o problema pode estar ocorrendo?
6/15/2021 4:40:14 AM | Reply
I've been importing test cases. However, I haven't found a format for importing additional fields such as parameters, or shared test steps. Has anyone come across a way to add them to the CSV file to import correctly?
5/21/2021 1:54:50 AM | Reply
Undertood how to import and export test cases.. Is there any way to include test status as well in the report....like passed or failed status after excution. I am looking for opitons where i could get the test result test case wise whetehr it has passed or failed after run in a excel or CSV format.
5/19/2021 2:30:40 PM | Reply
shared steps don't appear to import correctlythere is no place to import parameters
4/30/2021 12:52:42 AM | Reply

Post a Comment

Try DevOpSmartBoard Ultimate complete Azure DevOps End-to end reporting tool

Sign Up

  • Recent
  • Popular
  • Tag
Tags
Monthly Archive
Subscribe
Name

Text/HTML
Text/HTML
Contact Us
  • *
  • *