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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • 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

empty excel when we export csv with current fields

Hi All,

    When I am trying to export to csv file with current fields, it gives empty excel file. How to resolve the issue.

 

Regards,

Suma

2 answers

0 votes
Jack Community Leader Dec 06, 2020

I have never experienced this. One thing you might consider is to try the excel or google sheets icons at the top of the filtered list. Also, consider the Excel addon extension and run your JQL directly from excel. 

Hi Jack,

    I do not see any option of adding Excel as add on on the filetered list.

 

Regards,
SUma

Jack Community Leader Dec 07, 2020

Here is an image showing where you should see the option to export to Excel or Sheets. 
E2DD7490-0433-441B-8EE6-C603C9559242.jpeg

Hi Jack,

     May be the  Jira version which we are using is the older one. So not able to see that option.

excel.PNG

Jack Community Leader Dec 07, 2020

Look into the Excel extension- /jira-cloud-for-excel-official 

Hi Jack,

    Thank you for the info.

 

Regards,
Suma

Hi @Suma Kustagi 

What version of Excel are you using? 

After Microsoft made a change a while ago to protect against downloaded internet files, CSV files could open as blank/empty in Excel 2016 and earlier.  The suggested fix is to:

  • Select a download location other than the default MyDownloads folder, ensuring that you trust the location, and download the CSV file there.
  • Open Excel (without a file) and change the Options to add your download location: Options > Trust Center > Trust Center Settings > Trusted Locations
  • Save and exit Excel
  • Now try to open the CSV file again

Please note that if your enterprise manages your Office tool settings you may not be able to solve this without your own support team's assistance.

Best regards,

Bill

Hi Bill,

    Version of the Excel is 2016. I do not have option to change the trusted Location by default its getting downloaded to Downloads folder. Any other option??

 

Regards,
Suma

Hi,

If you change your browser settings you can change the default location or change it to prompt you for a location for each save.

__Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,072 views 8 28
Join discussion

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