Export Forms spreadsheets in Jira Cloud

Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

When using Forms (Project settings > Request management > Forms), we can 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 

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 Attached Forms, 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 settingsRequest managementForms
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.

Just note that 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:

Last modified on Dec 25, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.