RIP VLOOKUP: Did Google Just Make Spreadsheet Experts Obsolete?

The Big Breakthrough: Near-Human Expertise

According to Google’s latest update, Gemini has achieved a staggering 70.48% success rate on the SpreadsheetBench dataset—a rigorous test for real-world spreadsheet manipulation.

This score means Gemini is no longer just a basic assistant; it is operating at a level approaching a human spreadsheet expert, pushing the boundaries of what generative AI can achieve in enterprise software.

What Gemini Can Do For You

Instead of writing VLOOKUP or INDEX/MATCH, you can now simply tell the AI what you need. Key beta features include:

• Build from Scratch: Generate entirely new, custom-formatted sheets instantly.
• Clean Messy Data: Autonomously format disorganized, raw datasets into clean tables.
• Execute Complex Analysis: Find hidden trends and generate high-level summaries without a single manual formula.

The Bigger Picture: Data for Everyone

This update signals a fundamental shift. The days of writing custom App Scripts or recording complex macros for routine data cleaning might be over.

Most importantly, this democratizes data. Small business owners, marketers, and students can now extract expert-level insights without advanced training. This aligns perfectly with McKinsey & Company’s research, highlighting how generative AI unlocks massive productivity gains for everyone, regardless of technical background.

Read the original announcement here: Google The Keyword Blog