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

Jira next gen - data export


I am trying to export tickets from the helpdesk with several fields but using XML, HTML nor CSV I am not successful. 


When using XML I get a web browser with multiple lines of text, which is not matching my ticket view and I cannot work with that. Using HTML I also get a web browser with a table, which is better but I cannot save it as excel to further work with the data. When using CSV, that brings me the closes to the best option however reported is not correctly transcribed and shows 'qm:67f919d3-80b5-4e23-8426-43c18e075885:e8a97b71-7c4a-49cb-884f-6f743e172f6e' and the text is also not correctly displayed eg. Employee´s.


Any ideas, please?




2 answers

Can anybody help here please?


When using the excel export I get the below error. Jira export issue.PNGJira export button.PNG

this is what i get when using the option open in google sheet. Once i select the authorize for and hit next, it brings me back to this point again and again. open in google sheet error.PNG

0 votes

Hello Erika,

Thank you for reaching out to Atlassian Community and for sharing the screenshots.

I tried to replicate the same issue on my test site, but it works normally when using the export to excel.

Did you install the Jira add-in on Excel?

Screen Shot 2020-10-15 at 13.59.04.png

Screen Shot 2020-10-15 at 14.05.27.png

Are you using the same account on Google Sheets and Jira? Would it be possible to test using incognito mode just to make sure you are logged off on all accounts and then log in using your Jira account?

Can you download the CSV file if you use the option Export > CSV?


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...

209 views 1 6
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