However, IMPORTRANGE does have complex requirements and a few limitations<\/b>. It is an easy function for spreadsheet masters, but for inexperienced users it can be confusing.<\/p>\n
In this article, we\u2019ll cover possible uses of IMPORTRANGE, how to implement it, as well as its pros and cons. We\u2019ll also see how Sheetgo, an AI-powered data automation platform, can be the perfect <\/b>IMPORTRANGE alternative<\/b><\/a> to level up your spreadsheet data management.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what” _builder_version=”4.27.6″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n IMPORTRANGE is a function that imports values from a range of cells from one spreadsheet to another<\/strong>. All you need is access to the source spreadsheet and its URL.<\/p>\n Given Google Sheets\u2019 cloud-based infrastructure, IMPORTRANGE is very simple. Every file has a unique URL, so you can reference individual files by including the file\u2019s \u201ckey\u201d (more on this later). You then add specificity by referencing a page and a cell range within this file.<\/p>\n IMPORTRANGE is great for one-time and sporadic data imports from one sheet to another<\/strong>. You can use it to carry out simple data transfers such as:<\/p>\n Despite all its power, it also has some drawbacks. For example, it\u2019s not recommended to perform multiple imports across multiple spreadsheets.<\/p>\n [\/et_pb_text][et_pb_video src=”https:\/\/www.youtube.com\/watch?v=yjEeix2Du30″ _builder_version=”4.24.1″ _module_preset=”default” min_height=”355.3px” custom_margin=”30px||30px||false|false” custom_padding=”||0px|||” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_video][et_pb_text module_id=”how” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To learn how to use IMPORTRANGE in Google Sheets, it\u2019s important to understand its syntax and its required parameters.<\/p>\n [\/et_pb_text][et_pb_text module_id=”syntax” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =IMPORTRANGE(spreadsheet_url, range_string)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, to import a range of data from another spreadsheet, you need only two things:<\/p>\n Both of these parameters are pretty self explanatory but they are still worth going over.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are two ways to include this information:<\/p>\n Below is a complete URL with the spreadsheet key in bold.<\/p>\n https:\/\/docs.google.com\/spreadsheets\/d\/1sqWKxq4mbsJVqy2mZbeV2H7MWF9TZ2V-yU6Ne0NGL0g<\/b>\/<\/p>\n If you want to only copy the spreadsheet<\/b> key<\/strong> this is what the formula would look like:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =IMPORTRANGE(\u201c1sqWKxq4mbsJVqy2mZbeV2H7MWF9TZ2V-yU6Ne0NGL0g\u201d, range_string)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The range string is the cell range that you want to import<\/b> from the source spreadsheet. You can specify the sheet name, or you can omit it to have IMPORTRANGE import the cell range from the first sheet.<\/p>\n As with the URL, the range string must be included between quotation marks<\/b>. This is what the formula would look like with a specific sheet name within the range string:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =IMPORTRANGE(\u201c1sqWKxq4mbsJVqy2mZbeV2H7MWF9TZ2V-yU6Ne0NGL0g\u201d, \u201cSheet2!A:B\u201d)<\/p>\n [\/et_pb_text][et_pb_text module_id=”importrange” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n For this example, let\u2019s compare sales team performance in 2020 and in 2021 to generate a performance report.<\/p>\n First thing to do is to use IMPORTRANGE to transfer the 2020 sales performance column into the 2021 sales sheet. This will enable us to compare the data directly.<\/p>\n The screenshot below shows the 2020 data to transfer. The exact range we want to import is \u201cSales 2020!C2:C19\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/IMPORTRANGE-GS-1.png” alt=”IMPORTRANGE Google Sheets example \u2014 Sales 2020 sheet with the Total sales 2020 column C2:C19 to import” title_text=”Sales 2020 sheet with the Total sales 2020 column C2:C19 to import” align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this case, the entire function should be:<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =IMPORTRANGE(\u201c1hrH0ix0aqO9okS4T5mL_Atte8D_iKOzmSF4h_weDDhA\u201d,\u201dSales 2020!C2:C19\u2033)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The first time the function runs it will return an error and you will need to link your two sheets. Click Allow access<\/b> to fix it.<\/p>\n The function imports data and displays it in the sheet, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/IMPORTRANGE-GS-2.png” alt=”IMPORTRANGE Google Sheets example \u2014 Sales report 2021 with the 2020 totals imported into column D by IMPORTRANGE” title_text=”Sales report 2021 with the 2020 totals imported into column D by IMPORTRANGE” align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that the two datasets are in one place, I can calculate key metrics for my performance report. For example I could analyze sales trends between 2020 and 2021.<\/p>\n Keep in mind that data transfers occur almost instantly for small datasets. But naturally, larger datasets will take longer.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-use-importrange-step-by-step” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It should first be noted that in order to use the IMPORTRANGE function in Google Sheets you need to know the URL. All files saved on your Google Drive have a unique URL, which is what allows you to \u2018refer\u2019 to the spreadsheet. Depending on the data you wish to refer to, you can specify the page or range within the importing spreadsheet.<\/p>\n Let\u2019s say we want to import students scores from file \u2018Assignment Scores\u2019 into \u2018Full Student List\u2019:<\/p>\n 1.<\/strong> Go to the Google Drive folder where your exporting spreadsheet is, and right click to \u201cGet link\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-drive-get-link.webp” alt=”IMPORTRANGE in Google Sheets \u2014 Google Drive right-click menu on the Assignment Scores file with Get link highlighted” title_text=”Google Drive right-click menu on the Assignment Scores file with Get link highlighted” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Make sure you click on \u201cCopy link\u201d too.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-copy-link.webp” alt=”IMPORTRANGE in Google Sheets \u2014 Get link dialog showing the spreadsheet URL and the Copy link button” title_text=”Get link dialog showing the spreadsheet URL and the Copy link button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Another simpler and faster way is to open the exporting spreadsheet and click on the address or URL bar to select the link.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-copy-url-bar.webp” alt=”IMPORTRANGE in Google Sheets \u2014 spreadsheet URL selected in the browser address bar above the Assignment Scores sheet” title_text=”Spreadsheet URL selected in the browser address bar above the Assignment Scores sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Now that the link is copied, go to the importing spreadsheet and paste it in the spreadsheet_url<\/strong> variable of the IMPORTRANGE formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-paste-url-in-formula.webp” alt=”IMPORTRANGE in Google Sheets \u2014 =IMPORTRANGE( typed in cell G2 of the Full Student List with the spreadsheet_url and range_string hint” title_text=”=IMPORTRANGE( typed in cell G2 of the Full Student List with the spreadsheet_url and range_string hint” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Then, the range_string<\/strong> can be added in two ways. First, you simply select the range you wish to import and then copy the range from the far-left. Here, E2:E41.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-select-range.webp” alt=”IMPORTRANGE in Google Sheets \u2014 score column E2:E41 selected in the Assignment Scores sheet” title_text=”Score column E2:E41 selected in the Assignment Scores sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> A second way is to name the range and save it for further use. For this, you would need to click on the arrow next to E2:E41 and click on \u201cManage named ranges\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-manage-named-ranges.webp” alt=”IMPORTRANGE in Google Sheets \u2014 Manage named ranges option in the range box menu” title_text=”Manage named ranges option in the range box menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 7.<\/strong> Add the name of your range to the field in the pop-up window. In this example, I’ll name it ‘Score’. Check your range and name are correct before clicking Done<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-name-range.webp” alt=”IMPORTRANGE in Google Sheets \u2014 Named ranges panel with the range named Score for Sheet1!E2:E41″ title_text=”Named ranges panel with the range named Score for Sheet1!E2:E41″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 8.<\/strong> Now, try typing in \u2018Score\u2019 as your range_string<\/strong>. Remember to add quotation marks on either side as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-named-range-formula.webp” alt=”IMPORTRANGE in Google Sheets \u2014 IMPORTRANGE formula with the spreadsheet URL and the named range Score in cell G2″ title_text=”IMPORTRANGE formula with the spreadsheet URL and the named range Score in cell G2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 9.<\/strong> Now press the return key. You may get a message asking you to connect these sheets. Simply click on \u201cAllow access\u201d to connect them.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-allow-access.webp” alt=”IMPORTRANGE in Google Sheets \u2014 #REF! error with the message You need to connect these sheets and the Allow access button” title_text=”#REF! error with the message You need to connect these sheets and the Allow access button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n NOTE:<\/strong> Don\u2019t forget that if multiple users are working on Google Sheets, you will need to allow access in order for the IMPORTRANGE to function properly.<\/p>\n 10.<\/strong> Once you allow access to the other file, it should start loading. Depending on the amount of data you imported, it may take more than a few seconds.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/importrange-google-sheets-imported-range.webp” alt=”IMPORTRANGE in Google Sheets \u2014 imported scores in the Score 1 column of the Full Student List” title_text=”Imported scores in the Score 1 column of the Full Student List” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We would like to remind users that the IMPORTRANGE function does not import the data with formatting; it will only import the values.<\/p>\n [\/et_pb_text][et_pb_text module_id=”import” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n IMPORTRANGE can\u2019t import data from another sheet within the same spreadsheet.<\/b> This constraint can be frustrating, especially if you’re doing a lot of work within a single spreadsheet. Fortunately, there’s a few ways to overcome this limitation.<\/p>\n One of these alternatives is to use the FILTER function. The FILTER function enables you to extract specific data from a range based on specified criteria. This makes it a versatile tool for importing data from other sheets within the same spreadsheet.<\/p>\n Let\u2019s pretend the data we wanted to import in the example above was on the same spreadsheet.<\/p>\n We could transfer it to another sheet with this method. We would select the same range, then set the criteria for the filter function. This criteria would have to match all the cells, which could be achieved by bringing all cells that aren\u2019t empty.<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =FILTER(‘Sales 2020’!C2:C19, ‘Sales 2020’!C2:C19 <> “”)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This isn\u2019t really what the FILTER function is meant for, but it is effective. To learn more about this powerful tool check out\u00a0How to use the FILTER function in Google Sheets<\/a>.<\/p>\n To pull a single cell from another tab instead of a whole range, see how to reference another sheet in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”troubleshooting” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n While IMPORTRANGE is a powerful function, it frequently returns errors. These issues can range from permission problems to incorrect data ranges.<\/p>\n Some common errors include:<\/p>\nWhat is IMPORTRANGE in Google Sheets?<\/h2>\n
\n
How to use IMPORTRANGE in Google Sheets<\/h2>\n
Syntax of IMPORTRANGE<\/h3>\n
\n
1. Spreadsheet URL<\/h4>\n
\n
2. Range string<\/h4>\n
IMPORTRANGE example<\/h3>\n
How to use IMPORTRANGE step by step<\/h2>\n
How to import data from another sheet<\/h2>\n
Troubleshooting IMPORTRANGE errors<\/h2>\n
\n
![\"import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/1.1.png\")
[\/panel]\n\n\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/2.png\")
\n\n[\/panel]\n\n\n\n![\"import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/3.png\")
\n\n[\/panel]\n\n\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/4.png\")
\n\n[\/panel]\n\n\n\n