With Spira (all editions) version v4.0+ this is possible with Custom Reports and using ODATA with SpiraPlan version 6.9+. To achieve this with Custom Reports, you will need to create a new report.
For Excel format of the report please follow below instructions:
1. Go to Administration > Edit Reports and create a custom report.
2. Make sure Excel is listed and selected as one of the output formats supported
3. Click Add New Custom Section
![](/Support/Attachment/144244.aspx)
4. In the custom section dialog box add the Incidents query:
![](/Support/Attachment/144245.aspx)
5. By default, it generates ESQL query to display all the Incidents for the Active Product:
SELECT value R FROM SpiraTestEntities.R_Incidents AS R WHERE R.PROJECT_ID = ${ProjectId}
6. To display ALL the incidents that recorded in the system, replace WHERE clause so the query to look like:
SELECT value R FROM SpiraTestEntities.R_Incidents AS R WHERE R.is_deleted = FALSE
7. Click on Create Default Template
8. Save the report.
For getting the same with ODATA (SpiraPlan 6.9+) please follow below instructions:
1. Connect to the ODATA Feed as described here
2. Select Incidents from the listed items at the left
![](/Support/Attachment/144248.aspx)
3. Click Transform before load the data
4. The column Project_ID displays all the Products under the specified URL
![](/Support/Attachment/144249.aspx)
5. You can filter by Project_IS_ACTIVE to display only active Product’s Incidents select only “TRUE”
![](/Support/Attachment/144250.aspx)
6. Remove columns upon need and then click Close & Load
It may take up to 30 seconds (depending on the number of Incidents and connection speed) to load the items into Excel