Do you get the work items into Azure DevOps via Excel?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
<introEmbed
body={<>
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
Acknowledgements
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.