Exporting JIRA reports from Local Excel

Question

Hi ,

I want to use MS Excel in local machine to extract JIRA reports by using macros. Is it possble to do so ?

Thanks in advance!!

Debankur Ghosh_gl0zf1 · Answer

Thanks @Nic Brough -Adaptavist- for the suggestion. I will definitely try macros to call the REST  API in JIRA.

Nic Brough -Adaptavist- · Answer

Jira has a direct export to CSV which generates files Excel can read, but if you want to do the work in excel rather than use those, your macros should call the REST API in Jira to pull the data out of it.