How to do it...

Now that we have the Azure DevOps Sever excel plugin installed, in this section we'll learn how to use it. 

Start by performing the following steps:

1. Launch Excel and start with a blank sheet. Navigate to the Team ribbon.   
2. Click on New List to connect to your project in TFS. 

1. If you are connecting to Azure DevOps Server from Excel for the first time, you will have to add your server details to the list of recognized servers. The steps for this are shown in the following screenshot:

1. Select the PartsUnlimited team project and click Connect:

1. When asked which type of work item list you want to create, choose Input list. An Input list gives you a blank template that is linked to your team project:

1. Your worksheet will now be bound to your team project as a flat list. What this means is that you can add work items to the team project from the worksheet or add work items to the worksheet from the team project. Fill out the details of the work items you want to add and their work item type. The Excel plugin defaults the list type to flat, but you can change it to a tree list if you wish. A tree list allows you to create and view hierarchically linked work items, like so:

1. Publish the changes by clicking the Publish button from the Team ribbon.