nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Cloud for Excel, How can I copy an export to provide the same fields but use a separate filter?

Paul M. Brunner

I have a common sheet that I export my Jira data to use Jira Cloud for Excel. I would like to create a second tab that exports the same fields, but uses a different filter.

How can I copy over the field list and just point to a different filter? I am using many more fields than the default provided by the tool.

Accepted answers

All comments

John Funk

Hi Paul,

I am not sure that you can export a second filter to another tab in the same Excel worksheet, but here's how I would probably go about it.

1. Create your filter with the columns you want and then export that. I think you have already done this step. :-)

2. Edit that same filter to change your query and execute it to see your results. It should keep the same columns.

3. Then do a Save As on this filter and give this filter a new name.

4. Then export the results of this new filter (or just open in Excel).

5. Then cute the results of the latest filter in the new instance of Excel and past it in a separate tab in the original Excel worksheet that has the results of the first query.

I hope that works for you!

Paul M. Brunner

Hello John,

I tried that. It seems for me that moving over to a different workbook or tab and changing the filter resets it back to the default. For me the default has ~20 fields and what I need are ~46. That is a lot of data entry in a specific order.

John Funk

Create your filters first - and save each one before trying to export them. Then export each filter one at a time.

Paul M. Brunner

I tried that. I copied the tab I wanted as a reference over. At the time I copied the TAB the fields were reset.

Paul M. Brunner

My end goal is to have 1 excel file for all Jira extracts. Open this one file, update the data in it. This data is used as a data source for multiple excel power queries / pivots. I would like the instructions to go to this TAB and hit update.

One tab is driven to represent to backlog, a separate tab is to identify the stories in the current sprint and another is to measure grooming activities over multiple sprints. Each has its own filter to ensure the correct content is driven into the appropriate reports.

Case 1

1) In my workbook I have a TAB and the Jira Could for Excel has 46 fields.

2) In excel I copy a TAB. The moment I copy the TAB the fields are reset.

Case 2

1) I change the filter and the fields are retained, but this means it requires multiple workbooks to update.

Paul M. Brunner

Thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jira-cloud

ms-excel

google-sheets