How to use google sheets to export all fields directly from Jira

Question

Hi

I am using google sheets to export jira as it has a 5000 ticket level versus 1000 for Jira

However the default google sheets tool has no "all fields" option unlike Jira,

Have tried typing in the field names individually but google sheets returns field not found.

How does one retrieve all fields for all 5000 rows using google sheets?

T

Tom Lin_glz5xw · Answer

thx but if we were going to use a paid app it wouldn't be this one. We need to use google sheets so the question remains whether its possible and there is some bug with what is currently doing

Aron Gombas _Midori_ · Answer

The Better Excel Exporter app offers the export option called "non-empty fields":

It does what you wanted, and it will not export those fields that would be empty for all the work items in the spreadsheet. If your instance has a lot of unused fields, it will detect and skip the garbage.

Then, you can import the resulted XLSX file to Google Sheets!

(This paid and supported app is developed by our team. Free for 10 users!)

Tom Lin_glz5xw · Answer

team based - but does it matter? does google sheets have different functionality depending on this?