How to produce a JIRA report, preferable excel showing time spend on each task by assignee

Question

Need a report (xls) that includes the following:

Project

Assignee

Task

Time spend on task

Resolved/Pending/Reassigned

Thank you

Tarun Sapra · Answer

Sure, if it works for you, then please accept / upvote the answer. Thanks!

unknown · Answer

Thanks Tarun will try

Tarun Sapra · Answer

You can easily export the CSV and later save it as a xls file.

Current fields can be configured in the issue navigator that meet your criteria. "Timespent" field can be added in the issue navigator. and then use the export the CSV (current fields) option.