DP DeskPrintly
Events & Projects

Free Project Timeline & Gantt Chart Template (Google Sheets)

Visual Gantt-style weekly timeline powered by conditional formatting and task completion percentages.

Ready-to-Use Google Sheets Workbook
Private copy in your Google Drive • Compatible with Excel (.xlsx)
Make a Free Copy in Google Sheets →
Included Columns Structure
Task IDPhaseTask NameOwnerStart DateEnd DateDuration (Days)% Complete
Auto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / Entry
Ad Slot (In-Content Responsive Ad)

How to Set Up This Template

  1. Set your Project Start Date in the header cell.
  2. Enter tasks, owners, and start/end dates; the horizontal timeline bars highlight automatically.

Built-In Formulas Explained

  • NETWORKDAYS

    Calculates working business days between start and end dates, excluding weekends.

Frequently Asked Questions

Does this require any paid Google Workspace add-ons?

No, it uses 100% native Google Sheets formulas and conditional formatting.