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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Reports in Jira

We have few URL fields in Jira. We want to have them in Excel or any other report like Ticket number must be in Y axis and the All the URL fields as columns.

If the URL field is empty then it should give NO and if the field have value in it then report must be filled with YES... No worries even if it gives different notation other than Yes or NO.

Attached screen shot named Excel Yes NO for your reference.


And after that when i click on issue I should see the following Screenshot named "Issue URL details".


We have both Jira & Confluence linked. We are happy to have confluence reports for this or any JIRA addon is fine for us.

Please help us in this regard.



MadhuExcel with YES NO.pngIssue URL Details .png


so... you have a bunch of custom fields like BRS_URL, AN1000_URL... and so on.

Would it do anything for you if you had to run a JQL to retrieve the issues you want, visualize only those URL custom fields and manually export that as a CSV. 

You could then open that in excel no problem and play around with the format.

To automate this process you could maybe use automation for jira and use a CRON expression to define when are you going to:

  • run your JQL
  • send an email with the results using a pregenerated template (you could build your CSV in the body of the email so you could then copy/paste in a new file and then open it with excel)

This might not be the exact solution you're looking for but I hope it can get you going while you find a more permanent solution :)

I know there are a ton of Jira plugins that allow you to export different things with different formats but I don't know the specifics, you'll have to research those or wait for someone who has actually used one of those and can elaborate on it. Best of luck.

Hi @Madhu mullangi ,

It would need customization work but it looks possible with Better Excel Exporter.
As Iago said, you would need to run a JQL first that would collect the list of issues  in Issue Navigator that you want to export. Since you need conditional formatting and a custom layout in your output Excel, you would need to modify the template that is used for exporting.

You can find pointers on how to do it in the documentation.

If you need help, feel free to open a ticket, as we are happy to assist with your requirement.

(Please note that Better Excel Exporter is a supported and paid app and I'm part of the team developing it.)

Like Iago Docando likes this

Hi @Iago Docando @Levente Szabo _Midori_  Thanks for your inputs.

I am aware of Better Excel Exporter. Without better excel exporter we will not have such export options in Automation for Jira.

I am not sure that will Better Excel Exporter provides an option to get YES or NO values in the excel.

Using Better Excel exporter we can schedule a report on a timely basis where the files gets added in the Particular location.

Instead of that is there any option to add Report in a dashboard where the report refresh regularly, So we can see the only report we want.

This are just my thoughts, Please let me know your points.

Once again thanks for spending your valuable time here.




Like Iago Docando likes this

I'll leave it to @Levente Szabo _Midori_  at this point, since he's one of the developers of the app you're using and I haven't tried it myself.

Just know that I took a quick glance at the documentation he pointed out and it seems you have everything you need to get your custom excel. The dashboard object approach... I'm not so sure.

I hope everything works out for you :)

The Yes, No values is the smaller challenge here. I'm not a developer, but I think that can be solved even without scripting, with an in IF statement.

What's more challenging is how to display the individual issues on separate worksheets. I believe creating worksheets dynamically is not possible, but if you are interested please open a ticket, so one of the support engineers can give you a definitive answer or an alternative solution. 


Log in or Sign up to comment