Convert an Excel formula to Google Sheets (or vice versa)
Convert spreadsheet formulas between Excel and Google Sheets, with a callout of any function that doesn't exist in the target and the workaround used.
Fill in the Template
0 / 5 filledYour Built Prompt
Updates live as you typeConvert this formula from {{from_app}} to {{to_app}}.
Original formula: {{formula}}
What it's meant to do: {{intent}}
Optional: any cell references / sheet names that change between the two: {{ref_changes}}
Return:
1. CONVERTED FORMULA, ready to paste.
2. WHAT'S DIFFERENT: a 1-line note on any function that doesn't exist in the target app + the workaround used (e.g. ARRAYFORMULA in Sheets ↔ array entry in Excel; XLOOKUP availability).
3. ANY GOTCHA: locale (comma vs semicolon separator), date format quirks, or text-string differences between the two.
AU English.Fill in the required fields above to copy or run this prompt.
Tags
Community Feedback
0 commentsRelated Prompts
More in CodingDebug an error message — paste it, get the fix
Paste any error message, get a plain-English explanation, the most likely cause, and a step-by-step fix. Works for code, Zapier, Excel, Webflow, anywhere.
Generate a regex from a plain-English description
Plain-English in, ready-to-paste regex out. Includes a walkthrough, test results against your sample inputs, and known limitations.
Write a Zapier filter step from a plain-English condition
Plain-English condition in, Zapier-UI-ready filter step out. Names operators exactly as Zapier shows them and warns about the case-sensitivity / blank-value gotchas that fail in production.
Build a spreadsheet formula from plain English
Plain-English description in, paste-ready spreadsheet formula out — Excel or Google Sheets dialect. Includes the "when it breaks" caveats most AI prompts skip.