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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Export Reporter Email Addresses?


I am looking to create an external Customer Satisfaction Survey to send to anyone who reported an issue during the previous quarter.  I can write the JQL to select the relevant issues, but in the Reporter field all I get is their name.  I don't see any columns with their email address in them.

I believe I can copy and paste from the Customers report but that is clunky and would require matching up email addresses with names, etc.

Is there a way to export the Reporter email address directly?

2 answers

I just discovered a good solution for this, if you use Google Sheets. From, this Google Sheets plugin is referenced:

When you connect and query, there's two great features:

  1. You can not only select the fields, it has access to some related record fields. I was able to select Creator.emailAddress (see below). This was superb as some of my reporters are users, not just portal customers, and this reference got the emails for all of them.
  2. You can also select how many records you want to retrieve. This gets past the issue export limit of 1000 records (this is how I found this post originally).


 Jira Issues Plugin - Google Sheets.png

@Jon Karnofsky 

Great, that's great. It helped me a lot. Thanks for sharing it with us.

Like Jon Karnofsky likes this

The solution proposed by Jon is also available for people using Microsoft Excel, using the free official Excel add-on Jira Cloud for Excel (official) | Atlassian Marketplace

Everything looks and works very similar to the post above. Thanks to all involved, great solution!

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events