How can I transform the data of projects, epics, issues and tasks into excel format and how can i automate that so that every new added data will be updated in real time without the need for a bookkeeper?
Welcome @MOUAZ !
It sounds like you're looking for an automation that exports JIRA information into Excel on a recurring basis.
I don't know a way to do that out of the box. Export once is built it, but not on a recurring basis.
A few quick searches found some options, though you would have to evaluate what would work best for your situation. Some solutions may require scripting/development, and some might require another product to provide the feature.
Examples:
https://stackoverflow.com/questions/44051289/export-data-from-jira-into-excel-dynamically
https://community.atlassian.com/t5/Jira-Service-Management/Automatically-export-data-from-a-JIRA-project-to-Excel/qaq-p/2555111
https://www.coupler.io/sources/jira
If this helped, please vote up.
thank you @efavreau
The links you have sent were really helpful
It looks like you're new here. Sign in or register to get started.