Editor's pick
The variable syntax is brilliant. Changing tax rate from 0.08 to 0.10 instantly updated 500+ formulas. Makes spreadsheets maintainable and formulas self-documenting. Perfect for financial modeling.
Namrit Sheth
Data Analyst
Excel to Google Sheets converter
Convert Excel to Google Sheets and keep the formulas working.
Google imports the file for you. It is the formulas that break: TEXTSPLIT, TEXTBEFORE, AGGREGATE and table references land as #NAME? and #REF!. Formula Foundry's Migration Assistant scans every sheet, rewrites what has a clean Sheets equivalent and flags the rest, so nothing fails quietly.
Add to Google Sheets
Free plan, no credit card, installs in about 30 seconds.
Loading the editor…
Free, in your browser, no signup: paste an Excel formula and the editor underlines every function Google Sheets lacks. The rewrite and the whole-workbook scan run in the Google Sheets add-on, on the free plan.
How to convert Excel to Google Sheets
Import the file, then fix the formulas.
Import the .xlsx into Google Sheets
In Google Drive, upload the Excel file and open it with Google Sheets, or inside a spreadsheet choose File, then Import, then Upload, and pick Replace spreadsheet or Insert new sheet(s). Your values, cell formatting and most charts arrive intact.
Scan the workbook with the Migration Assistant
Open Formula Foundry from the Extensions menu and choose Migration Assistant. It reads every formula on the sheets you pick, groups identical ones, and sorts them into auto-fixable, needs a rewrite, broken after import, and healthy.
Fix the groups, keep control
Click Fix on a group to rewrite all of its cells at once, or Fix all for everything the translator converts cleanly. Functions with no Sheets counterpart are listed with the reason, and Open in editor hands them to you for a manual rewrite.
More than an Excel to Google Sheets converter
Your spreadsheet experience, reimagined.
Excel formulas converted to Google Sheets
What the converter does to five Excel formulas.
In Excel
=TEXTSPLIT(A2, ",")In Google Sheets
=SPLIT(A2, ",", FALSE, FALSE)TEXTSPLIT keeps empty values and splits on the whole delimiter. The two FALSE flags make SPLIT behave the same way instead of using its own defaults.
In Excel
=TEXTBEFORE(A2, "@")In Google Sheets
=REGEXEXTRACT(A2, "^(.*?)@")Sheets has no TEXTBEFORE or TEXTAFTER. A lazy pattern captures everything before the first @; a negative instance number becomes a greedy pattern for the last one.
In Excel
=IF(ISERROR(VLOOKUP(A2, Rates!A:C, 3, FALSE)), 0, VLOOKUP(A2, Rates!A:C, 3, FALSE))In Google Sheets
=IFERROR(VLOOKUP(A2, Rates!A:C, 3, FALSE), 0)The classic Excel 2003 pattern collapses to IFERROR, which both apps support, so the lookup runs once instead of twice.
In Excel
=AGGREGATE(9, 5, B2:B100)In Google Sheets
=SUBTOTAL(109, B2:B100)Option 5 (ignore hidden rows) maps onto SUBTOTAL's 100-series codes. Other AGGREGATE options are flagged for review instead of guessed.
In Excel
=SUM(Sales[Amount])What the Migration Assistant says
Needs a rewrite: the structured reference Sales[Amount] points into an Excel table, which Google Sheets does not have. Replace it with the range, for example SUM(C2:C500). The group is listed with this reason and never auto-fixed.
Turning table references into guessed ranges is how totals go quietly wrong, so this bucket always waits for you.
Excel to Sheets converter, importer, migration tool
Converter, importer, migration tool: two different jobs.
Most pages that promise an Excel to Google Sheets converter convert the file: .xlsx in, Google Sheet out. Google already does that for free with File, then Import, and it keeps your values, formatting and most formulas.
What no file converter touches is the formula layer. Excel has about fifty functions Sheets lacks (TEXTSPLIT, TEXTBEFORE, TEXTAFTER, AGGREGATE, the CUBE family, STOCKHISTORY), plus structured references and spill ranges. Those cells open as #NAME? or #REF!, and in a large workbook you find them one at a time.
Formula Foundry is the second job. The Migration Assistant audits every formula after the import, rewrites the ones with an exact Sheets equivalent and lists the rest with a reason, so the migration ends with a checklist instead of a hunt. The same translator runs the other way inside the Excel add-in when a workbook moves from Sheets to Excel.
Formula Foundry reviews
What our users say
Formula Foundry is genuinely impressive. Simplifying complex formulas, adding variables, snippets, and multi-tab editing inside Sheets is such a game-changer. As someone who has to deal with sheets, dashboards and pipelines every day, this feels like a tool built exactly for the pain points data people deal with.
Pavan Kishore Chaparla
Data Analyst
Variables and vlookup are extremely useful in transferring Excel skills and keeping a sheet clean, as well as processing in fewer steps than I otherwise would have known how.
Jason Tau
Senior Financial Planning Analyst
I found the AI Assistant extremely helpful because it saved me time by generating formulas automatically and suggested improvements I might not have thought of. It made complex tasks much easier and more intuitive, especially for repetitive or complicated formulas.
Anand Kumar Gade
Financial & Reporting Analyst
As a marketer, I always end up back in spreadsheets — forecasting, funnel math, quick models, etc. I'm thrilled Formula Foundry created a productivity tool that actually makes a difference with my critical spreadsheet work.
Megan Wells
Vice President Marketing
My favorite feature is the editor and being able to more easily structure my formulas. The easy readability is a game changer! Also, the variables are super useful when I need to put together a complex report.
Brian Norman
Sales Engineer
Free plan pricing
Start free. Upgrade when it pays for itself.
Free
$0
Free forever
Everything you need to get started — no card required.
Get started freePro
$15/ month
billed annually, or $19 / month billed monthly
Unlimited tabs, snippets, and variables for power users.
Upgrade to ProBusiness
$24/ seat / month
billed annually, or $29 / seat / month billed monthly
Shared snippets, SSO, and team management.
Upgrade to Business
Enterprise. Everything in Business, plus admin controls, custom onboarding & training, dedicated support, and an SLA — tailored to your organization with volume pricing.
Talk to salesAdd Formula Foundry to Google Sheets
Finish the migration with a checklist, not a hunt.
Add Formula Foundry to Google Sheets, open the Migration Assistant on the imported workbook, and fix every broken formula from one report. Free plan, no credit card.
Add to Google Sheets
Free plan, no credit card, installs in about 30 seconds.
Convert Excel to Google Sheets FAQ
Excel to Google Sheets FAQ
- Most do. SUM, IF, VLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, LET and LAMBDA behave the same in both. What breaks is the Excel-only layer: TEXTSPLIT, TEXTBEFORE, TEXTAFTER, AGGREGATE, STOCKHISTORY, WEBSERVICE and the CUBE functions, plus structured references like Sales[Amount] and spill references like A2#. Those cells show #NAME? or #REF! after the import. The manual fixes, one by one
- Upload the .xlsx to Google Drive and open it with Sheets, or use File, then Import inside a spreadsheet. Google converts the file and keeps cell formatting, conditional formats and most charts. Pivot tables, macros, Power Query and some chart types do not carry over, and formulas that use Excel-only functions open as errors, which is what the Migration Assistant fixes.
- The ones with an exact Google Sheets equivalent: TEXTSPLIT to SPLIT, TEXTBEFORE and TEXTAFTER to REGEXEXTRACT, AGGREGATE with the ignore-hidden-rows option to SUBTOTAL, IF(ISERROR()) to IFERROR, VALUETOTEXT to TO_TEXT, and the cleanup of Excel's @ and -- operators. Anything else is listed with the reason it was skipped, so a two-dimensional TEXTSPLIT or a delimiter read from a cell is never turned into a guess.
- Yes. In Sheets choose File, then Download, then Microsoft Excel (.xlsx) to export the file. Open it in Excel with the Formula Foundry add-in and run the Migration Assistant there: it rewrites Sheets-only functions for Excel, such as SPLIT to TEXTSPLIT, JOIN to TEXTJOIN, COUNTUNIQUE to ROWS(UNIQUE(TOCOL())) and ARRAYFORMULA wrappers dropped, and flags QUERY, IMPORTRANGE and GOOGLEFINANCE for a manual rewrite.
- Yes. The Migration Assistant and the formula translator are part of the free plan of the Google Sheets add-on and the Excel add-in, with no credit card. Paid plans add team features and a larger AI allowance; scanning and fixing formulas does not use AI at all.
- Not until you click Fix. Scanning only reads formulas. A fix writes the rewritten formula into exactly the cells of that group, skips any cell that changed since the scan, and reports what landed. Everything else in the workbook stays as it was.