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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

172 views 1 17
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