Gantt Chart from Google Sheets

Paste a Google Sheets table, upload a CSV, or connect a live spreadsheet β€” and get a clean, shareable Gantt chart in seconds. Track planned vs actual progress, deadlines, dependencies, and who owns each task. No sign-up needed.

Free forever for CSV & paste Β· Premium adds live Google Sheets sync, auto-refresh, and snapshots

See it in action

Why teams use this Gantt chart maker

πŸ“Š

Planned vs actual

Every task shows its planned duration as a light band plus a filled bar for real progress, so delays are visible at a glance.

⏳

Progress tracking

Set a completion percentage per task. Bars are color-coded by state: completed, in progress, not started, behind, or overdue.

🚨

Overdue detection

A red today line plus automatic β€œshould have started” and overdue flags highlight exactly where your schedule is slipping.

πŸ”—

Dependencies

Define task dependencies in your sheet and the chart draws arrows between linked tasks automatically.

πŸ‘₯

Filter by PIC

Zoom in on one person in charge with the PIC filter, or see the whole project hierarchy β€” parents, children, and leaves.

πŸ–ΌοΈ

PNG export

Export the full chart as a high-resolution image, ready to drop into a report, slides, or a client update.

How it works

  1. 1

    Prepare your spreadsheet

    Keep one column set: id, parent_item, child_item, pic, plan_start, plan_end, actual_start, actual_end, progress, dependencies, notes, notes_display.

  2. 2

    Connect, upload, or paste

    Connect a live Google Sheets spreadsheet (Premium), or paste / upload CSV for free. Your data is parsed instantly in your browser.

  3. 3

    Visualize and share

    Filter by PIC, switch chart themes, and export a PNG. Premium users can save versions and auto-refresh from the sheet.

Simple pricing

Start free. Upgrade when you want a live Google Sheets connection.

Free

$0 forever
  • CSV upload & paste
  • Planned vs actual bars
  • Dependency arrows
  • PIC filter & themes
  • PNG export

Yearly

$60 /year
  • Everything in Monthly
  • 2 months free
  • Cancel anytime

Lifetime

$120 one-time
  • Everything in Monthly
  • Pay once, use forever
  • Portable license key

Frequently asked questions

How do I make a Gantt chart from Google Sheets?

Copy your spreadsheet data and paste it into the tool, or download it as CSV and upload it. Premium users can connect a live Google Sheets spreadsheet so the chart auto-syncs on a schedule.

Is this Gantt chart maker really free?

Yes. CSV upload and paste are free forever, with no sign-up. Premium is an optional upgrade that adds a live Google Sheets connection, multiple spreadsheets, auto-refresh, and version snapshots.

What spreadsheet columns does the tool expect?

One header row with: id, parent_item, child_item, pic, plan_start, plan_end, actual_start, actual_end, progress, dependencies, notes, notes_display. Only id and child_item are strictly needed for structure; plan dates and progress drive the planned-vs-actual bars.

Where can I find an example of the sheet format?

Open the example spreadsheet, then copy the tab and paste it into the tool, or download it as CSV and upload it. It includes header and parent rows, planned vs actual dates, progress, and dependencies you can adapt.

Can I export the Gantt chart as an image?

Yes. The PNG export captures the full chart β€” labels, bars, progress, and dependency arrows β€” at high resolution.

What does planned vs actual mean?

Each task bar shows its planned duration as a light band, with a filled portion for actual progress. Tasks that should have started, or are overdue, are flagged automatically and a red today line marks the current date.

Does the tool work on mobile?

Yes. The layout is responsive and the chart scrolls horizontally on small screens, so you can review timelines on a phone or tablet.

Try it now β€” no sign-up needed

Paste a Google Sheets table or upload a CSV and see your Gantt chart in seconds.