SheetQuery

SheetQuery is a Google Sheets add-on that runs SQL directly on sheet ranges, supporting joins, window functions, CTEs, bulk updates, deletes and inserts. Priced pay as you go per query.

SheetQuery is a Google Sheets add-on that lets you run SQL queries directly against your spreadsheet data. Instead of working through spreadsheet formulas, you write SELECT, UPDATE, DELETE and INSERT statements that reference sheets by name and range, for example "Employees!A1:N1001?headers=1". The tool then executes the query against that range and returns the result, so the full expressive power of SQL becomes available inside a familiar Sheets environment. The feature set is built around the harder parts of spreadsheet work. SELECT statements support joins and unions across multiple sheets, window functions and common table expressions, which makes it possible to aggregate and compare data that lives in separate tabs. UPDATE handles bulk edits with complex filtering and dynamic calculations, DELETE removes rows that match multi condition logic, and INSERT can merge data from several sheets or pull JSON from an API and map fields into columns. For analysts who already think in SQL, this removes the need to rebuild logic in nested formulas. In practice, the tool is aimed at data analysts, operations teams and spreadsheet heavy finance or reporting groups who keep working data in Google Sheets but need relational style analysis. The workflow is query first: point a statement at a sheet range, run it, and review or apply the result, which keeps the spreadsheet as the system of record while SQL handles the heavy lifting. It sits alongside spreadsheet native pivot tables and query functions as a more capable option for multi sheet joins and bulk maintenance, and alongside BI tools as a lighter, in place alternative that does not require exporting data. Access is arranged through the Google Workspace Marketplace and priced on a pay as you go basis: credits are purchased and consumed per query, with no monthly subscription. That model suits occasional or bursty analysis better than a recurring seat license, though heavy users should estimate query volume before committing.