How to export Timeline view to Gnatt chart view

[Suman Saranu]

We set up Timeline view for our project, for better leadership visibility, we would like to export the same to Excel Gnatt chart view. How we  can achieve this ?

[Aron Gombas _Midori_]

You can export almost every custom field to Excel with the Better Excel Exporter. For the timeline view, I assume you use Date type custom fields. Those are definitely supported!

Here are few export examples with date values, parent-child relationship and epic links.

(Discl. it is a paid and supported app developed by our team. Free for 10 users.)

[David Nickell]

From within Excel you can execute Power Query Code to extract Work Items and Associated Work logs.  Whatever tool you use, it starts with REST API calls (you already have access to)

Assuming you were going to export a list of items anyway, you can make the Worklog endpoint call directly in excel using Power Query 

https://YOUR URL.atlassian.net/rest/api/3/issue/issueIdOrKey/worklog

Its the same code wether you run in Excel or Power BI.  You will need to do some pagination and some data formatting.  For example, durations are in seconds I believe.

In this example, I am using the data in Power BI