'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can the Azure DevOps Excel Add-In Add or Delete Tasks?
Question details
Users want to know if they can use the Azure DevOps Excel add-in to directly add or delete tasks and manage hierarchical work items.
- Product
- Azure DevOps Excel Add-in
- Device & OS
- not provided
- Scenario
- Managing Azure DevOps hierarchical work items such as epics, features, and tasks via an Excel spreadsheet.
- Observed behavior
- Users attempt to add or delete tasks directly in Excel using the add-in, but discover that the tool primarily supports reading and updating existing items rather than full creation and deletion.
Ensure you are connected to your Azure DevOps project and have the appropriate project permissions to modify or import work items.
Understand Add-in Limitations and Use CSV or Web Portal
Directly adding or deleting tasks via the Excel add-in is restricted to maintain hierarchy integrity; use alternative methods like CSV imports or the web portal instead.
The standard Azure DevOps Excel add-in is designed primarily to read and update existing work items. Directly adding or deleting hierarchical tasks (like epics, features, and tasks) from Excel is generally not supported due to strict work-item hierarchy and data-integrity requirements.
To effectively add new items or delete existing ones, you should utilize the bulk CSV import feature or manage the items directly within the Azure DevOps web interface.
Use the Azure DevOps Excel add-in to pull existing work items into your spreadsheet, modify standard fields such as status or assigned user, and click 'Publish' in the Team ribbon to sync updates.
Prepare a CSV file containing your new epics, features, and tasks with the correct parent-child ID mapping, then navigate to your Azure DevOps web portal Boards section to import the CSV.
Since deletions cannot be pushed from Excel, log into your Azure DevOps web interface, locate the specific work item in your backlog or board, click the three-dot action menu, and select 'Delete'.
Manage Your CSV Data Effortlessly with WPS Office
While managing Azure DevOps work items requires specific web portals or CSV uploads, you can use WPS Spreadsheet as a fast, lightweight, and completely free alternative to Microsoft Excel for preparing and editing your DevOps import files.
- 1. Download WPS Office: Download and install WPS Office for free from the official WPS website.
- 2. Prepare your DevOps data: Open WPS Spreadsheet and structure your epics, features, and tasks using columns required by Azure DevOps.
- 3. Save and import: Save your spreadsheet as a .csv file and upload it directly to the Azure DevOps web portal.
Frequently Asked Questions
Why can't I delete Azure DevOps tasks directly in Excel?
The Azure DevOps Excel add-in restricts task deletion to prevent accidental data loss and to maintain the integrity of complex parent-child work item hierarchies. All deletions must be processed directly in the Azure DevOps web portal.
Can I use the 'Add Tree Level' button to create child tasks?
The 'Add Tree Level' and 'Add Child' features in the Excel Team ribbon allow you to modify existing hierarchies by adding new rows. However, you must ensure all required fields are accurately filled out before publishing. For creating entirely new complex hierarchies, a CSV import is often more reliable.
Is there an alternative way to bulk upload tasks to Azure DevOps?
Yes, you can structure your epics, features, and tasks in a CSV file and use the Azure DevOps web portal's native import feature. This is the recommended method for creating new hierarchical work items in a single operation.
