Do you get the work items into Azure DevOps via Excel?

Initializing the Project - See how to get the work items into Azure DevOps via Excel:

• Open SSW Priorities Estimate Template in Excel

Figure: Find SSW Template - 'New | My templates... | SSW_Proposal-Project | SSWPrioritiesEstimateTemplate.xltx''

• Add the tasks and additional tasks into Release_XX sheet

Figure: Copy work items to Release_XX sheet

Note: The Project Management tasks will be calculated based on your tasks

• Create a new sheet and go to Team tab
• Click "New List" and choose your project

Figure: Find your project in the list

Figure: Choose 'Input list' to download the empty template

• Add the other useful columns e.g. Baseline Work, Remaining Work, Completed Work into Excel

Figure: Click 'Choose columns'

Figure: Select columns in the left list

• Copy work items (including the Project Management tasks) from Release_XX to the new sheet

Figure: Copy work items from Release_XX

• Click "Publish" button to upload the work items to TFS