Back to Insights
Operations

The Airport Spreadsheet Trap: 5 Escape Strategies

Matthew Chong
March 8, 2026
7 min read
The Airport Spreadsheet Trap: 5 Escape Strategies

Nobody gets into airport operations because they love Excel.

Think about it. Your ops team — the people who chose this career because they love the energy of a busy terminal, the satisfaction of pushing flights on time, the adrenaline of solving problems in real time — they're spending 10+ hours a week copying data from one system, pasting it into another, formatting it for a report that's already outdated by the time it hits someone's inbox.

I spent 15 years watching this play out at LAX. Talented operators pulled off the ramp, stuck behind screens, reconciling numbers from five different systems that were never designed to talk to each other. AODB in one tab. RMS in another. Workforce data in a third. Baggage stats in a fourth. And the daily report? A Frankenstein spreadsheet held together with VLOOKUPs and prayers.

That's the spreadsheet trap. And if your airport runs anything like the ones I've worked in, you're stuck in it right now.

Here's the good news: there's a way out. Not a rip-and-replace overhaul that takes two years and a board resolution. Five practical strategies that airports are using right now to claw back their time and get their people back to the work they actually signed up for.

Strategy 1: Map Your Data Pain Before You Buy Anything

Most airports jump straight to solutions. New dashboard tool. New BI license. New consultant with a new slide deck.

Stop. Before you spend a dollar, map where the pain actually lives.

Sit down with your ops team — not leadership, the people doing the work — and ask: Where do you spend the most time on data that isn't operations? How many systems do you touch to build one report? Where do you manually re-enter information that already exists somewhere else?

At SFO's International Terminal, this exercise revealed that operators were pulling from 3+ disconnected legacy systems daily just to produce basic operational summaries. The fix wasn't more software. It was understanding which disconnections were costing the most time.

The takeaway: Diagnose before you prescribe. A 30-minute conversation with your duty managers will tell you more than a six-month RFP.

Strategy 2: Automate the Report, Not the Person

Here's a pattern I've seen at every airport I've worked with: leadership wants better reports, so they assign more people to reporting.

That's backwards.

The report should build itself. If your team is manually pulling daily throughput numbers, compiling TSA compliance data, or formatting board summaries by hand — that's automation waiting to happen. The data already exists in your systems. The problem is that nobody has connected the pipe.

When we deployed AeroSuite ARP at SFO, automated reporting replaced hours of manual compilation. The ops team didn't disappear — they went back to the terminal floor. Back to solving problems. Back to the job they were hired to do.

The takeaway: Every hour your team spends formatting a spreadsheet is an hour they're not spending on operations. Automate the report. Free the person.

Strategy 3: Demand Real-Time, Not Last-Week

Here's something airport executives don't say out loud enough: most of the data you're using to make decisions is already old.

That board report from Tuesday? Built from data pulled on Friday. That compliance summary? Aggregated from logs that were entered manually and reconciled over the weekend.

You're driving by looking in the rearview mirror.

Real-time operational visibility isn't a luxury. It's how you catch problems before they cost you. A gate conflict flagged 45 minutes out. A staffing gap identified before the peak hour hits. A compliance anomaly surfaced while there's still time to correct it.

The shift from historical reporting to live dashboards isn't a technology upgrade. It's a decision-making upgrade. Your systems already generate the data in real time — you're just not seeing it that way because it's trapped in silos.

The takeaway: If your dashboards refresh once a day — or worse, once a week — you're not monitoring operations. You're reviewing history.

Strategy 4: Connect What You Have (Don't Replace It)

This is the objection I hear most: "We've invested millions in our current systems. We can't rip them out."

You don't have to.

The spreadsheet trap isn't caused by bad systems. It's caused by disconnected systems. Your AODB works fine. Your RMS works fine. Your workforce management tool works fine. The problem is they don't talk to each other, so your ops team becomes the integration layer — manually bridging the gaps between tools that were never designed to share data.

The solution is an intelligence layer that sits above your existing systems. Read-only. No disruption to what's already working. Just one unified view of what all your systems already know.

At SFO, we connected 3+ legacy systems in 90 days with zero downtime. We didn't replace a single piece of their existing technology. We just gave their data a place to come together.

The takeaway: Your systems aren't the problem. The gaps between them are. Bridge the gaps instead of bulldozing everything.

Strategy 5: Start Small, Prove Fast, Then Scale

Airport procurement is slow. Everyone knows it. Budget cycles, board approvals, security reviews, stakeholder alignment — it can take a year before a single line of code touches your environment.

That's why the pilot model exists.

A 90-day terminal pilot lets you prove value in a contained environment. Pick one terminal. Connect the systems that matter most. Deliver live dashboards within 30 days. Define success metrics upfront — together — so there's no ambiguity about whether it worked.

When the pilot delivers? You've got internal champions. You've got measurable results. You've got a story to take to the board that sounds a lot better than "we need a multi-year technology overhaul."

SFOTEC saw a 40%+ reduction in manual reporting within their 90-day pilot. That number did more for the expansion conversation than any proposal deck ever could.

The takeaway: Don't try to boil the ocean. Prove it in one terminal. Let the results make the case for everything else.

The Bigger Picture

The spreadsheet trap isn't just an inconvenience. It's an operational tax your airport pays every single day. Every hour spent on manual reporting is an hour not spent on passenger experience, safety, or the thousand other things that actually move an airport forward.

Your team didn't get into aviation to stare at Excel. And they shouldn't have to.

The escape isn't complicated. Map the pain. Automate the reports. Demand real-time data. Connect what you have. Start small and prove fast.

The only question is how much longer you want to keep paying that tax.

Ready to see what escaping the spreadsheet trap looks like?

Schedule a 30-minute demo and we'll show you how SFO did it in 90 days.