Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to export statistics for different projects Edited

Michael I'm New Here Jan 18, 2021

Hello everyone!


I am currently trying to make an excel export with statistics over multiple different projects in jira with xporter like:



My Issue Query in Jira: project = "project1" and project = "project2"


Is it somehow possible to distinguish different projects during export? Unfortunately i couldnt´ find any template or solution in the forum.


Thank you very much!




3 answers

0 votes
Stuart C Community Leader Jan 18, 2021

Hi @Michael 

There's a built-in Excel export feature that allows you to send whatever issue fields you like into an Excel or GSheet file.

If you go to issues and then advanced search you'll see the icons to click on and be guided through the process.

You'll need to install the add-on but once you do you can choose which fields you import and from which projects. It's definitely worth checking out!

@Stuart C , that is for Jira Cloud, isn't it? I think @Michael is referring to Server.

What you describe should be a fairly simple export with the mentioned custom fields exported to their columns.

What do you mean by "distinguish different projects during export"? What would be an example output that you would like to achieve?

0 votes
Michael I'm New Here Jan 19, 2021

Thanks for the quick response! @Levente Szabo _Midori_ @Stuart C !


Indeed, i am referring to jira server.

Example: I want to select every of ticket (issues) of specific projects like:

project = "Project A" AND project = "Project B" AND project = "Project C" (Now i see tickets of all projects, which i want to export for statistics)

Now i want the correct bug count, story count for each project in my export. It would be fairly easy to count tickets when i am exporting only one project but it should also work for multiple.

I have attached an example output.


Screen Shot 2021-01-19 at 13.32.09.png

Thank you!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Trello

📹 Favorite Trello templates

Hello Community!  My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...

73 views 4 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you