TFS - Uploading and extracting work items in MS Excel from TFS.

Advanced Microsoft excel has made working on excel is simpler and lighter. You can extract all data from Team Foundation Server with out giving lot of efforts. Basically, excel is providing facility to link local excel to TFS, once server linked successfully you can fetch any data from server and you can also upload your excel made data in TFS.

Let’s understand the process by implementing TFS task upload scenario

Follow below mentioned steps and establish connection with TFS server.

1.       Open MS excel and go to Team in menu bar.

2.       Select New List option you will get the Pop up as below

3.       Put the TFS URL and connect to your team or project. You can find URL as below mentioned.

 

4.       Once TFS get connected you will get one more pop up saying ‘ select which type of item list you want to create’ as below

5.       Select Query list and browse query which is giving the result set you want to fetch.

Note : If you want to upload task create a query which is resulting items for your current project cycle. Accordingly, you need to modify the query further which will be visible in Query list browse option.

6.       You can create your custom queries by going TFS -> Work -> Queries -> My Queries.

7.       Once you will select the query and click on ok all resulted list will be fetched in local excel.

8.       Now if you want to add your work items, you can update excel after adding extra rows as below.

9.       If you done with writing task you can publish task by clicking on publish button. Same list will be uploaded on TFS server below your PBIs.

10.   If list not uploaded exact below of your PBI, you can simply just drag and drop items inside the PBI in TFS.