Is there a way to export a list of Projects in JIRA?

[Caitlin Bell]

I know where to view my list of Projects, but is there a way to easily export the list to an Excel/CSV file?

[Ravi Sagar _Sparxsys_]

Hi @Caitlin Bell 

You can use the Jira REST api to get the list of projects.

JIRA_URL/rest/api/latest/project

You will then get a json which you can convert to csv by going to https://json-csv.com/

I hope it helps.

Ravi 

[Fabian]

Thanks for the information. I really needed it. 

[Odin]

Hi @Ravi Sagar _Sparxsys_ ,

the call brings only the latest projects (not all of them) could you point to call that list all projects 

Thanks

[Daka Ayra]

Hi!
I would need this as well.

Thanks, @Ravi Sagar _Sparxsys_ !

[milan_shah]

Hi @Ravi Sagar _Sparxsys_ 

Best answer and no need for expensive plugins. thanks

[Gauri]

@Ravi Sagar _Sparxsys_ 

How can we get the most visited Project, most active users, etc in JIRA v6.3.11?

[Grayson Bishop _SAIC_]

The "latest" in the URI path refers to the API version- it does not filter the projects that are returned. See https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/. You could instead use /rest/api/2/project, since "2" is the current version. 

If you aren't seeing all projects it might be because the signed in user does not have the right permissions.

[Marcelo Correa]

@Ravi Sagar _Sparxsys_ , thanks for that! Worked like a charm!

Just had to then use something like https://data.page/json/csv to convert it to CSV. 

[Nguyen Phi Long]

Thanks @Ravi Sagar _Sparxsys_ 

It's really helpful for me.

Thanks.

[Levente Szabo _Midori_]

@Daka Ayra 

Another, simpler way of exporting Jira projects to Excel and creating relevant reports is by using the built-in template and export option of Better Excel Exporter. The options exist for both the Jira Data Center (Server) and Jira Cloud versions.

You can generate an Excel report of Jira projects like this in seconds:

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)

[Travis Howard]

Where does this export to? 

[Travis Howard]

I found it

[Leo Diaz _ DEISER]

Hi @Caitlin Bell 

I'm Leo from DEISER (Solution and Makertplace Partner)

Are you using Jira Data Center? If yes, have you tried Projectrak?
https://confluence.deiser.com/projectrak/8.1.1/export-to-excel-110953960.html 

With Projectrak you can export to excel your projects, also, you can create some script fields like "Date last updates" or "Number of issues", this is an example for "Number of issues":

package deiser.profields.scripts

import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.jql.builder.JqlQueryBuilder
import com.atlassian.jira.web.bean.PagerFilter


// Components
def searchService = ComponentAccessor.getOSGiComponentInstanceOfType(SearchService.class)
def jiraAuthenticationContext = ComponentAccessor.jiraAuthenticationContext

// Script variables
def loggedInUser = jiraAuthenticationContext.getLoggedInUser()

// Make JQL query
def query = JqlQueryBuilder.newBuilder()
        .where()
        .project(project.id).and()
        .buildQuery()

// Returns the issue count
return searchService.search(loggedInUser, query, PagerFilter.unlimitedFilter).results.size()

I hope it helps you!

Try Projectrak:
https://marketplace.atlassian.com/apps/1210816/projectrak-project-tracking-for-jira?hosting=datacenter&tab=overview 

Leo

[kimiya majd]

Hi, @Caitlin Bell 

When you have administration access you can export from Jira in optimizer plugin.

at the first, please download optimizer for Jira from Atlassian marketplace then add it to your Jira, so you can get any export you want.

here is 2 link that I know help you:

https://optimizer.forjira.com/

https://marketplace.atlassian.com/apps/1217194/optimizer-for-jira-cleaner-for-jira?hosting=cloud&tab=overview

[kimiya majd]

[Shailesh Dhawale]

@Ravi Sagar _Sparxsys_ Thank You!