Azure DevOps - Lesson 09 | Bulk Upload Work Items from Excel | Establish Links | Import Test Cases

Azure DevOps Total 30+ Lessons Playlist

Bulk Upload of Epics, Features, Use Cases, Bugs, Tasks from Excel sheet to Azure DevOps along with the Attachments and Establish links! I am going to teach topics which most of the people not aware of Azure DevOps Excel Add-in

- Prerequisites to install TEAMS Excel Add-in
- Import work items, as flat list
- Import work items, as tree list
- Upload Use Cases/Requirements from excel
- Upload Test Cases and Bugs from excel sheet
- Upload Tasks from excel sheet to Azure DevOps
- Establish links between work items while uploading from excel sheet to Azure DevOps
- Add attachments/links during bulk upload of work items from excel to Azure DevOps
- Add Column Options to populate diff fields
___________________________________________________________________________
References:

Playlist of TRICENTIS Tosca SAP Automation:

Playlist of TRICENTIS Tosca 16.0 Automation Tutorial:

Playlist of Postman Automation Tool concepts:

Playlist of Katalon Automation Tool concepts:

Playlist of TestProject Automation Tool Concepts:

Playlist of YouTube Videos on Tosca Automation Specialist Level 1 & 2 concepts:

Playlist of YouTube Videos on Tosca Automation Engineer Level 1 concepts:

Azure DevOps Total 30+ Lessons Playlist:

[efuayeakintoye]

Still very useful 2 years later! Thanks for taking your time to explain this.

[suryanarayanareddyg]

It's amazing. Appreciate your knowledge of the concepts

[sushilpatil]

Thanks a lot Ravikant, this is really useful and you explained it smoothly.

[kasuvenkateswarareddy]

Very useful session. Thank you for your time.

[shamstabrez]

ravi bhai apke videos bht zbrdst h y dont u upload the entire series on azure devops lengthy lectures more than ur videos ur experiences will give the benefits to the community

[NearImmortal]

It is a very good explanation! Thank you. However, what is the difference between 'Tree Level' and 'Child Level'?

[rakeshmahakud]

This is a master piece, solved my problem

[YashpalSingh-nfrm]

this session is really very helpful thank you soo much brother!!!!

[sridharpatnayak]

Excellent., Helped a lot for me... Thank You

[Cv_RTX]

Hi,
This Tutorial is Very Useful, If Possible can you Please Demonstrate the same using SharePoint List instead of Excel using PowerAutomate.

[cliffordm]

Thank You Ravikanth...You explained very well.. Do we have any other options to import test steps to Azure DevOps.

[Test-hg]

Hi Ravi. how do i add user stories in bulk to features which are already created in ADO

[lipsamohanty]

Can we add related links in the same way as we added features (39.51 )??

[surekhaverma]

Can we utilize bulk upload feature in cloud version of ADO as well ?

[priya-fhyl]

Very useful and explanative the info I was looking for test case upload but only drawback as you mentioned is having to use Grid view for adding steps... Request you to share info on different link types and how to use them if possible

[soumyal]

Do you know how to bulk upload the same attachment to multiple work items at the same time?

[venkat]

Hi Sir, Is it possible to migrate a project to different organization in Azure Devops?

[RahulDoshi-py]

Excellent!! I have few queries. How can I connect with you?

[ladysicka]

Hello, when I export test cases from Azure DevOps Test Plan, result is all in one column. Do you know why it happens? Thanks!

[mannapotlapalli]

Hi Ravi,
I have one question.
Is it possible to Assigned Work items/Test plans to multiple to users?