Excel ↔ Google Sheets Formula Converter
Paste a formula, pick a direction, get the translated version plus a list of functions that need manual attention. Free, no signup, runs in your browser.
Compatibility check
ARRAYFORMULANot supportedGoogle Sheets only. Excel 365 has native dynamic arrays — drop the ARRAYFORMULA wrapper.
Use instead: Drop wrapper — Excel 365 auto-spills
1 incompatible · 0 needs-review · 0 clean
Need a whole new formula?
Describe what you want in plain English — FormulaPad writes the formula for either platform.
Generate a formulaFAQ
Will every Excel formula work in Google Sheets?
Most formulas convert cleanly. Exceptions: Excel-only dynamic array functions (TEXTBEFORE, TEXTAFTER, WRAPROWS, CHOOSEROWS), Power Query imports, and VBA macros. This tool flags the problem spots.
Will my Google Sheets formulas work in Excel?
Yes for core spreadsheet functions. No for IMPORTRANGE, QUERY, ARRAYFORMULA wrapper (drop it — Excel 365 auto-spills), GOOGLEFINANCE, GOOGLETRANSLATE, IMPORTXML, IMPORTHTML. The converter auto-rewrites the common ones.
What does the converter do with ARRAYFORMULA?
When converting Sheets → Excel, we strip ARRAYFORMULA — Excel 365 has native dynamic arrays that auto-spill. The inner formula works unchanged.
Can the converter handle regex functions?
Partially. REGEXMATCH/EXTRACT/REPLACE have no direct Excel equivalent — we flag them and suggest TEXTBEFORE/AFTER, SUBSTITUTE, or Power Query.
Is this a perfect conversion tool?
No — perfect conversion is impossible without knowing your sheet structure. This tool does 80% of common replacements and flags the rest for manual review.