Google Sheets IMPORTRANGE From the Same Sheet?

No: IMPORTRANGE is intended to bring cells into a Google Sheets file from a different spreadsheet file. To reuse data in the same file, whether it is on the current tab or another tab, use an ordinary cell or range reference instead; it updates as the referenced cells change and does not need an import connection.

What “same sheet” can mean

People use “same sheet” to describe two different situations: a range on the same tab, or a range on another tab in the same spreadsheet file. Neither normally calls for IMPORTRANGE. A Google Sheets file can contain many tabs, but formulas on those tabs can refer to one another directly. IMPORTRANGE is useful when the source data lives in a separate Google Sheets file.

This distinction matters because a tab is not a separate spreadsheet. A tab named “Inventory” and a tab named “Summary” are both part of one file. You can reference Inventory from Summary without granting access or connecting files. If you are unsure whether you have one file or two, check whether the tabs appear along the bottom of the same browser window and share one spreadsheet URL.

Reference a range on the current tab

To display a local range elsewhere on the same tab, enter a range reference in a blank cell where the results can expand. Suppose the source values are in A1:C10 and the formula goes in E1; enter =A1:C10. Google Sheets displays the referenced range as an array. Leave enough empty cells to the right and below the formula, or the results may be blocked.

For a single value, refer to its cell, such as =A1. You can also use local references inside other formulas. For example, a total, lookup, or conditional calculation can use the original cells directly instead of making a duplicate table. A formula that points to its own cell, or to a range containing that formula, creates a circular reference. For instance, placing a formula in A1 that refers to A1:C10 includes the formula cell and cannot produce the intended copy.

A direct reference is live: if the source value changes, the result changes too. It is not a one-time copy and it does not preserve a separate snapshot. If you need a fixed record of values, copy the range and use Edit > Paste special > Values only, rather than relying on a formula.

Reference a different tab in the same file

Use the tab name followed by an exclamation mark and the cell or range address. Suppose the source tab is named Raw Data, its values are in A1:D100, and you want the output to begin in A1 on the Summary tab. Enter ='Raw Data'!A1:D100 on Summary. The single quotation marks are needed because the tab name contains a space. For a tab name without spaces or special characters, a reference such as =Data!A1:D100 works.

If the tab name contains an apostrophe, double that apostrophe inside the quoted name. For example, a tab named Manager’s Data is referred to with the sheet name written as 'Manager''s Data' before the exclamation mark. When you type an equals sign and select a cell on another tab, Sheets can build the reference for you; finish the formula and press Enter.

As with a same-tab range, an array reference needs a clear destination area. If Summary already contains text or formulas where the referenced cells would appear, Sheets cannot expand the result through those occupied cells. Choose a clean area or use a formula that returns only the rows and columns you need.

Filter or reshape local data without importing it

Sometimes “import” really means “show a useful subset of the data.” You can do that with functions applied to a local range. For example, if A2:D100 contains records and column D contains quantities, this formula returns the rows whose quantity is greater than zero: =FILTER(A2:D100,D2:D100>0). Put it in a clear output area, because the returned rows and columns expand from the formula cell.

For a query-style selection, suppose A1:D100 has a header row and column D contains numeric quantities. Enter =QUERY(A1:D100,"select A, C where D > 0",1) in an empty cell. This returns columns A and C only for rows where D is above zero; the final 1 tells QUERY that the input has one header row. QUERY and FILTER operate on the data already in this file, so they do not create an external spreadsheet connection.

Choose the simplest method that matches the goal. A direct reference mirrors cells; FILTER selects rows by a condition; QUERY can select, sort, group, or reshape data. These formulas are recalculated when their inputs change, so they are better suited to a live report than a manually copied snapshot.

When IMPORTRANGE is the right tool

Use IMPORTRANGE when the source is in a different spreadsheet file and you want its data to appear in the current file. For example, suppose another spreadsheet contains a tab named Orders with data in A1:C200, and you put the formula in an empty destination area. The structure is =IMPORTRANGE("spreadsheet_url","Orders!A1:C200"). Replace spreadsheet_url with the source file’s URL or spreadsheet ID, and replace the range string with the actual tab and cells.

The first time a destination file connects to a source file, Sheets may show a #REF! message with an option to allow access. The person entering the formula must have permission to view the source and approve the connection. After access is granted, other formulas can use the imported results. A local tab reference does not require this access step because it stays within the same file.

IMPORTRANGE can be useful when different teams maintain separate files, or when a report should draw from a central source without copying its data by hand. It adds a link between files, however, so changes to the source, access permissions, or its tab and range names can affect the destination. Avoid adding an external import layer when both ranges already belong to one spreadsheet.

Common errors and how to fix them

#REF! with an access message: This usually concerns a cross-file IMPORTRANGE connection. Confirm that you can open the source file, then choose Allow access in the formula cell if prompted. For data in another tab of the same file, replace the import with a direct tab reference.
“Array result was not expanded” or a blocked result: Clear cells in the intended output area. A range formula needs space for every returned row and column; even a stray value can prevent expansion.
Formula parse error: Check the tab name, punctuation, quotation marks, and range address. Names with spaces need single quotes around the tab name in a reference. In some spreadsheet locales, formula arguments use semicolons rather than commas; use the separator configured for the file if a formula copied from elsewhere will not parse.
Circular dependency: Check whether the formula’s output cell is included in the range it refers to. Move the formula outside the source range or adjust the referenced cells so the formula does not depend on its own result.
Wrong or incomplete data: Verify the tab name and start/end cells. A range ending at row 100 will not include new records added below row 100. If the source grows, consider a suitable open-ended range or deliberately expand the range, while checking that the output has enough room.

Performance and spreadsheet design

For ordinary same-file reuse, direct references are typically simpler to understand and maintain than an external import. Keep a clear source tab for raw data and separate report tabs for summaries. This makes it easier to see which cells are inputs and which are calculated outputs, and lowers the chance that someone will overwrite source values with a formula result.

Large formulas and broad ranges can still make a spreadsheet harder to manage. A reference to a very large range may require Sheets to evaluate more cells than necessary, particularly when several formulas repeat the same work. Prefer a range sized to the actual data when practical, and avoid putting an array formula over cells that people are expected to edit. If a report needs a particular subset, filter or query the source rather than duplicating an entire tab without a reason.

Also consider whether a live result is appropriate. A live reference changes when the source changes, which is usually desirable for a dashboard but not always for an audit trail or dated report. For a snapshot, create a deliberate values-only copy and label it with the relevant date. That makes the difference between a changing calculation and a preserved record clear to future editors.

Frequently Asked Questions

Can IMPORTRANGE import from another tab in the same Google Sheets file?
Use a direct reference instead. If the source tab is named Data and the range is A1:C10, refer to it as =Data!A1:C10 from the destination tab. IMPORTRANGE is intended for data in another spreadsheet file.

Can I use IMPORTRANGE to copy cells on the same tab?
There is no need to import them. Reference the range directly, such as =A1:C10, from an empty destination area on that tab. Do not include the formula cell in its own source range.

Does a direct reference update automatically?
Yes. A formula reference reflects changes to the cells it points to as Sheets recalculates the spreadsheet. It is not a stored, independent copy of the original values.

Why does my same-file reference show a parse error?
Check the tab name and the punctuation. Put names containing spaces in single quotes, then add an exclamation mark and the range. Also check whether your locale expects semicolons instead of commas between function arguments; ordinary cell references themselves do not need function-argument separators.

How do I make a permanent copy rather than a live reference?
Copy the source cells, then use Edit > Paste special > Values only in the destination. This stores the current values rather than formulas that continue to follow the source.

The practical rule

If the source and destination are tabs in one Google Sheets file, use a direct range reference, FILTER, QUERY, or another suitable local formula. If the source is a separate spreadsheet file, use IMPORTRANGE and authorize the connection when prompted. This simple distinction avoids unnecessary permissions, makes formulas easier to troubleshoot, and helps readers know whether a result is a live link or a fixed copy.

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.