In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Translate a Formula Between Excel and Google Sheets
Prompt
Source app and version: {{SOURCE_APP}}
Target app and version: {{TARGET_APP}}
The formula or formulas to convert: {{FORMULAS_TO_CONVERT}}
Any named ranges, tables or add-ins the formulas rely on: {{DEPENDENCIES}}
For each formula:
1. Give the converted formula in a code block.
2. Say whether the conversion is exact, approximate or impossible. If approximate, name the difference in behaviour (for example how blanks, text numbers, error handling or array spilling differ).
3. Flag functions that exist only in one app (for example Excel structured table references and TAKE; Sheets QUERY, IMPORTRANGE, ARRAYFORMULA and SPLIT) and give the closest alternative, or say there is none.
4. Note locale separators: commas versus semicolons.
Finish with a short test plan: three inputs I should try in both apps and the matching outputs. State assumptions, and don't claim a function exists in a version you aren't certain about; tell me to check the official function list for my exact version.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Translate a Formula Between Excel and Google Sheets” is a free prompt for ChatGPT in the Productivity category, 167 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SOURCE_APP}}, {{TARGET_APP}}, {{FORMULAS_TO_CONVERT}}, {{DEPENDENCIES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 7 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.