Export search results
Export search results
After performing a search, you can export your search results to another format like:
Microsoft Word
Microsoft Excel
CSV
Google Sheets
XML
Form data
Microsoft Word
To export to Word:
Select Export () at the top-right.
Select Export Word.
The export will include the Description, Comments, and all other work item data, not just the work item fields that are currently configured in All work.
We recommend that you export around 150 work items at a time.
CSV
To export all fields or currently visible fields as a CSV (comma-separated values) file:
Select Export () at the top-right.
Select either:
Export Excel CSV (all fields)
Export Excel CSV (current fields)
If you're using a filter:
Export Excel CSV (filter fields)
When you export search results as a CSV file, we recommend that you don’t upload the file to apps like Google Sheets or Microsoft Excel as the file may execute macros. These macros might be a security risk.
To open your search results in Google Sheets or Microsoft Excel, use the icons “Open in Microsoft Excel“ or “Open in Google Sheets“ above the search results.
Google Sheets
To open work items in Google Sheets:
Select the Open in Google Sheets icon above the search results
Log in and authorize Google Sheets to access your Jira data if you haven't done so already
The work items will open in a new spreadsheet in your browser.
If you’ve downloaded your search results as a CSV file, we recommend that you don’t upload the file to Google Sheets as this might be a security risk.
XML
To export to XML:
Select Export (ICON) at the top-right.
Select Export XML.
You can use the URL of the XML view in a Confluence Jira work item macro. However, you can also use the JQL or the URL of the work item search, which are easier to get.
To restrict which work item fields are returned in the XML export, specify the field parameter in your URL. For example, to include only the Work item key and Summary, add &field=key&field=summary to the URL. If field parameters are not specified, the XML output will include all work item fields. If one or more field parameters are specified, the XML output will contain only the Work item key plus your chosen fields.
XML export field parameters
title
<title>[TEST-4] This is a test</title>link
<link>https://extranet.atlassian.com:443/jira/browse/TEST-4</link>This is a 'permalink' to the work item. For links between work items, see * workitemlinks * (below).
project (or pid)
<project id="10330" key="TST">Test</project>description
<description>This is a detailed description of the work item.<description>environment
<environment>Sydney network<environment>key
<key id="22574">TEST-4</key>summary
<summary>This is a test<summary>type (or worktype)
<type id="3" iconUrl="https://extranet.atlassian.com:443/jira/images/icons/task.gif">Task</type>parent
<parent id="22620">TEST-5</parent>Only relevant if the work item is a sub-task.
priority
<priority id="4" iconUrl="https://extranet.atlassian.com:443/jira/images/icons/priority_minor.gif">Minor<priority>status
<status id="5" iconUrl="https://extranet.atlassian.com:443/jira/images/icons/status_resolved.gif">Resolved</status>resolution
<resolution id="1">Fixed</resolution>labels
<labels>
<label>focus</label>
<labels>assignee
<assignee username="jsmith">John Smith</assignee>reporter
<assignee username="jsmith">John Smith</assignee>security
<security id="10021">Private</security>Only relevant if a security level has been applied to the work item.
created
<created>Mon, 1 Sep 2008 17:30:03 -0500 (CDT)>/created>updated
<updated>Mon, 1 Sep 2008 17:30:03 -0500 (CDT)>/updated>resolved (or resolutiondate)
<resolved>Mon, 1 Sep 2008 17:30:03 -0500 (CDT)>/resolved>due (or duedate)
<due>Mon, 1 Sep 2008 17:30:03 -0500 (CDT)>/due>version (or versions)
<version>2.4.7</version>fixfor (or fixVersions)
<fixVersion>2.6</fixVersion>component (or components)
<component>Documentation</component>votes
<votes>1</votes>comments (or comment)
<comments>
<comment id="39270" author="jsmith" created="Tue, 24 Feb 2009 16:45:02 -0600 (CST)">this looks familiar</comment>
<comment id="39273" author="jbrown" created="Tue, 24 Feb 2009 16:48:16 -0600 (CST)">to me too</comment>
</comments>attachments (or attachment)
<attachments>
<attachment id="30318" name="Work item Navigator - Atlassian JIRA-2.png" size="16161" author="yoz" created="Mon, 9 Feb 2009 13:32:58 -0600 (CST)"/>
<attachment id="30323" name="Windows XP (with Firefox 3.0).jpg" size="5802" author="vbharara" created="Tue, 10 Feb 2009 00:30:11 -0600 (CST)"/>
</attachments>Only available if your administrator has enabled attachments.
timeoriginalestimate
<timeoriginalestimate seconds="600">10 minutes</timeoriginalestimate>Only available if your administrator has time tracking enabled.
timeestimate
<timeestimate seconds="300">5 minutes</timeestimate>Only available if your administrator has time tracking enabled.
timespent
<timespent seconds="300">5 minutes</timespent>Only available if your administrator has time tracking enabled.
aggregatetimeoriginalestimate
<aggregatetimeoriginalestimate seconds="36000">10 hours</aggregatetimeoriginalestimate>Aggregate time for the work items plus all of its sub-tasks. Only available if your administrator has time tracking enabled.
aggregatetimeestimate
<aggregatetimeremainingestimate seconds="18000">5 hours</aggregatetimeremainingestimate>Aggregate time for the work item plus all of its sub-tasks. Only available if your administrator has time tracking enabled.
aggregatetimespent
<aggregatetimespent seconds="18000">5 hours</aggregatetimespent>Aggregate time for the work item plus all of its sub-tasks. Only available if your administrator has time tracking enabled.
timetracking
<timeoriginalestimate seconds="600">10 minutes</timeoriginalestimate>
<timeestimate seconds="300">5 minutes</timeestimate>
<timespent seconds="300">5 minutes</timespent>
<aggregatetimeoriginalestimate seconds="36000">10 hours</aggregatetimeoriginalestimate>
<aggregatetimeremainingestimate seconds="18000">5 hours</aggregatetimeremainingestimate>
<aggregatetimespent seconds="18000">5 hours</aggregatetimespent>This is a convenient shorthand way of specifying all of the above six time tracking fields. Only available if your administrator has time tracking enabled.
workitemlinks
<workitemlinks>
<workitemlinktype id="10020">
<name>Duplicate</name>
<inwardlinks description="is duplicated by">
<workitemlink>
<workitemkey id="22477">INTSYS-1009</workitemkey>
</workitemlink>
</inwardlinks>
</workitemlinktype>
</workitemlinks>subtasks (or subtask)
<subtasks>
<subtask id="22623">TEST-8</subtask>
</subtasks>customfield_xxxxx
<customfields>
<customfield id="customfield_10112" key="com.atlassian.jira.plugin.system.customfieldtypes:select">
<customfieldname>Department</customfieldname>
<customfieldvalues>
<customfieldvalue>Adminstration</customfieldvalue>
</customfieldvalues>
</customfield>
</customfields>"xxxxx" is the id of a given custom field e.g. this output is the result of specifying &field=customfield_10112
allcustom
<customfields>
<customfield id="customfield_10112" key="com.atlassian.jira.plugin.system.customfieldtypes:select">
<customfieldname>Department</customfieldname>
<customfieldvalues>
<customfieldvalue>Adminstration</customfieldvalue>
</customfieldvalues>
</customfield>
<customfield id="customfield_10111" key="com.atlassian.jira.plugin.system.customfieldtypes:select">
<customfieldname>Expenditure Type</customfieldname>
<customfieldvalues>
<customfieldvalue>Operating</customfieldvalue>
</customfieldvalues>
</customfield>
</customfields>Form data
To export form data:
Select Export () at the top-right.
Select Export XLSX (form data).
Select the project that contains the form you want to see data for.
Select a form.
Select Export.
The XLSX file will include all of the responses from your selected form attached to work items from your search. Your file will also include the values of any Jira fields you selected as columns.
Work items from your search that don’t have the selected form attached will not be included in the export. Learn more about forms in Jira Service Management.
Print search results
You can quickly search for and print your work items in Jira to populate physical task boards and set visual reminders for tasks to be completed, boosting the overall team’s performance and efficiency in tracking work. You can opt to choose your search results as a PDF or on your drive as well.
To print your search results:
Select Export () at the top-right.
Select Print list or Print details.
Print list will let you navigate through your search results easily, while Print details will give you a more detailed view of your work items.
Was this helpful?