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:
- Launch Excel and start with a blank sheet. Navigate to the Team ribbon.
- Click on New List to connect to your project in TFS.
- 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:

- Select the PartsUnlimited team project and click Connect:
- When asked which type of work item list you want to create, choose Input list ...