Describe what you need, get the Sheets formula.

Google Sheets shares 90% of its formula syntax with Excel, which is great until you hit the 10% that's different. QUERY is its own mini-language. ARRAYFORMULA doesn't exist in Excel at all. IMPORTRANGE has permission behavior nobody explains clearly. And half the tutorials online are written for Excel and don't tell you that.

This tool is tuned for Sheets specifically. Ask for a formula, get a formula that actually works in Sheets, with the Sheets-native function when that's the better choice.

Sheets-specific things we handle

QUERY with the full SQL-ish syntax (SELECT, WHERE, GROUP BY, ORDER BY, LIMIT). ARRAYFORMULA to apply a formula down a whole column. IMPORTRANGE for pulling from other sheets, plus the permission step people always forget. GOOGLEFINANCE for pulling market data. FILTER with regex matching. SPLIT, JOIN, TEXTJOIN, and the array-friendly versions of everything.

A QUERY example, because QUERY is where everyone gets stuck

Ask: “From the Orders tab, show me the total revenue by month for 2025, only for the West region, sorted most to least.”

You get back:

=QUERY(Orders!A:E, "SELECT MONTH(B), SUM(D) WHERE E = 'West' AND YEAR(B) = 2025 GROUP BY MONTH(B) ORDER BY SUM(D) DESC LABEL MONTH(B) 'Month', SUM(D) 'Revenue'", 1)

Plus an explanation of what each clause does, because you're going to need to modify this one day.

When to use Excel vs. Sheets mode

Excel and Sheets handle dates, text, and array behavior differently. The toggle on the generator matters. If you pick Excel mode and paste the result into Sheets, it'll work most of the time, but “most of the time” is how you end up debugging a formula at 11pm.

If you're on Excel, use the Excel Formula Generator instead. Same tool, tuned for the Excel engine.