Free Gantt chart template (like MS Project) for Google sheets or Excel

Project scheduling without MS Project

If you need just a simple Gantt chart but do not want to buy MS Project why do use just Gogle Sheets or MS Excel?

All you need just a very simple free template.

There are no complex formulas and VBA scripts.

Copy the template from the link above to your Google Drive.

Set your start date in cell H1.

Fill your resources in the table G11:G15.

Fill you holidays in table C11:C15.

That’s all!

Enter ID and name of you task in columns A and B.

Select Resource from drop-down list in column G.

Enter number of days for the task in column D.

List all predecessor tasks in column C (separate by ,).

For the task without predecessors will be used the project start date you entered to cell H1.

For all other tasks the sheet will calculate start date as max of all predecessors’ last dates.

Last dates are calculated using task length in column D taking into account weekends and holidays you already entered in table C11:C15.

On 8th row select from right-click menu Insert row (Insert 1 above).

Copy formulas from columns E - H (select appropriate cell on row above and drag blue square at right bottom corner).

Add line in table G11:G15 and create custom formatting rule for it (select cell H3 and choose in menu Format -> Conditional formatting).