How Google Sheets evolved from a simple web test into an AI-powered powerhouse
In short: Born from a small startup project called XL2Web, Google Sheets transformed from a limited test into a collaborative giant. Today, it leverages machine learning and large language models to automate complex data analysis, while maintaining deep compatibility with traditional spreadsheet formats and offering real-time, multi-user editing capabilities across global platforms.
Google Sheets traces its origins to 2Web Technologies, founded by Jonathan Rochelle and Farzad Khosrowshahi. Their application, XL2Web, was acquired by Google in 2006 and debuted as Google Labs Spreadsheets on June 6, 2006. Initially a limited test, the service eventually expanded into a core component of the Google Docs Editors suite. Over the years, Google bolstered its capabilities through strategic acquisitions, including DocVerse in 2010 for improved Microsoft Office compatibility and Quickoffice in 2012 to strengthen mobile productivity.
The platform distinguishes itself through real-time collaboration, allowing multiple users to edit documents simultaneously while tracking changes via a revision history. Beyond basic data entry, Google introduced the Explore feature in 2016, which uses machine learning to answer natural language queries and generate visualizations. By 2025, the integration of Gemini further advanced these capabilities, enabling users to automate tasks like creating pivot tables, applying conditional formatting, and performing complex data analysis through simple prompts.
While Sheets offers significant utility, it remains a subject of discussion regarding security. Some users utilize the platform to store sensitive information like passwords, a practice discouraged by security firms like Keeper Security and LastPass due to the reliance on Google account security rather than end-to-end encryption. Despite this, the platform remains a staple for many, even handling technical nuances like the 1900 leap year bug differently than Microsoft Excel by adjusting date codes to ensure accuracy for dates prior to March 1, 1900.
The service is capped at 10 million cells per document and supports a wide array of file formats, including .xlsx and .csv. While it is free for individuals, it also serves as a pillar of the business-focused Google Workspace. Whether through native browser support or mobile apps, Sheets continues to bridge the gap between simple data management and sophisticated, AI-driven insight generation.
Opens the Intellect+ feed with this card first. Swipe up for the next one.
Sources
- Summary by Intellect · source: Google Sheets
To cite this card, link to https://intellectplus.co.uk/app/science-google-sheets.
How we source, check and correct cards: Editorial standards.
General information, not professional advice. Spotted an error? Flag the card or see corrections and complaints.
Intellect Plus is a visual educational discovery platform for exploring fascinating facts and ideas. Brain Food, Not Brain Rot. What is Intellect Plus?
Related
More in Statistics and probability · More in Science · Latest · A–Z · All topics