Exporting the results of JQL query

[cpotti]

Hi

I have created a filter of my JQL query. I want to export the results of the filter to an excel . How to do it from JIRA automatically

[Ollie Guan]

Hi @cpotti,

Try excel- > data -> to create a new web query

After adding the Jira data source, you can refresh it dynamically to Excel

[cpotti]

Hi

I am able to export the results by clicking the export button (export it in CSV (Export -> CSV) in JIRA. But I don't want to manually go and click the export button. Can it be done automatically that is  just getting the filter results getting populated in excel?

[Walid Djama]

Hi, 

When you write your JQL query, you are able to export it in CSV (Export -> CSV).

[Ollie Guan]

Hi @cpotti,

As far as I know, these are two separate operations

1. Query the results

2. Export to Excel

However, you can send the query results to yourself automatically through the subscription function