> ## Content Index
> Fetch the complete content index at: https://www.techielass.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Bulk edit Azure DevOps work items using Excel
- URL: https://www.techielass.com/bulk-edit-azure-devops-work-items-using-excel/
- Published: 2023-04-18T07:01:56.000Z
- Updated: 2023-04-18T07:01:55.000Z
- Description: Let's take a look at how you can use Excel to update your Azure DevOps Board work items!
- Author: Sarah Lean
- Tags: Azure DevOps, DevOps

There are times when you need to do bulk edits of work items within [Azure DevOps Boards](https://www.techielass.com/what-are-azure-devops-boards). Excel supports adding work items, updating existing work items, adding links or attachments to multiple work items and much more.

### Prerequisites

- Install Microsoft Excel 2010 or later
- Install [Azure DevOps Office Integration 2019 (free)](https://visualstudio.microsoft.com/downloads/?ref=techielass.com#other-family)
- Be a member of the project you want to edit
- You should have permissions set to **Allow: View work items in this node** and **Edit work items in this node**
- If you want to add or modify work items, you should have **Stakeholder access or high**

### Setup

Once you have all the necessary prerequisites set up, it’s time to get started. 

- Open up Excel
- Click on Team on the top menu

![Azure DevOps plug in Excel](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2023/04/excelplugin.png)

Azure DevOps plug in Excel

You will see a lot of options greyed out. You need to connect the Excel plugin to your Azure DevOps environment. 

- Click on New List
- This will activate a pop up box asking to Connect to an Azure DevOps Server.
- Click on Servers
- Now click on Add
- Enter the URL of your Azure DevOps server
- Then click OK
- It will prompt you for authentication to the Azure DevOps server
- Now click on Close

![Connect to Azure DevOps within Excel](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2023/04/connectionsetup.png)

Connect to Azure DevOps within Excel

- The plugin will now pull in information about your Team Projects

### Make bulk changes

![Azure DevOps connection within Excel](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2023/04/connection-1.png)

Azure DevOps connection within Excel

- Select the relevant project and click on Connect
- You will be prompted regarding which items you want to pull from Azure DevOps Boards into Excel. You can either start a new list or pull in items from a query
- You can now start to make the modifications that you need to make
- Once you have made the changes you need, click on Publish within the Team tab
- If you refresh your Azure DevOps Boards view the changes you have made will now be available

### Conclusion

In conclusion, bulk editing Azure DevOps items using Excel can save everyone significant amounts of time and effort. By exporting the work items into an Excel sheet, users can quickly make changes to multiple items at once, and then easily import the changes back into Azure DevOps. This feature is especially helpful for larger projects with numerous work items that require frequent updates.