Projects Tutorial

Import a work breakdown from Excel into a project template

Excel (WBS) import creates a project template's task list from a spreadsheet. Set the column order first, then import, then check the tasks.

Uses: Project Templates, Tasks, Excel (WBS) importOutcome: a reusable template with its task list from Excel
1

Prepare the spreadsheet

Why it matters: the import reads one task per row, so the columns need to be in place before you upload the file.
  1. Put one task in each row.
  2. Use the columns the importer expects, in the order it expects them.
What you'll see: a spreadsheet with one row per task and the columns in place.
2

Open the template import

Why it matters: the import starts from the template, not from an open project.
  1. Open Project Templates.
  2. Start an import from Excel (WBS).
What you'll see: the import screen with a file picker.
3

Choose the file and map the columns

Why it matters: mapping tells the importer which spreadsheet column holds each task field.
  1. Choose the spreadsheet file.
  2. Map each spreadsheet column to its task field.
What you'll see: the columns are matched and ready to import.
4

Check the tasks and save the template

Why it matters: checking before you save keeps errors out of every project that starts from the template.
  1. Review the imported tasks.
  2. Save the template.
What you'll see: a saved template with its task list.
5

Start a new project from the template

Why it matters: the template saves time only when each new project starts from it.
  1. Create a new project and choose the template.
  2. Set the dates, owners and billing type for the project.
What you'll see: a new project with the template's tasks already in place.

Template ready

You have a template built from a work breakdown. Next, set the dependencies between its tasks in the Gantt chart.

Next: Set up Gantt dependencies

Where this fits in the connected workflow

Sell, Quote, Agree, Onboard, Deliver. This tutorial covers Onboard: a template gives each new project its starting structure before the team delivers the work.

Common questions

Can I import a work breakdown from Excel?

Yes. Excel (WBS) import creates the task list from a spreadsheet.

Does a template set up the project for me?

A template sets the starting tasks. You still set the dates, owners and billing type for each project.

One connected platform

Ten stages, one client record

This page's module is the Onboard stage of a ten-stage workflow that runs from first contact to support, all on one client record.

  1. 01Sell
  2. 02Quote
  3. 03Agree
  4. 04Onboard(you are here)
  5. 05Deliver
  6. 06Staff
  7. 07Track
  8. 08Bill
  9. 09Measure
  10. 10Support

Four things run across every stage: AI and automation, integrations, roles and permissions, and mobile access.

Who it fits

project managers who set up project templates from a work breakdown.

Compare plans and start a free trial at /pricing.

Compare plans and start a free trial