Export list of Projects

[Karl Rothenberg]

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. 

[Aron Gombas _Midori_]

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.)

[Florian Bonniec]

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