This is for JIRA Data Center - We are entering into an effort to clean up and archive our JIRA projects. I need to take the list of all projects found in JIRA and export that list in its entirety to a spread sheet. Is there any easy way to do that? I'd like to pick and choose what information goes into the columns of my spread sheet.
Hi @Karl Rothenberg
The easy way to do it should be to run a SQL query on the db directly. Depending on the information you want to extract it may be more or less complex.
https://developer.atlassian.com/server/jira/platform/database-schema/
Ex for all project
select * from project.
Regards
The Better Excel Exporter has a customizable export template "project-export.xlsx" that produces a spreadsheet like this:
See: https://midori-global.com/products/better-excel-exporter-for-jira/server/export-samples/jira-other-excel-reports
(Discl. it's a paid and supported app developed by our team.)
It looks like you're new here. Sign in or register to get started.
