ProjectSheet for Excel - Project Planning in Spreadsheet
Plan and Track your Project with WBS breakdown and Gantt chart
This free Excel add-in software is more powerful than a project template with cell formulas. It helps you to create and modify a project schedule with WBS breakdown and visual Gantt chart when you enter project data and use the functions in the side panel. You can customize the schedule's layout and data in the spreadsheet to your own needs, including the use of cell formulas.
The optional Pro version with dynamic planning features like task dependencies and critical path scheduling is available after sign-in with your Microsoft account and registration. You can try it with a free trial of 10 days without any obligation.
The add-in can be inserted in Excel online in a web browser and in Excel on a Windows or Mac PC.
Excel online is available as free Office.com with a limited storage of 5 gigabyte.
Install from Microsoft AppSource
Quick tour of free add-in [2:56]
Quick tour of Pro add-in [3:51]
Project schedule in Gantt chart
At first the add-in creates a sheet with columns to enter tasks and a Gantt chart to view them and a sheet with information on project level. The dates for starting and finishing a task can be entered in the spreadsheet but also with a date picker in the task pane.
Start and finish dates appear as a bar in the Gantt chart. The start date and the time span of the Gantt timescale can be changed to view the entire project or parts of it in more detail.
Work Breakdown Structure
The tasks can be put in a hierarchical WBS by indenting them. They get a WBS code accordingly. Summary tasks can be collapsed/expanded for a better overview. Summary tasks in the WBS receive start and finish dates from their sub-tasks.
Progress tracking with Colors
During project execution you can enter progress as a percentage to each task. The percentage can be entered in the spreadsheet but also with a slider in the task pane. 100% completed tasks can be filtered out. Progress of summary tasks are calculated from their sub tasks. Optional colors in the schedule table or Gantt chart indicate progress and delay.
Pro version with Critical path method, Resource assignment and Cost calculation
The Pro version includes critical path scheduling based on task duration and task dependencies, taking working hours and non-working holidays into account.
Resources are kept in a separate worksheet and can be assigned to tasks. A resource can be work or material. Costs are calculated based on resource rate and work hours.
In-app the Pro license per account is available for €24/year using PayPal without subscription or direct debits. The price per domain is €120/year.