Copy Excel Formulas to Google Sheets Without Errors

To copy a formula from Excel into Google Sheets, copy the formula cell in Excel, select the destination cell in Sheets, and paste. Then check the result and references: compatible formulas usually transfer, but function names, separators, and cell references can behave differently between the two programs. You will need access to the Excel workbook and a Google account with permission to edit the destination sheet.

What You’ll Need

The Excel workbook open in Microsoft Excel for Microsoft 365 on Windows, or saved as an Excel workbook file such as .xlsx.
The Google Sheets spreadsheet open in a web browser, with editing access to the destination cells.
A clear idea of whether you are transferring one formula, a range of formulas, or a whole workbook. For a single formula or a small range, copy and paste is usually quickest. For a workbook, importing the file is often more practical.

Step-by-Step

Check the Excel formula and its inputs. In Excel, select the cell containing the formula and inspect the formula bar above the worksheet. Confirm that it calculates correctly and note which input cells it uses. If the formula refers to other sheets, named ranges, tables, or external workbooks, note that too; those references may need attention after transfer. For example, with unit prices in B2:B6 and quantities in C2:C6, a formula in D2 multiplying the first price by the first quantity could be =B2*C2. If B2 is 12 and C2 is 3, the result is 36.
Open the destination Google Sheet. In a browser, go to Google Sheets and open the spreadsheet where the formula belongs. Check that you are using the right account and that you can edit the sheet. Find the destination cell and confirm its row and column; pasting into the wrong location can produce a formula that looks valid but points to the wrong inputs.
Copy the formula cell in Excel. Click the cell once, then press Ctrl+C on Windows. On a Mac, use Command+C. If you want to transfer formulas for several rows or columns, select the full range before copying. Do not select only the displayed result if you need the formula itself; copy the actual worksheet cell.
Paste into Google Sheets. Click the top-left destination cell and press Ctrl+V on Windows or Command+V on a Mac. If a browser prompt asks you to allow clipboard access, allow it for the paste to work. For a range, make sure the destination has enough empty cells to receive it. Pasting a copied range can transfer cell formatting as well as formulas, so check whether the destination appearance changed.
Check the pasted formula in the formula bar. Select the destination cell in Sheets and look at the formula bar. Confirm that the entry begins with an equals sign and refers to the intended cells. A formula copied from another application may not transfer exactly as expected, especially if it uses a newer Excel function, a structured table reference, or a workbook-specific name. Do not rely on the displayed value alone: a pasted constant can show the right number without retaining the calculation.
Verify the result against the source. Compare the result in Sheets with the result in Excel, using the same input values. For example, with quantities in B2:B6 equal to 2, 4, 1, 3, and 5, a formula that totals those cells is =SUM(B2:B6); the result should be 15. If the values differ, inspect the references and make sure the cells in the copied formula point to the same data in Sheets.
Copy the formula down or across if needed. If you copied a formula for one row and need it in more rows, use the Sheets fill handle: select the formula cell and drag the small blue square at its lower-right corner through the intended cells. You can also copy the cell and paste into a selected range. Check the first and last filled formulas to confirm that relative references moved as expected and fixed references stayed fixed.
Use a file import for a larger transfer. If you need many formulas, multiple tabs, or much of the workbook, save the Excel file and, in Google Sheets, choose File > Import > Upload. Select the .xlsx file and choose an import option, such as creating a new spreadsheet or inserting sheets into the current spreadsheet. Read the choices in the import window before confirming, because replacing a spreadsheet can overwrite its existing contents. After importing, check formulas and key results; importing does not guarantee every Excel feature will work identically in Sheets.
Save and test a working copy. Google Sheets saves changes automatically, but keep the original Excel file unchanged until you have reviewed the transferred formulas. If the sheet is important, duplicate the destination tab or make a copy of the spreadsheet before doing a large paste. Test a few representative calculations, including formulas at the top and bottom of a transferred range.

If direct copy and paste does not retain the formula, copy its text from Excel’s formula bar instead. Select the formula in the bar, copy it, click the destination cell in Sheets, and paste. Check that the pasted text begins with an equals sign, then press Enter. This method is useful for a single formula, but it pastes the reference text as written rather than acting like a normal cell copy. For instance, a reference to row 2 will not automatically become a reference to row 3 just because you paste the text into the next row.

Common Mistakes

Copying the result instead of the formula. Copying a number from a formula cell or using a values-only paste leaves you with a fixed value. Select the original cell and confirm the formula bar shows a formula before copying. If you pasted a value, repeat the transfer using ordinary Ctrl+V or Command+V.
Assuming cell references will always adjust correctly. A normal copy within a worksheet typically adjusts relative references, but references can change in ways that are easy to miss when moving between programs or sheets. Compare the pasted formula with its Excel source and test the result. References containing dollar signs are absolute or partly fixed; preserve them if the calculation depends on a constant cell.
Expecting every Excel function to work in Sheets. Many common functions are shared, but some functions, add-ins, and workbook features are specific to Excel or have different support in Sheets. An unsupported function may produce an error or need to be rewritten with a Sheets-compatible function. Look up the function in Google Sheets Help before changing the calculation.
Ignoring names and table references. Excel formulas can use named ranges or structured references such as table column names. Those names may not be available or interpreted the same way in Sheets. Check whether the destination has equivalent named ranges, or replace the references with ordinary cell ranges after confirming the correct data boundaries.
Pasting over existing data. A copied range fills cells to the right and below the destination. Confirm the full paste area is safe before pasting, particularly when transferring multiple columns or rows. If you overwrite something, use Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then choose a clear destination.
Confusing a formula error with a bad transfer. An error may come from missing source data, a misspelled sheet name, or a division by zero rather than from copying itself. Compare the formula text and its input cells before rebuilding the formula.

Tips

Transfer a range when formulas follow the same pattern. Copying several adjacent formula cells together can preserve the pattern and reduce manual work. Check both an early and a later row after pasting, since a reference that is correct in the first row can drift incorrectly farther down.
Separate formula transfer from formatting. If the pasted cells bring unwanted fonts, colors, or borders, undo the paste and use a paste option that transfers formulas only if the option is available in the paste menu. Otherwise, copy the formula text from the formula bar and enter it in Sheets, then apply formatting separately.
Keep a conversion note for complicated workbooks. Record any Excel-only functions, named ranges, external links, or table references you had to replace. This makes later updates easier and helps another editor understand why a Sheets formula differs from the original.
Check locale-related syntax. Spreadsheet locale settings can affect number formats and the separator used between function arguments. If Sheets reports a formula parse error, check the spreadsheet locale under File > Settings and compare the formula syntax with formulas already working in that sheet. Do not change separators blindly; first confirm the locale and function syntax Sheets expects.
Use import for workbook structure, not as a guarantee of perfect conversion. Importing an .xlsx file can be convenient when you need several worksheets, but review charts, formatting, formulas, and features such as macros separately. Excel VBA macros do not become Google Sheets formulas, and they do not run as native Sheets functions.

Troubleshooting

The formula appears as plain text. Select the cell and check whether the entry starts with an equals sign. If it does but Sheets displays the characters instead of calculating, the cell may be formatted as plain text or the formula may contain a leading apostrophe. Change the cell format to Format > Number > Automatic, remove any leading apostrophe, and re-enter the formula. Press Enter to make Sheets evaluate it.

Sheets shows a formula parse error. Check for unsupported function names, missing parentheses, extra spaces or characters, and argument separators that do not match the sheet’s locale. Compare the formula with a similar working formula in Sheets. If the formula uses an Excel-specific feature, replace that part with a supported Sheets function or a direct range reference, and verify the new result using known input values.

The result is different from Excel. Compare the exact references in both formula bars, then compare the input values cell by cell. Look for shifted rows or columns, blank cells, numbers stored as text, and different date or decimal interpretations. If the formula depends on a volatile function or external data, its result can also differ because the two programs recalculate or retrieve data differently.

The paste does nothing or transfers only part of the range. Confirm that Excel’s copy outline is still visible, return to Sheets, click the intended destination, and paste again. If the clipboard has been replaced by another copy action, recopy the range. For very large selections, use the import method instead, or transfer the data in smaller ranges.

A sheet name or named range is not recognized. Confirm that the referenced tab exists in the destination spreadsheet and that its name matches the formula. If a name defined in Excel did not carry over, either create an equivalent named range in Sheets or update the formula to use the correct cell range. Recheck the result after changing it.

Frequently Asked Questions

Can I copy and paste an Excel formula directly into Google Sheets?
Yes. Select the formula cell in Excel, copy it, and paste into a destination cell in Sheets. Then inspect the formula bar and compare the result, because compatibility and reference behavior depend on the formula and workbook structure.

Will cell references change when I paste a formula?
They may. Relative references can shift when a formula is copied to a different position, while references marked with dollar signs are fixed in the specified row or column. Check the pasted formula rather than assuming all references stayed the same.

Can I copy an entire Excel workbook into Google Sheets?
You can upload an .xlsx file using File > Import > Upload and choose an import destination. Review the import options first, then check formulas and workbook features after conversion. Macros and some Excel-specific features may not transfer as working Sheets features.

Why does my formula show instead of calculating?
The destination may be formatted as plain text, or the pasted entry may have a leading apostrophe. Set the cell to Format > Number > Automatic, remove the apostrophe if present, and re-enter the formula.

Do I need to change commas in an Excel formula?
Not necessarily. The expected argument separator can depend on the spreadsheet locale, so check File > Settings and an existing working formula if Sheets reports a parse error. Do not replace separators until you know which syntax the destination sheet uses.

Can I copy formulas from Excel for the web?
Yes. The basic copy-and-paste process is similar: select the cell or range, copy it, switch to Sheets in the browser, and paste. If clipboard permissions or browser behavior prevent the transfer, copy the formula text from Excel’s formula bar or import the workbook file instead.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.