Azure Devops Board with Excel sheet | Add Epic / Feature / User story from excel | Devops-Office

In this video we have learnt that how we can create the Azure Devops work items from excel sheet. which tool we are in need to manage work items from excel ?
We can create epic / feature / story book / task and other related board work items from excel sheet. This is very helpful tool for all those who are looking to create work items from excel sheet first. We can add work items to a sprint and we can also assign and unassigned items to users.
In case you are looking to know that how to manage work items from board and how to create sprints, you may follow this video.

However there are some limitation, that we can n't with excel sheet.
We can not delete work items from excel sheet.
We can add delete work items from excel sheet.
We can not move work items from one project to other project
We can can change work item type to another work item, for example we can not convert and epic to pbi or pbi to feature.

[LearnEasy-oz]

You just made my life easier!! Amazing

[Turco_]

Thanks, Avin! I have a question: Is it possible to view the "Progress by all work items" column, which displays the percentage bar, in the Excel file? I added this column using the rollup option, but it doesn't show up when I export the query. I need to include all the backlog data in the Excel file to track the completion percentages of the features.

[joarinho]

Thank you very much Avin, so helpful and saved me so much time!

[harivignesh]

Really awesome work!!! I was browsing this all around the internet. Thank you for this, Avin!

[sathyakrishnakanthj]

Awesome explanation. Very detailed video and really helpful

[tarungowtham]

wow.... U made everything like a cakewalk... Please do some more advanced concepts on simplifying things in azure boards and dashboards.. Great work...

[AmbienteCorporativo-uxjm]

Hi Great Video, thanks. Qq, when I modify something in the excel sheet and then click "Publish" it does not do the change in azure devops and it just disapper from the excel sheet? How do I do to reflect the changes I am making in excel to Azure devops? Thanks!

[gowthamsambasivam]

Is that possible to add customize columns in the Excel?

[ravikumarkumawat]

Can you please tell how can we upload the 5 basic common tasks (like req understanding, test case creation, peer review etc) in all exisiting stories in one go

[sangimangi]

How to link multiple test cases id to story in ado ?

[anyrudy]

Hi, I am not able to find start date and end date columns for my project, task and milestones

[anyrudy]

Hi Sir, Can I import only those projects in excel that are assigned to me.. so that I can manage them easily?

[fjohnson]

Avin is there a way to copy work items from 1 project to another ?

[bhumikameyangbo]

Hi, how can I reverse this as in-- how can i get epic and its related links exported to Excel? Any videos you have please?

[anyrudy]

I am getting TF310002 error while loading azure server. It is not able to connect to the azure server

[jallabalaram]

is there any way to auto refresh this data ?

[saddamhussen]

After adding the URL not getting projects list

[anyrudy]

I am also not able to see the description of the milestones

[sxsaxena]

Vineet - how can you download User Stories with parent Features and Epics from ADO as an single excel download? thanks!

[anyrudy]

Hi, I am not able to find start date and end date columns for my project, task and milestones