Microsoft 21 min read

Why We Can’t Quit Excel

Author: user avatar Dave Dave Source: Bloomberg

Microsoft’s spreadsheet software is expensive, derivative and depressing. It might also be the most killer app of all time.

By Max Chafkin and Dina Bass
Illustrations by Talia Cotton

Before it took over her life, Leila Gharani mostly took Microsoft Excel for granted. She was working on a process optimization project for a large paper-products manufacturer—a job that, to hear her tell it, sounds not entirely dissimilar from the fictional work depicted at Dunder Mifflin on The Office. That meant a lot of time using spreadsheets. “I don’t think it’s a tool that you open and you’re like, ‘Oh, my God, I love this.’” she says.

At first she used Excel as a calculator or to make lists. Eventually she was creating financial models using its more advanced functions. In Excelspeak, “functions” are the formulas that modify or build on data in some other part of your document. The simplest is SUM, which adds up numbers in other cells; a more complicated one is LAMBDA, which lets experts create their own customized functions so they don’t have to keep retyping formulas. Gharani’s favorite Excel tool nowadays is Power Query, which finance types use to clean up datasets before inserting them into Excel. “A lot of people still haven’t discovered it,” she says.

A decade ago, when Gharani struck out on her own as a software consultant, she played down her spreadsheet fluency and emphasized her knowledge of higher-end financial planning software, such as Oracle Corp.’s Hyperion. She figured the more specialized expertise would yield better pay. But soon enough she found herself fielding lots of questions about spreadsheets. Like, a lot of questions. “If I went to a company to train them on the Oracle system, they kept asking me Excel questions,” she says. “The finance departments I was training all worked with Excel. Excel is just always there.”

Video poster

For most of us, Microsoft Corp.’s spreadsheet application is, as Gharani says, just there—the little-loved backbone of any corporate infrastructure. Try to imagine the most depressing version of a modern workplace (fluorescent lights, gray cubicles, ergonomic chairs), and you’ll probably also conjure a computer screen displaying that signature grid with the numbers down the left side, the capital letters across the top and the menu bar with the green accents. Excel is at best ubiquitous, the technological equivalent of a drop ceiling or high-traffic carpeting, and at worst malevolent, abetting layoffs and other cost-cutting that can hit bone. “It is the embodiment of some of the least positive aspects of late capitalism,” says Mitch Kapor, who co-founded the pioneering spreadsheet-software company Lotus. “Why would people love that?”

But there are those enlightened souls who look at an Excel grid and see infinite potential. Gharani is now one of those people. No longer a consultant per se, she’s become instead one of the world’s leading spreadsheet influencers. Her YouTube channel, XelPlus, counts nearly 3 million subscribers. A typical XelPlus video racks up hundreds of thousands of views; the biggest hits (“Excel Pivot Table EXPLAINED in 10 Minutes,” “Excel IF Formula: Simple to Advanced”) land comfortably in the millions. Along with a cut of YouTube’s ad proceeds, she makes money by offering paid online classes, premium memberships and even merch, including a $47 hoodie with the phrase “Ma Sheet Ma Rulezz” and $15 mugs that proclaim “Eat. Sleep. Query. Repeat.”

XelPlus isn’t the only Excel-themed media business. There’s also Your Excel Dictionary (4.1 million followers on Instagram), excelisfun (1.3 million on YouTube), Miss Excel (960,000 on TikTok) and many others. There’s a 700,000-person Reddit community and even an e-sports circuit for professional spreadsheet enthusiasts, who compete each year in an Excel World Championship in Las Vegas that comes complete with an ESPN telecast and a championship belt. The popularity of the sport—or, if you prefer, “sport”—has exploded in recent years. “The skill ceiling has gone way up,” says 2024 champion Michael Jarman, who lost the 2025 belt this week after a dominant performance by Diarmuid Early in a challenge to model origami folding inside of Excel. “People are getting much better. They’re refining their LAMBDA toolboxes.”

If it seems strange that the phrases “championship belt” and “LAMBDA toolboxes” might appear in close proximity, consider the staying power of Excel itself. The first version of the software was released just over 40 years ago, spawning an ecosystem that’s powered the rise of an entire class of consultants, software developers and IT departments. Then, of course, there’s the business behind it. Excel’s release both fueled Microsoft’s growth—the company went public the year after it went on sale—and helped ensure that personal computers became essential tools of the modern workplace, says Margaret O’Mara, a history professor at the University of Washington and author of The Code: Silicon Valley and the Remaking of America. “It is something that is so ubiquitous we take it for granted,” she says, before paying Excel the same backhanded compliment offered by Gharani: “It’s always there.”

We’re a long way from 1985, and more portable options have made the sturdy old PC far less relevant than it used to be. Yet, Excel spreadsheets remain a key tool for everyone from hedge fund managers modeling cash flows to political campaigns predicting voter turnout. The rest of us are likely to use them to figure out grocery budgets, split bills and manage wedding thank-yous, among many, many other household tasks. “It’s just a very powerful way to organize information,” says Pito Salas, an early spreadsheet developer who’s now an emeritus professor of computer science at Brandeis University. “You can use spreadsheets to run your Little League team, and you can use them to operate the Pentagon.”

Video poster

That’s not a joke. As of earlier this year, the US Department of War was paying for 2 million licenses to Microsoft 365, which includes Excel, Word and PowerPoint. Because of the way Microsoft is structured, in which its three main product categories—operating systems, productivity software and cloud services—are bundled together, it’s hard to ascribe a precise value to the leading spreadsheet application except to say that without it, there’s zero chance the company that owns it would be worth nearly $4 trillion. In 2025, Microsoft 365 subscription revenue from businesses totaled almost $88 billion, on top of $7 billion from other customers. Those numbers, and Microsoft’s own public disclosures, suggest there are something like 500 million paying Excel users, the rough equivalent of Netflix plus Amazon Prime subscribers. Excel has its corporate challenges, from Google’s web-based knockoff to the looming threat of artificial intelligence, but so far no competitor has managed to mount a serious challenge.

The story of how this happened—a tale of inspired creativity, enthusiastic copying and utter ruthlessness—helps explain the difficulty awaiting anyone looking to take Excel’s place. Beyond the Gharanis of the world, the Excel economy has grown to include hundreds of millions of workers who are to some degree addicted to the software’s conveniences and irritated by its iron grip. Are all those billions of dollars just the price of Stockholm syndrome, or is Excel secretly the greatest piece of software ever written?

Video poster

Among the most popular posts of all time on the Excel subreddit is one that explains how to embed a feature-length movie into a sheet as a way to get around employee-tracking software. The code allowed the creator to claim he’d spent hours working on a spreadsheet while also rewatching Wall-E, illustrating Excel’s breadth but also showing that even the most enthusiastic users would often rather be doing something else.

Indeed, pretty much all the spreadsheet experts interviewed for this story routinely field complaints, often from annoyed college students who’ve been forced to learn how to use it for class. “It’s like, ‘Oh, I hate the person who developed a spreadsheet,’” says Dan Bricklin, who created the first computerized spreadsheet program, called VisiCalc, for the Apple II computer in the late 1970s. “I feel bad for them.”

Before the Apple II, of course, paper spreadsheets had been in use for generations by bookkeepers, who, one can only assume, also had mixed feelings about them. The basic idea is even older. A clay tablet, found in Iraq and dated by archaeologists to around 1800 B.C., shows 15 rows and 4 columns of numbers, calculations that seemed to have been etched by some anonymous Babylonian forerunner to today’s moderately disgruntled marketing consultant.

While the cuneiform digits are unfamiliar, the format is basically identical to what Bricklin came up with at Harvard Business School in 1978. He got the idea while watching a professor fill out a table of financial projections on a chalkboard and struggling to keep up in his notebook. He began to daydream about a software tool that would combine aspects of an electronic calculator and a word processor, allowing him to edit a table without having to erase and redo the whole thing. The idea was a “magic piece of paper,” as he put it in a class project in 1978, with rows and columns you could update by clicking with a mouse.

At this time the Apple II didn’t have a mouse, but it did ship with two twist dials for use with Pong and other primitive games. Bricklin incorporated the dials into the first version of his spreadsheet program, then switched to using the more accountant-friendly arrow keys instead. When he and VisiCalc co-creator Bob Frankston began selling the software in 1979—originally priced at $99 and sold as a 5¼-inch floppy that came inside a slim leatherette portfolio—it transformed the Apple II almost instantly from a niche tool for gamers and teachers into the first mass-market PC.

Before VisiCalc, anyone who wanted to use a computer for financial modeling needed to know a programming language and have access to a mainframe. After VisiCalc, all you needed to know were a few simple functions, such as SUM (which we’ve covered), AVERAGE (what you’d imagine) and VLOOKUP (a search function for large sheets). “It was like this interactive toy, where you can kind of program it without knowing you’re programming,” says Ray Ozzie, who worked at Bricklin and Frankston’s company, Software Arts, and, later, at Microsoft. “It was amazingly seductive.”

Like many early pioneers, Bricklin proved to be too far ahead of his time. In the 1970s software patents were uncommon—the conventional wisdom was that software was math, and therefore unpatentable—so he didn’t bother trying to protect VisiCalc from copycats. “Financially it would have been great if we’d have been able to patent it,” Bricklin says. “And there would be a Bricklin Building at MIT, instead of a Gates Building.”

The comment hints at a second reason—beyond the simple fact that grids of numbers are just kind of dull—for the ambivalence many feel about Excel. It’s not a brilliant invention but a brilliant knockoff, whose popularity will forever be tied to the imperial approach to business favored by Microsoft and its co-founder Bill Gates. After Microsoft’s first attempt to copy VisiCalc fizzled, Gates set about trying to clone the most successful of the VisiCalc copycats. This was Lotus 1-2-3, which had become the early winner on IBM and IBM-compatible PCs by expanding the capacity of each spreadsheet from 255 rows to 2,048 and by adding a few new features, including charts.

Excel was born at a Microsoft offsite in 1983 under the code name Odyssey. The original plan was to create a better version of Lotus for IBM-style PCs. “In many ways it was a troubled project,” says Doug Klunder, the lead developer. From Klunder’s point of view the trouble started in 1984, when Steve Jobs unveiled Apple Inc.’s Macintosh, the first inexpensive computer with a mouse and a graphical user interface. The buzz—along with the fact that Microsoft was itself preparing to release its Windows operating system—led Gates to switch Excel’s target market from PCs running the old DOS operating system to Macs. This delayed Excel’s release significantly, forcing Klunder to spend six months redoing his work.

Video poster

He was so frustrated, both by the delay and because he’d been excluded from the meeting in which the decision was made, that he quit, telling colleagues his plan was to leave the software industry in favor of migrant farmwork. “I look back on it, and it’s clear I was just totally burnt out,” he says.

Project Odyssey got back on track after Klunder ran out of cash somewhere in the Ojai Valley two months after his departure. “I picked lettuce a couple of times and did some other odd jobs,” he recalls. “Then my backpack was stolen. I’m like, ‘I need money. Let me call Microsoft.’”

While Klunder and a team of 10 programmers—plus a handful of employees assigned to test the software and write the manual—raced to finish, Microsoft’s marketing operation kicked into gear. In May 1985, Gates and Jobs appeared together at a launch event at Tavern on the Green in New York City’s Central Park. By this point the two men were rivals, and though both were excited about the release, it was for different reasons. Jobs saw Excel as a stopgap until Lotus finished its own Mac spreadsheet. Gates viewed it as a key application for Windows.

To help push that point, Microsoft executives planted a question about the future of Excel. During a Q&A portion of the event, a reporter asked if it would be available exclusively on the Mac, or if Microsoft planned to bring it to PCs. Gates answered diplomatically, telling the crowd his plan was to make Excel available to all platforms “in time,” according to Jeff Raikes, then a Microsoft marketing executive who attended the event. “He’s trying to be gentle with Steve Jobs,” Raikes recalls.

Jobs, seeming to sense a threat, parried back. “In time,” he said, “we’ll all be dead.” Gates allowed the audience to laugh at that one and then deadpanned, “Not IBM.” The message was clear: As far as Gates was concerned, the Mac was the stopgap. “Jobs was speechless,” Raikes recalls.

Microsoft had said it would deliver Excel by September, forcing Klunder and his team to pull an all-nighter on Sept. 29 to finish debugging their work. The following day they got a few 3½-inch floppy disks made and drove them and the roughly 550 pages of manuals and reference guides over to a local Egghead Software (a bygone retail chain) in Bellevue, Washington. After that humble start, however, things moved fast. By the spring of 1986, after Klunder left his job again, this time to walk the Pacific Crest Trail, other hikers told him they were using Excel to plot their daily mileage and plan their meals.

Video poster

Excel first distinguished itself with speed. The beauty of an electronic spreadsheet, compared with the paper alternative, is that if you change one number, you can update the whole sheet at once. The problem was that making tens of thousands of individual calculations quickly was a challenge for the PCs of the early 1980s. Lotus power users could find themselves sitting around for a minute or more while the program finished that work. Klunder came up with a fix, known as intelligent recalc, that used an algorithm to update only the cells affected by a given change. This change meant Excel could often recalculate 10 times as fast as competitors. “Now it seems like this weird, sort of silly thing,” says Jabe Blumenthal, who was the program manager for Excel. “But you can’t remember how incredibly slow computers were.” (Although Klunder is widely credited with the breakthrough, he says Gates himself suggested the approach to him.)

Another highlight of early Excel was a feature that allowed users to preview on the screen what their spreadsheet would look like laid out on paper. “That was just thrown in because we thought it was cool,” Klunder recalls. Blumenthal initially tried to cancel the feature, but he relented under pressure from Klunder’s team. Print preview would turn out to be a cornerstone function of pretty much every piece of desktop publishing software created since.

Even so, the defining feature of Excel, at least in the eyes of its users, was how it looked, not how it worked. “Speed of recalc was something people always talked about” but “not the thing that really grabs you,” says Steve Ballmer, who was Microsoft’s head of sales in the mid-’80s and later ran the company. “The real thing was we had a graphical user interface, so almost everything looked better.” Ballmer says that spreadsheets are harder to conceptualize than most business applications and that he urged reps to “demo, demo, demo, demo, demo,” as he puts it. “You’re showing another senior person, ‘See, I use this thing. Isn’t this amazing?’”

Ballmer retired from Microsoft in 2014 and now spends much of his time running the Los Angeles Clippers, but as if to make the point about the power of a spreadsheet demo, he pulls up one of his own Excel files—a detailed accounting, with hundreds of rows, of how he spends each hour of each workday. The spreadsheet includes the number of hours in a given month spent meeting with players, working on his nonprofits, checking emails, exercising, playing golf, getting massages and on and on. Bathroom breaks are included in a row called “free time.” (The sheet seemingly makes no mention of any time spent navigating the National Basketball Association salary cap.) For each category, Ballmer has an annual budget, based on previous years’ spreadsheets. All the times add up to 2,080, the theoretical number of work hours each year. He started this as part of an attempt to spend less time traveling for work. “Most people think it’s pretty weird,” he says with a hint of pride.

It wasn’t just memorable demos or Ballmer’s energetic pitches that sold Excel. In 1988, Raikes, who would eventually become president of the company’s business division, came up with the idea of using the software to push buyers to switch to other Microsoft products. This became known as “the bundle,” and it involved packaging Excel with Microsoft Word as well as a presentation application for the Mac called PowerPoint, which Microsoft bought in 1987 for $14 million. “I said, ‘Hey, you know these companies put their list price at $495 per app,’” Raikes recalls. “‘Why don’t we put three apps into a package and sell it for the price of two?’” This became known as Microsoft Office, sold in a literal package in computer stores and later as a per-user license to the IT departments of large companies and to computer manufacturers that included it with the new machines sold to consumers.

Microsoft used bundling as a competitive strategy, which rivals saw as predatory and unfair. Kapor, the Lotus co-founder, says he didn’t mind the other company’s copying. But “what was painful and difficult were Microsoft’s business practices, which were over the line in many ways,” he says. “I’m hoping that Bill, before he exits the scene, will take more responsibility for that.”

Eventually, another example of Microsoft’s bundling would figure in the US government’s antitrust case against the company in the late 1990s, but by that point Office had effectively taken most of the market for business software. “Lotus tried to catch up,” says Salas, the Brandeis computer science professor. “The Microsoft Office behemoth just locked everybody in.” Salas is famous among spreadsheet aficionados as the inventor of what’s known as the pivot table, a software tool that summarizes complicated datasets. For instance, a pivot table might take a detailed list of transactions for a retail chain, including information about store locations, products sold and prices paid, then generate a report that shows a breakdown of the most popular products by region or that makes clear which stores are the most profitable.

Pivot tables are now seen as a key part of Excel. Oz du Soleil, an influencer who runs the popular YouTube channel Excel on Fire, describes learning about the feature (while working as an analyst at an online education company) as “the crack in the wall” that changed the trajectory of his career. He remembers a feeling of empowerment, a sense “that I can get the shit done.” Pivot tables, he says, are “the turning point for a lot of people.”

Microsoft didn’t invent pivot tables, of course. Salas came up with the idea working at Lotus. But it only took off once Microsoft engineers copied it and stuck pivot tables into a 1994 version of Excel. “We thought it was flattering and amusing,” Salas says of watching his invention get knocked off. “That was the arrogance of youth.”

Since then there have been two serious challenges to Excel, each driven by the rise of a new platform for software. The first was cloud computing, which enabled spreadsheets to be stored in a data center, accessed via the web and edited by a bunch of people simultaneously. In 2006, Google, which already dominated web search and was taking over email, bought a web-based knockoff version of Excel called XL2Web. It rebranded the product Sheets, gave it away for free and made it very easy to share a spreadsheet with anyone else who had a Gmail address. Today, Excel and Google Sheets are barely distinguishable, and Sheets has become the default way to share, say, a potluck dinner sign-up sheet or a PTA contact list.

“I was kind of shocked at first,” says Blumenthal, the former Microsoft executive. “Like, ‘Oh, my God, they just ripped off this idea.’ Which, by the way, I did as well, when we did the first version of Excel.” He says Sheets now includes “99% of the functionality that 99% of Excel users use.”

But a spreadsheet that anyone can edit isn’t necessarily what you want when you’re working with data that’s complex, sensitive or complexly sensitive. Those use cases include a lot of the data that workers put into spreadsheets. There was also the lock-in factor from Microsoft’s dominance of PC software. “We thought Google Sheets was going to kill Excel, but it didn’t,” says Ozzie, the onetime VisiCalc (and Lotus) employee who was Microsoft’s chief software architect from 2006 to 2010.

Video poster

By the late 2000s most companies were already paying huge sums each year for Microsoft’s bundle, meaning they’d also have to toss Outlook, PowerPoint and Word if they wanted to save money by switching to Sheets. This sense of inertia had a psychological component too. We’d all just gotten used to Microsoft products, even if we didn’t like them. O’Mara, the Silicon Valley historian, attributes Excel’s staying power partly to “this managerial hangover where the people making purchasing decisions are living in a world that Microsoft made.”

“I’m a Gen Xer,” O’Mara says. “We’re all comically attached to the Microsoft suite. All my students use Google Docs. All my younger editors and collaborators use Google. I’m still using Word.”

The second serious challenge to Excel’s dominance has come more recently, with the rise of ChatGPT and other AI chatbots. These bots promise to instantly make sense of enormous amounts of information, suggest new strategies, spot trends and even spit out fully formed business plans, without all the hours of staring at and manipulating a grid. (Their track record of actually fulfilling these promises is, for now at least, spotty.) There are dozens of startups vying to replicate parts of Excel or replace the entire thing. This summer, tech news site the Information reported that OpenAI is working on an office suite that will compete directly with Microsoft’s bundle.

None of these efforts has panned out quite yet. “We are meeting with a bunch of AI spreadsheet companies,” says Alex Immerman, a partner at Andreessen Horowitz, the venture capital firm. “They’re all built on top of Excel.” By this he means that most Excel killers are, for now, either copycats or add-ons that help you make an Excel-compatible spreadsheet.

This happens to be Microsoft’s strategy too. Its main chatbot, Copilot, runs inside of Excel and promises to make it easy to add more sophisticated calculations to existing spreadsheets. The idea, says Rajesh Jha, the Microsoft executive who oversees Excel (as well as Windows and the other Office apps), is to bring the level of expertise commonly seen at the Excel World Championship to the rest of us.

There are reasons to be skeptical of claims that AI is killing off the spreadsheet. The chatbots’ large language models typically struggle with simple calculations, and they’re notoriously bad at showing their work. “In my day to day, I spend more time fighting off people’s vibe-coded projects than actual useful AI integrations,” says Nick Frescas, a data analytics manager who serves as a moderator for the Excel forum on Reddit under the handle Frescani. “There’s something about processing data yourself that helps you internalize the information.”

For now, Excel is doing just fine. In the most recent quarter, commercial revenue for Microsoft 365 increased 17% from the same period a year earlier; revenue from consumers for the bundle of software and services that includes Excel was up 28%. Even Immerman, who as an investor says he sees “tremendous opportunity” in the chance to invest in Excel competitors, remains enamored of Microsoft’s 40-year-old spreadsheet app. He first used Excel to do simple calculations as a grade-schooler and eventually moved on to bar charts. In college he found his way to iterative calculations, conditional equations, macros and plug-ins. “You can go deeper and deeper,” he says. “Even though I spend time in Excel every day, I don’t harness the full power.”

Video poster

Before his career in venture capital, Immerman worked as an analyst at the investment banking firm Allen & Co. He says he was embarrassed back then by the number of hours a day he spent staring at Excel. He no longer feels that way. “It’s open all day, every day for me, alongside Slack and email,” he says. “But those are communication mechanisms. Excel is where actual work happens.”

This distinction between communication and work may hold the key to understanding why in some quarters, Excel isn’t just tolerated but, weirdly, loved. “Excel is often used as the symbol of the soul-crushing office atmosphere,” says Blumenthal. But, he says, it can also be “the most inspiring and independent thing people are doing within their soul-crushing environment. It can actually be a source of creativity and independence.” It is, in other words, both the definition of what makes certain kinds of work unbearable and a big part of what makes them fulfilling.

Your mileage may vary. Even Gharani, the Excel influencer, shies away from the L-word when describing her relationship with the software. It’s useful, she says, and she appreciates it, but if it died tomorrow, she’d just move on to teaching people how to use whatever AI-powered app killed it. Excel has had a good run. “I know there are very hardcore Excel fanatics, but I see it more as a tool,” Gharani says. “It gets the job done. If there’s a better tool that comes along, that’s the way it is.” —With Emily Forgash and Brunella Tipismana Urbano

First-person accounts have been lightly edited for clarity.

Follow
You did not use the site, Click here to remain logged. Timeout: 60 second