Agile Central: Excel - How to export Defects along with their User Stories

Document ID : KB000101637
Last Modified Date : 15/06/2018
Show Technical Document Details
How can we use the Excel add-in to export only Defects that are connected with User Stories along with their User Stories?
The Defect field that holds the User Story reference is: "Requirement". 

If exported as-is , it will export the User Story's Name
This is an example of filtering defects that are linked with user stories , then exporting the user stories' names:
User-added image

To export the User Story FormattedID, you can use this query:
User-added image
Additional Information:
More information on the Excel Add-in:

Excel Add-in's installation guide:

Additional Knowledge Articles on the Excel Add-in: