Spreadsheets for Project Management Stop Working the Moment Work Leaves the Office

Spreadsheets for Project Management Stop Working the Moment Work Leaves the Office

Published

Read time

7 min Read

In this article

Share this blog

Spreadsheets are the default tool for project tracking, and for good reason. They're free, flexible and everyone knows how to use them. For a small project with one contractor, a shared sheet is often enough.

The problem starts when the work spreads out. Using spreadsheets for project management across many sites, with several contractor companies in the field, turns the sheet into a bottleneck: one file trying to be a ticket system, a map, a contractor inbox and a billing ledger at once.

Spreadsheets don't fail because people use them badly. They fail because multi-site work needs things a spreadsheet was never built to do. Here are the three biggest gaps.

Spreadsheets Show Yesterday's Status Because Someone Has to Type It In

A spreadsheet only knows what someone told it. Every status change in the field has to travel by phone, text or email to the person who owns the sheet, then get typed in.

That creates a lag between reality and the record. If updates are entered once a day, the sheet can be up to a day old. If the coordinator is out, it's older. Teams then make dispatch decisions based on stale data and send contractors to sites that are already done.

Research suggests knowledge workers spend about 25% of their time looking for information (Atlassian, 2025; Glean, 2022). In a spreadsheet-driven program, much of that time goes to rebuilding a status that should already be visible.

Spreadsheet Errors Grow With Every Site, Tab and Copy

Spreadsheet errors are not rare. Raymond Panko's long-running review of field audits found that about 94% of business spreadsheets contain at least one error, with errors in roughly 1–5% of formula cells.

Multi-site programs multiply the risk. Each region gets its own tab. Each contractor gets a filtered copy. Someone sorts one column and not the next. Every extra copy is another place for a wrong value to hide.

Errors in a project tracking spreadsheet aren't just cosmetic. A wrong status means a missed visit. A wrong amount means unbilled revenue. Multi-site project management software avoids this by keeping one record per site that everyone reads from.

A Spreadsheet Can't Show You the Map, the Route or the Contractor's View

Multi-site work is spatial. Managers need to see where open tickets cluster, which contractor is closest, and what route makes sense. A spreadsheet shows rows, not geography.

It also gives every viewer the same view. Contractors see every other contractor's sites, rates and notes, or someone has to build and send separate filtered copies. Neither is good. ClickPM gives each contractor their own portal with only their assigned work, and gives managers a live map to assign and route tickets.

When teams outgrow Excel, it's usually not one big failure. It's many small workarounds that add up.

Evidence in Practice

Decades of spreadsheet research point the same way:

  • Error rate: Panko's review of field audits reports a weighted average of 94% of spreadsheets containing errors.

  • Cell-level errors: Studies of operational spreadsheets found errors in about 1% to 5% of formula cells, depending on how errors are defined.

  • Serious errors: In one audit, interviewers estimated about 5% of spreadsheets held "show stopper" errors.

  • Time cost: Glean's 2022 survey found employees spend at least two hours a day, about 25% of the workweek, looking for the documents, information or people they need.

The research doesn't say spreadsheets are bad tools. It says they become risky as the number of rows, tabs and editors grows, which is exactly what happens on multi-site programs.

What This Means for Teams Still Running on Spreadsheets

Signs you've outgrown spreadsheets for project management:

  • You have more than one "master" version of the sheet.

  • Someone's main job is updating the sheet, not running the project.

  • You can't see open sites on a map without exporting data.

  • Contractors ask by phone what's assigned to them.

  • Billing depends on someone cross-checking the sheet at month-end.

If three or more apply, it's time to move. Start with our multi-site project management guide, then see how a contractor portal replaces email and WhatsApp.

Frequently Asked Questions

Can you use Excel for multi-site project management?

Yes, for small programs. Once you have many sites, several contractors and billing tied to completed work, Excel creates lag, errors and extra admin.

What should replace a project tracking spreadsheet?

A system with one ticket per site, a live map, a contractor portal and financials linked to ticket status.

Sources

  • Panko, "Spreadsheet Errors: What We Know. What We Think We Can Do" — arxiv.org

  • Newswise, "Study finds 94% of business spreadsheets have critical errors" — www.newswise.com

  • Atlassian, State of Teams 2025; Glean survey 2022 — www.businesswire.com

We designed ClickPM to feel as simple as a spreadsheet but work like a real system: live status, a map, contractor portals and financials in one place.