Excel to Gantt Chart

Convert an Excel (.xlsx) or CSV task list into an editable online Gantt chart. Review task dates, durations and predecessor links, then revise and export the schedule in GanttPilot.

Upload Excel or CSV schedulesTurn task rows into a Gantt chartReview dates, durations, and dependenciesContinue editing in the workspace

Sample downloads and the preview are free, with no signup. Uploading your own file requires an account. New accounts get a 14-day trial. See editing and export access.

Upload an Excel schedule

From spreadsheet rows to a Gantt chart.

This fictional equipment installation has 8 tasks, 8 finish-to-start links and one handover milestone. The downloads and preview use the same dates and dependencies. No signup is needed to preview or download.

Equipment installation example. Calendar days, November 2–15, 2026.
IDTask nameDaysStartFinishPredecessorsGantt preview
Nov 2 Nov 15
1Confirm installation scope12026-11-022026-11-02—
2Prepare the site22026-11-032026-11-041
3Deliver equipment42026-11-032026-11-061
4Install equipment32026-11-072026-11-092, 3
5Connect power and controls22026-11-102026-11-114
6Run commissioning tests22026-11-122026-11-135
7Complete final inspection12026-11-142026-11-146
8Handover milestone02026-11-152026-11-157

Example assumptions: calendar days, including weekends; 8 hours per day; no holidays. Positive-duration finish dates include the last workday. The zero-day milestone is on November 15. Check your own calendar after import.

Check a change before handing off the plan

Import a sample, then review its task count, dates and links. To test a delay, extend “Deliver equipment” from 4 to 6 days and review the downstream dates. With these links and the same calendar, the handover moves from November 15 to November 17. Save, reopen and check your exported file before using it.

Explore a larger, read-only construction demo or learn how to review schedule revisions.

Start with spreadsheet rows, then review the schedule visually.

01

Prepare and upload the spreadsheet

Sign in, then upload an .xlsx or CSV with task headers and one task per row. For Excel files, put the task table on the active worksheet before saving.

02

Check the imported fields

Review the import report, task count, dates and predecessor links. Spreadsheet formatting, formulas and chart graphics are not carried into the Gantt editor.

03

Open the Gantt chart

The imported rows become an editable Gantt schedule where you can adjust dates, dependencies, milestones, and resources.

Spreadsheet columns that import well.

A spreadsheet only needs a task-name column to start, but structured schedule columns make the Gantt chart more useful immediately after import.

Task name

Required. Use one task per row and a header such as Task Name. Do not use a screenshot or a chart-only sheet.

ID and WBS

Use a unique ID for each task. WBS values such as 1.1 and 1.2 describe the hierarchy; keep them separate from task names.

Duration

Enter whole-day durations, such as 3. A zero-day task is a milestone. Check the imported calendar before interpreting these as working days.

Start and finish

Use unambiguous dates such as 2026-11-02. In Excel, use date cells. Make sure finish dates agree with durations and the calendar.

Predecessors

Reference task IDs, not row positions or task names. In the sample, 2, 3 means the task follows both tasks with finish-to-start links.

Resources and notes

Put resource names and task notes in their own columns. Review the import report for mapped and ignored fields.

Why convert Excel schedules into a Gantt chart?

Spreadsheets are fast for listing tasks, but schedule logic is easier to inspect when dates, dependencies, milestones, and resources are shown on a timeline.

Spreadsheet task rows

Use a normal task table as the starting point. Extra header rows can be ignored when a valid task-name column is found.

Editable Gantt timeline

After import, the schedule opens in the Gantt workspace instead of staying as a static spreadsheet.

Export after review

Once the imported schedule is cleaned up, export table files or Project XML from the workspace when needed.

Common questions about creating Gantt charts from Excel.

Can I create a Gantt chart from Excel?

Yes. Upload an Excel .xlsx schedule and GanttPilot will import the task rows into an editable Gantt chart when it can identify a task-name column.

Can I upload a CSV schedule?

Yes. CSV schedules are supported as a lightweight way to move task names, dates, durations, dependencies, and resources into the Gantt workspace.

What columns should my spreadsheet include?

At minimum, include a task-name column. Better imports include WBS, duration, start, finish, dependency, resource, milestone, and notes columns.

Can I edit the Gantt chart after importing Excel?

Yes. The spreadsheet becomes a normal GanttPilot project, so you can edit tasks, dates, dependencies, resources, and milestones.

Is the Excel to Gantt converter free?

The example preview and sample Excel and CSV downloads are free without signup. Your own file upload requires an account. New accounts get a 14-day trial; continued editing and export access depend on your plan. See Pricing for current limits.

Will my Excel formulas and existing Gantt bars be imported?

No. The importer reads task data and stored cell values, not the workbook's formulas, formatting or chart graphics. Recalculate and save the workbook in Excel first. Keep a backup of your original file.

Why are tasks missing or dates different after import?

Check that the active worksheet contains a task-name header and one task per row. Use unambiguous dates, whole-day durations and unique task IDs for predecessor references. Read the import report and check the project calendar, weekends and holidays before editing the plan.

Can I download an Excel Gantt template instead?

Yes. Use the construction schedule template for an Excel workbook with a weekly Gantt chart. This converter reads an existing task table and creates an editable Gantt chart in GanttPilot.

Choose the next step for your spreadsheet.

Read the Excel import guide for preparation and review. If you need a starting workbook, download the construction Excel template. Have a Project file instead? Open MPP or Project XML.

Ready to turn spreadsheet rows into a Gantt chart?Upload an Excel or CSV schedule and continue editing in GanttPilot.
Upload Excel or CSV