12 Google Sheets functions missing from Excel in 2026
Excel and Google Sheets have converged on most modern functions — XLOOKUP, FILTER, UNIQUE, LAMBDA all work in both. But Sheets has kept a set of truly unique functions that Excel has never matched. From SQL-like queries to live web scraping to real-time stock prices, these 12 functions are why serious analysts keep both platforms in their toolkit.
📗 Why this list matters for Excel users
This isn't a "Sheets is better" post. Excel wins for large datasets, PivotTables, VBA automation, and enterprise reporting. But when your workflow needs web data, live imports, or SQL-style queries, Sheets does things Excel simply cannot. Smart analysts pick the right tool per task — this list shows you when Sheets is that tool.
Quick navigation — jump to any function
- QUERY — SQL for spreadsheets
- IMPORTRANGE — Live import from Sheets
- IMPORTHTML — Scrape web tables
- IMPORTXML — XPath scraping
- IMPORTDATA — CSV from URL
- GOOGLEFINANCE — Real-time markets
- GOOGLETRANSLATE — In-cell translation
- DETECTLANGUAGE — Auto-detect language
- SPARKLINE — Charts as formulas
- FLATTEN — Reshape 2D to column
- REGEXEXTRACT — Native regex
- IMAGE — Embed from URL
The three categories of Sheets-exclusive functions
The 12 functions on this list fall into three broad categories, each addressing a workflow Excel handles clumsily or not at all:
Web-native functions (IMPORTRANGE, IMPORTHTML, IMPORTXML, IMPORTDATA, GOOGLEFINANCE, IMAGE) — pull live data from URLs and other Sheets files. Excel treats the web as an occasional import source through Power Query. Sheets treats it as first-class data.
Language and text functions (GOOGLETRANSLATE, DETECTLANGUAGE, REGEXEXTRACT) — leverage Google's translation and pattern-matching infrastructure. Excel has no native regex and no built-in translation.
Structural functions (QUERY, SPARKLINE, FLATTEN) — reshape and visualize data through formulas. Excel has features for these tasks but not formulas — meaning Sheets can integrate them into automated workflows in ways Excel can't.
Run SQL-style queries against any range
QUERY is Google Sheets's crown jewel. It lets you write SQL-like queries against spreadsheet data — SELECT specific columns, WHERE conditions match, GROUP BY categories, ORDER BY calculated values. One formula replaces what would take FILTER + UNIQUE + SORT + SUMIFS combined in Excel.
The syntax is a subset of SQL called Google Query Language. You can filter, aggregate, pivot, and sort — all in one formula. Change the query string and the results reshape instantly. No PivotTable required.
Pull data from another Google Sheets file in real time
IMPORTRANGE pulls data from another Google Sheets file into your current sheet. When the source data changes, your import updates automatically. No manual refresh, no Power Query setup, no static snapshots. One formula, live data flow.
The first time you use IMPORTRANGE against a new source, Sheets prompts you to authorize access. After that, the data flows automatically. Combine with QUERY for imported data that's also filtered and aggregated in one formula.
Extract HTML tables or lists from any web page
IMPORTHTML pulls a specific table or list from any publicly accessible web page directly into your sheet. Specify the URL, whether you want a table or list, and which index (1st table, 2nd table, etc.). Sheets fetches it and reshapes it into cells.
The data auto-refreshes periodically (roughly every hour) so your data stays reasonably current. Perfect for tracking published data that updates on someone else's schedule.
Extract specific data from web pages using XPath
IMPORTXML is IMPORTHTML's more precise cousin. Instead of grabbing entire tables, you use XPath queries to extract specific elements — a page title, a product price, a specific paragraph, a list of links. XPath is a query language for XML and HTML documents.
This example extracts every element with the CSS class "price" from the page. Perfect for competitive price monitoring, tracking specific data points across many pages, or building custom scrapers without writing code.
Import CSV or TSV files directly from a URL
IMPORTDATA fetches a CSV or TSV file from any URL and loads it directly into your sheet. No download, no manual paste. Perfect for public datasets, government statistics, or any organization that publishes data as downloadable CSVs.
Sheets fetches the file, parses the CSV, and spills the contents into cells starting at the formula location. When the source CSV updates, the sheet reflects the new data.
Live stock prices, currency rates, and historical data
GOOGLEFINANCE returns real-time or historical financial data for any publicly-traded security. Stock prices, currency exchange rates, mutual fund NAVs, cryptocurrency prices — all in one function. Also handles historical time-series data for analysis.
For currency rates:
For historical prices between two dates:
Translate text between languages using Google Translate
GOOGLETRANSLATE hooks directly into Google Translate to convert text between languages. Specify the source language and target language and Sheets translates the cell contents automatically.
Both source and target language codes are two-letter ISO codes (en, es, fr, de, ja, zh, etc.). Set the source to "auto" and Sheets detects it automatically. Not suitable for professional translation but great for quick understanding, multilingual product catalogs, or bulk translation prep.
Identify the language of any text
DETECTLANGUAGE returns the ISO language code for the given text — "en" for English, "es" for Spanish, "ur" for Urdu, and so on. Perfect pair with GOOGLETRANSLATE for handling multilingual data where you don't know upfront which languages you're dealing with.
Combine with GOOGLETRANSLATE for automated multilingual pipelines:
Create inline mini-charts in a single cell
Excel has Sparklines as a feature (Insert → Sparklines) but Sheets has SPARKLINE as a function — which is dramatically more powerful. Because it's a formula, you can drag it, reference it, embed it in tables, and dynamically change what it displays based on other cells.
The second argument is an options table controlling chart type (line, column, bar, winloss), colors, min/max values, and more. Add a SPARKLINE formula to every row of a table and get instant visual trend indicators — auto-updating as data changes.
Turn any 2D range into a single flat column
FLATTEN takes a 2D range and outputs it as a single column, reading left-to-right, top-to-bottom. Simple operation, but incredibly useful for combining with UNIQUE, SORT, or QUERY when you need to work with all values from a table as one list.
Combine with UNIQUE to get every distinct value across an entire table in one flat list:
Full regex pattern matching without VBA
Sheets has three native regex functions: REGEXEXTRACT (returns the first matching substring), REGEXMATCH (returns TRUE/FALSE), and REGEXREPLACE (substitutes matched patterns). These use standard regex syntax. Excel has no native regex — you need VBA or Power Query M to achieve the same results.
This extracts patterns like "ABC-1234" from any text in A2. For validation with REGEXMATCH:
That's an email validation regex — returns TRUE if the cell contains a valid email format, FALSE otherwise. Same pattern for phone numbers, product codes, ID formats, or any structured text validation.
Display images directly in cells from any URL
IMAGE embeds a visible image directly in a cell from a URL. The image scales to fit, or you can specify dimensions. Perfect for product catalogs, employee photo directories, or any spreadsheet that benefits from visual references alongside data.
With size control:
The second argument controls sizing mode (1 = fit within cell, 2 = stretch to fill, 3 = original size, 4 = custom pixel dimensions). Combine with lookup functions to display different images based on data values.
What Excel does better than Sheets
This list showcases where Sheets wins, but the reverse is equally true. Excel has plenty of functions and features Sheets can't match:
📗 Google Sheets wins
- QUERY (SQL-style queries)
- IMPORTRANGE (live cross-file imports)
- Web-scraping formulas (IMPORTHTML/XML/DATA)
- GOOGLEFINANCE (real-time markets)
- Native regex functions
- SPARKLINE as a formula
- Real-time collaboration
- Version history & comments
📘 Excel wins
- Massive datasets (millions of rows)
- Advanced PivotTables & PivotCharts
- Power Query for ETL workflows
- Power Pivot data models
- VBA macro automation
- Solver for optimization
- Advanced statistical functions
- Enterprise Power BI integration
The right question isn't "Excel or Sheets" — it's "which tool for which task". See our complete Excel vs Google Sheets comparison for a decision framework.
The convergence timeline — what Excel has added recently
Microsoft has been closing the gap over the last few years. Functions that used to be Sheets-exclusive but now exist in Excel:
| Function | Sheets since | Added to Excel |
|---|---|---|
XLOOKUP | 2020 | 2019 (365) — Excel actually added first |
FILTER, UNIQUE, SORT | 2015-2018 | 2019 (365) |
LAMBDA | 2022 | 2022 (365) |
IMAGE | ~2013 | 2023 (365) |
TEXTBEFORE, TEXTAFTER | 2022 | 2022 (365) |
TOCOL (similar to FLATTEN) | N/A | 2022 (365) |
The trend is clear: Excel is catching up on general formulas. But the web-native and Google-ecosystem functions on this list — QUERY, IMPORTRANGE, GOOGLEFINANCE — remain uniquely Sheets. These are unlikely to appear in Excel because they require infrastructure Microsoft doesn't operate.
Analysts who use both Excel and Sheets for different tasks have a genuine edge. Excel for heavy analysis on large datasets, Sheets for real-time collaboration and web-native data. The 12 functions on this list are why keeping Sheets in your toolkit pays off even if Excel is your primary platform.
The Sheets-only functions cheat sheet
| Function | Purpose | Complexity |
|---|---|---|
QUERY | SQL-style queries against ranges | Advanced |
IMPORTRANGE | Live import from other Sheets files | Simple |
IMPORTHTML | Scrape web page tables/lists | Simple |
IMPORTXML | XPath-based web scraping | Advanced |
IMPORTDATA | Load CSV/TSV from URL | Simple |
GOOGLEFINANCE | Real-time market data | Simple |
GOOGLETRANSLATE | Text translation via Google | Simple |
DETECTLANGUAGE | Auto-detect text language | Simple |
SPARKLINE | Inline charts as formulas | Intermediate |
FLATTEN | Reshape 2D range to column | Simple |
REGEXEXTRACT/MATCH/REPLACE | Native regex processing | Advanced |
IMAGE | Embed images from URLs | Simple |
When to open Sheets instead of Excel
Concrete triggers for reaching for Google Sheets over Excel:
You need SQL-like querying. If your analysis has phrases like "sum X where Y = 'APAC' grouped by Z", QUERY handles it in one line. Same task in Excel takes multiple formulas or PivotTable setup.
Your data lives on a web page. Tables, lists, or CSV files hosted online — IMPORTHTML/XML/DATA turn any URL into a live data source in one formula.
Multiple people need to update the same file. Real-time collaboration is Sheets's native mode. Excel supports co-authoring in 365 but Sheets is more polished for this workflow.
You need real-time financial data. GOOGLEFINANCE remains the fastest path to live stock, currency, or crypto prices in a spreadsheet.
You need regex without coding. Regex is a genuinely important capability for data cleanup and validation. Sheets gives it to you natively; Excel makes it a VBA project.
You need in-cell translation. GOOGLETRANSLATE + DETECTLANGUAGE handles multilingual data in ways Excel simply can't without external tools.
Related resources
The full Excel vs Google Sheets picture
Deep comparison of both platforms covering pricing, features, use cases, and decision frameworks for picking the right tool.
Excel vs Google Sheets Comparison → Explore Sheets and Cells →Frequently asked questions
Can I use Google Sheets functions in Excel?
No, Google Sheets exclusive functions like QUERY, IMPORTRANGE, GOOGLEFINANCE, and SPARKLINE do not work in Excel. Excel has its own set of functions and features, some of which achieve similar results through different means — for example Power Query for data import, Excel's Sparklines feature for mini charts, and Stock data types for market data. But the exact function syntax is different and workflows are not directly transferable.
What is the QUERY function in Google Sheets?
QUERY is Google Sheets's most powerful function — it lets you run SQL-like queries against spreadsheet data. Syntax: =QUERY(data, "SELECT A, SUM(B) WHERE C = 'APAC' GROUP BY A ORDER BY SUM(B) DESC"). It combines filtering, aggregation, sorting, and pivoting in one formula. Excel has no direct equivalent — you would need to combine FILTER, GROUPBY, and SORT functions or use Power Query.
Does Excel have anything like IMPORTRANGE?
Excel does not have a direct IMPORTRANGE equivalent. The closest option is Power Query which can connect to another Excel workbook, but requires more setup and does not update in real time. IMPORTRANGE in Sheets pulls live data from another Sheets file with one formula — =IMPORTRANGE("spreadsheet_url", "Sheet1!A1:D100") — and updates automatically when the source changes.
Can Excel scrape data from web pages like IMPORTHTML?
Excel can scrape web data through Power Query (Data → Get Data → From Web), but not through a simple formula. Google Sheets's IMPORTHTML scrapes a specific table or list from a web page with one formula: =IMPORTHTML("url", "table", 1). This makes Sheets significantly better for quick web data extraction, especially for stock prices, sports data, and other regularly updated tables.
Which platform is better for real-time data — Excel or Google Sheets?
Google Sheets is significantly better for real-time data. GOOGLEFINANCE returns live stock prices, currency rates, and market data with one formula. IMPORTHTML and IMPORTDATA scrape live web sources. IMPORTRANGE pulls from other Sheets files in real time. Excel has Stock data types and Power Query for similar tasks but requires more setup and less flexibility for ad-hoc real-time queries.
Does Google Sheets have regex functions?
Yes, Google Sheets has three native regex functions: REGEXEXTRACT extracts matching text, REGEXMATCH returns TRUE/FALSE if a pattern matches, and REGEXREPLACE substitutes matched text. These work with standard regex syntax. Excel does not have native regex functions — you would need VBA custom functions or Power Query M language to achieve similar results.
What can Excel do that Google Sheets cannot?
Excel handles significantly larger datasets (millions of rows vs Sheets's ~10 million cell limit which becomes slow much earlier), has more sophisticated PivotTables, offers advanced statistical and engineering functions, includes Solver for optimization problems, supports true macros through VBA, and integrates with Power BI for advanced analytics. Excel is generally better for large-scale analysis and enterprise reporting. See our Excel vs Google Sheets comparison for a complete breakdown.
Is Google Sheets suitable for professional analysis work?
Yes for many use cases. Sheets handles datasets up to a few hundred thousand rows well, integrates seamlessly with Google Workspace tools, and has the unique functions listed here that Excel cannot match. Professional analysts use Sheets for collaborative work, real-time data pipelines, and web-native analysis. Excel remains preferred for enterprise reporting, massive datasets, and Power BI-integrated workflows.
Can I import Excel formulas directly into Google Sheets?
Mostly yes. Modern Sheets supports most Excel functions with identical syntax — XLOOKUP, FILTER, UNIQUE, SORT, IFS, TEXTJOIN, and hundreds of others work identically. Excel-specific functions like some advanced statistical functions or certain Power Query M functions do not convert. When opening an Excel file in Sheets, functions that aren't supported get flagged automatically.
Bottom line: Excel and Sheets have converged on most modern functions, but these 12 remain uniquely Sheets. Web-native imports, SQL queries, real-time market data, and native regex — capabilities that make Sheets worth keeping in your toolkit even if Excel is your primary platform.