Form spreadsheets

ProForma lets you export a spreadsheet of form responses, making it easy to search, sort, or aggregate all of the responses you’ve received.  You can download a spreadsheet of a single form on an issue, or of all of the responses (across multiple issues) that have been submitted for that form.

Export Individual Form Response 

To export an XLSX spreadsheet of a single form response, navigate to the forms section of the relevant issue. Click on the ... dropdown menu and select Download XLSX.

Simple Export of All Form Responses 

To export a spreadsheet of form responses, go to Project Settings and select Forms.  Click on the …Button and select Responses (XLSX). An XLSX file with all responses that have been submitted for the form will be downloaded.

Export Responses with Jira Fields

You can also select specific issues and include Jira fields in the export:

1. Go to Project Settings and select Forms. 

2. Click on the …Button and select Responses with Jira fields.

3. You’ll be taken to the Advanced issue search screen where you can use JQL to filter down to the desired issues.

4. Select the columns you want to include. These will be the Jira fields that are included in the export.

   

5. Click on the Export option and select Export Forms (current fields).

   

   
   

6. A new screen will ask you to indicate the:

   1. Project

   2. Form

   3. Format (XLXS or JSON)

      

7. The export will include the selected Jira fields as well as the form fields for any issues in the original query that have form.

Export with API

Alternatively, you can also filter down to specific issues, select which ProForma fields to include, and include fields from the Jira issue in your spreadsheet by using the ProForma Export API.