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

Issue ID and User ID exported auto.

While We are exporting the issue report Issue ID and User ID exported auto we don't need this.How to fix it?

issue id.JPG

1 answer

0 votes

Hello @Neeraj Kumar,

Welcome to Atlassian Community!

As per your screenshot, I believe you are using Jira Cloud for Excel, please, correct me if I'm wrong.

If that's the case, you can select the field you want to import directly on Excel. 

On Excel, on the Home tab, click on "Get Jira Data", and on the "Fields" tab you can select the fields that you want and those that you don’t want to appear.

Screen Shot 2021-01-04 at 11.13.10.png

Screen Shot 2021-01-04 at 11.15.45.png

If that's not the case, please let us know the steps and the options you are selecting so we can try to replicate the same issue here.


@Angélica Luz Thanks for reply.

I am using JIRA Service Management not JIRA.


While i am creating filter these fields get auto selected with Issue Key and User 

I don't want issue ID and User ID in exported data

Hi @Neeraj Kumar,

Testing on my local site, I exported to Google Sheets, Excel, HTML (current fields only) and it didn't show the issue id and user id. 

Can you please share with us what option you are using?

Are you creating this filter on Filter > Advanced issue search?

If possible, share a screenshot with us.

@Angélica Luz  We create a simple filter and export in excel CSV (current field) but both the field issue ID, Assignee ID is came in default .Export JSM.PNG

Thank you for the details, @Neeraj Kumar.

I restored the defaults on my site and I was able to replicate the same behavior.

The columns Assignee Id and Reporter Id will show on the export by default because it's what identifies the users along with their full name.

The Issue Id will show when the Key field is visible. For this, there is a feature request suggesting the ability to hide the column:

Please, click on vote and watch to receive updates about the feature.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

173 views 0 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