Export Forms spreadsheets in Jira Cloud

Summary

Export form responses in Jira Service Management to a spreadsheet for easy search, sorting, and aggregation. Download responses from a single form or across multiple issues.

Solution

Export Individual Form Response

The below steps allow us to retrieve specific data from a form submission:

1. Go to the issue with the form you want to download.

2. Under AttachedForms, select the form.

3. Select Download XLSX from the ••• menu.

Simple Export of All Form Responses

We can export a spreadsheet of form responses by following the steps below:

1. Open your service project > Project settings > Request management > Forms

2. Locate the form > Click on the ••• dropdown menu > Select Export in XLSX.

A file with all responses that were submitted using the form will be downloaded.

NOTE: Only Project administrators are able to see the Export in XLSX option.

Advanced Export Forms Responses

We can also select specific issues and include Jira fields in the export. To do that, please follow the steps below:

1. Select Filters in the top bar > View all issues.

2. You can use either basic or advanced JQL search modes to define your search criteria.

3. Make sure you are under the List view.

4. In the Columns dropdown, 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 XLSX (form data).

6. A new screen will open and you can select the Project and the Form.

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

Export with API

Alternatively, we can use the following REST API endpoints:

• Forms Export