Export 'username' instead of 'Full Name' to Excel


When I export issues to Excel, the 'Full Name' gets exported instead of the 'Username'. Can I force the 'Username' to export instead of the 'Full Name'?

The reason why is because I re-import the exported spreadsheet back to JIRA and when I import with the 'Full Name', JIRA doesn't map to the username. JIRA thinks the users are new and creates new users.

How can I fix this?


5 answers

How many users do you have? Unfortunately the main ways I use to translate this are either through API or a simple Find and Replace if there aren't many users on my import.

I am interested in a solution to this problem as well.  The Username is much more meaningful than the Full Name.

There are a lot of people have the same full name, so username will helps us identify exactly.

Is there any update on this, pls?
I have the same problem and make us crazy when trying to make a report and there are alot of user having the same full name. 

Hope to hear from you soon.




Hi guys,

Is there any update pls. 
Hope you can make it asap.



Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,129 views 13 19
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot