Skip to content

WBS Builder

A project WBS spreadsheet with a Gantt, built for Excel.

Opening the builder…

Private by design. This tool runs entirely in your browser. Your input is processed on your own device and is not uploaded by DO101.

About the WBS Builder

A work breakdown structure the way a project office expects one: a spreadsheet, one row per task, with WBS Number, Task Title, Task Owner, Start Date, Due Date, Duration, % Complete and a Timeline column. The numbering keeps itself in order as you indent, outdent and drag rows around; duration counts itself from the dates; summary rows roll up their children. A Gantt timeline sits beside it and writes back to the same dates, and the Excel download arrives with frozen headings, coloured timeline bars and a page set up to print. Everything runs in your browser, and nothing is uploaded.

How to use it

  1. 1Start from a template, paste an outline, or open a spreadsheet you already have.
  2. 2Add rows, indent them to make sub-tasks, and drag them into order — the WBS numbers follow.
  3. 3Fill in owners and dates; duration and the timeline work themselves out.
  4. 4Check it on the Gantt beside the sheet, dragging bars to reschedule if you need to.
  5. 5Download the Excel workbook, copy the timeline straight into a spreadsheet, or export the chart as a picture.

What you get

  • A spreadsheet first: WBS Number, Task Title, Owner, Start, Due, Duration, % Complete and Timeline
  • Sticky headings, resizable columns, inline editing, and rows you can drag into order
  • Duration counted from the dates, and a week-by-week timeline bar, both worked out for you
  • The sheet, the Gantt and the chart side by side, all updating as you type
  • A Gantt by day, week, month or quarter with a month band, milestones, progress fill and a today line
  • Drag a bar to reschedule a task — the dates in the sheet change with it
  • Copy for Excel: the whole timeline on the clipboard, one column per period, ready to paste
  • A drag-and-drop chart view: pan, zoom, rearrange cards and rename them in place
  • Top-down, left-to-right or indented layouts, with elbow, curved or straight connectors
  • Card shapes, colour themes, and colouring by level, branch or any choice column — per card if you want
  • Automatic WBS numbering: decimal, outline, letters or a flat list, with prefixes and padding
  • Custom columns of any type — text, number, currency, percent, date or a fixed list of choices
  • Roll-ups that total, average or weight the work packages beneath each summary row
  • Excel export with live =SUM(), =MIN() and =MAX() formulas on the summary rows
  • Collapsible row groups, column widths and real Excel dates, currency and percentages
  • Excel files that arrive finished: frozen headings, coloured timeline bars, a % Complete data bar, landscape print setup
  • Optional WBS dictionary, Gantt and branch-summary sheets in the same workbook
  • Chart exports as PNG or SVG, or as a diagram file you can keep editing on the Canvas
  • Imports a spreadsheet back in, reading the hierarchy from codes, level columns or indentation
  • Saves in your browser as you work — no account, no server, nothing uploaded

Step-by-step guides

Frequently asked questions

What is a work breakdown structure?

A WBS splits the whole of a project into smaller pieces, level by level, until each piece is small enough to estimate and assign. The top levels are phases or major deliverables; the lowest level holds the work packages people actually do. Everything the project delivers should appear somewhere in it, and nothing that is out of scope should.

Is the Excel file a real workbook?

Yes — it is a genuine .xlsx, not a renamed CSV. Numbers, dates and percentages arrive as real Excel values with number formats, so sorting, filtering and charting work immediately. Summary rows can carry live =SUM(), =MIN() and =MAX() formulas over their children, so the totals recalculate when you edit a task in Excel.

Can I add my own columns?

Yes. Add as many as you like, choose the type, and say how each one should roll up to its summary rows — sum, earliest, latest, average, or a weighted average by another column. The built-in columns can be renamed, retyped, reordered and hidden too. Your columns appear in the grid and in the download in the order you set.

Can I bring in a WBS I already have?

Open a .xlsx, .xls, .ods or .csv file and the hierarchy is read from whichever convention it uses: a WBS code column like 1.2.1, one column per level, a numeric level column, or indented task names. Columns that match the ones here are reused; columns that do not are created for you. A pasted outline works too.

Can I draw the WBS rather than type it?

Yes. The Chart tab is a canvas: drag cards to place them, drag the background to pan, hold ⌘ or Ctrl and scroll to zoom, double-click a card to rename it, and use the +/− bubble on a summary card to fold a branch away. The layout is automatic until you move something, and Auto-layout puts every hand-placed card back. Because the chart and the spreadsheet are the same document, a card you drag is still a row in the Excel download.

Does the Excel file need formatting once it opens?

No. The headings and the first two columns are frozen, the timeline blocks are coloured by conditional formatting so the bars appear on their own, % Complete gets a data bar, and the page is set to print landscape across one page wide. Dates, durations and percentages are real Excel values underneath, so you can sort, filter and chart them. Turn the formatting off in Layout & export if you would rather have a plain sheet.

How do I get a Gantt chart into Excel?

Two ways, and both keep real dates rather than pictures. Copy for Excel puts the whole table on the clipboard — task, dates, duration, percent complete, and one column per day, week, month or quarter with a block where the task runs — so you paste it straight into a sheet and can see the shape of the plan at once; select the period columns and apply a conditional format to turn the blocks into coloured bars. Or download the .xlsx, which carries the same thing as its own Gantt sheet alongside the WBS.

Where do the Gantt bars come from?

The start and finish columns, which you can point at any date columns you like. Work packages get a bar from their own dates; summary tasks span their children automatically, because their start rolls up as the earliest and their finish as the latest. A task with only one date is drawn as a single day, which is how a milestone behaves. Percent complete fills the bar, and there is a dashed line for today.

Can I export the chart as a picture?

Download it as a PNG for a slide or a document, or as an SVG if you want it to stay sharp at any size. You can also copy the image straight to the clipboard. For free-form work — extra shapes, arrows, annotations — Send to Canvas saves a diagram file that opens in the DO101 Canvas.

Where is my work saved?

In this browser, on this device, and nowhere else. There is no account and no server, which is what keeps the tool free and private — and also means the breakdown will not appear on your other devices, and clearing your browsing data removes it. Use Save project file for a backup you can reopen here or keep alongside the spreadsheet.

How deep should a WBS go?

Far enough that each work package can be estimated, owned and tracked by one person or team, and no further. A common rule of thumb is that a work package should be somewhere between eight and eighty hours of work. Three or four levels covers most projects; more than that usually means the schedule, not the scope, is being broken down.

People who use this tool usually reach for these next.