How to upload excel gantt chart to JIRA page and synchronize it with excel on sharepoint

Question

I created an excel project schedule (simple gantt chart)

I uploaded it on Sharepoint

I want to upload the same chart on Jira and synchronize it with the excel on Sharepoint. So whenever I make any changes in the excel the table in Jira page will also update itself.

Anna-BigPicture · Answer

Hi @Ayxan Mamedoff 
@Kit Friend mentioned about BigGantt. Let me present this tool ina nutshell. The plugin not only visualizes Jira data but also supports project planning, managing, and tracking. Below you can find a brief description of the main functionalities.

* Adjustable WBS - you can automatically create a no-limited number of WBS levels. Task Structure can be created based on both task attributes (e.g., Epic link, Component, Version, Sprint) as well as links.
* Automatic project scheduling based on sub-box duration or tasks dependencies
* Measurable project progress on a single task level but also on a project or its phases level, the plugin gives you the possibility to aggregate data of statuses, progress, and time tracking.
* Possibility to visualize and add dependencies between various project tasks
* Scenario mode - explore and compare various plans, schedule alternatives based on changing conditions, and find the best solution.

BigGantt is bi-directional synchronized with Jira.

Moreover, with BigTemplate App you can unlock import features.

In case of further questions, just let me know in this thread.

Kit Friend_pvmg27 · Answer

You won't be able to do this @Ayxan Mamedoff  - the line items need to match up to tickets in Jira somehow and the whole exercise will end up pretty horrendous.

Best option is to look at a cost effective Gantt Chart option in Jira which you can then extract to excel if absolutely needed (any particular reason you can't just keep things in Jira?).

BigGantt from Software Plant is probably the most popular option: https://softwareplant.com/biggantt/

Also worth exploring: https://almworks.com/gantt/overview.html