Google Sheets formula generator
Some of the most useful Google Sheets formulas, such as QUERY, FILTER, and ARRAYFORMULA, are also the ones people write least often and forget how to structure. SheetSense lets you describe the result you want in plain English and returns a formula in Google Sheets syntax, with a note on what each part does.
In the workspace you upload your sheet as a CSV or Excel file (download it from Google Sheets first), so the formula uses your real column names. The free Formula Translator works the other way: paste a formula and get it explained.
Worked example: a sentence becomes a QUERY
Sheet layout: column A is Region, column B is Rep, column C is Revenue. The request is: total revenue per region, biggest first.
=QUERY(A1:C,"select A, sum(C) where A is not null group by A order by sum(C) desc label sum(C) 'Revenue'",1)QUERY reads the range with one header row, groups the rows by region, adds up revenue for each group, and sorts the groups from largest to smallest. The where clause drops blank rows so the empty tail of an open-ended range is not grouped as its own line.
How it works
- 01Download your Google Sheet as CSV or Excel, then upload it, or open the sample sheet.
- 02Choose the formula action and describe the result in a sentence.
- 03Copy the Google Sheets formula and read the explanation.
- 04Paste it into a spare cell and compare one result with a figure you can check by hand.
Common questions
- Does it connect to my Google account?
- No. You upload a CSV or Excel export, and the workspace works from that file. Nothing is written back to your Google Sheet.
- Does it write Excel formulas as well?
- Yes. Each generated formula comes in Excel and Google Sheets versions, because functions such as QUERY and ARRAYFORMULA exist only in Google Sheets.
- Is it free?
- Explaining formulas in the translator is free for 5 a day without an account. The workspace formula action needs a free account, which includes 10 AI actions.
Try it on your own formula
The Formula Translator is free for 5 formulas a day, with no account.