[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Are you working from multiple sets of spreadsheets? Sometimes you\u2019ll want to reference data from one sheet into another or even merge your spreadsheets together for a master view of your data. In this guide, we offer multiple methods to effectively reference data from another Google Sheet, including the IMPORTRANGE formula (explained in more detail in how to use IMPORTRANGE in Google Sheets<\/a>), and how to link your Google Sheets using Sheetgo<\/a>. If you are working with Excel rather than Google Sheets, see our guide to linking and referencing multiple sheets in Excel in how to reference another sheet in Excel<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”why-reference-another-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are many reasons why you may want to reference data from another Google Sheet. It\u2019s a simple way to easily compare data from different sources, without having to manually copy and paste between multiple sheets. An example of this is referencing other Google Sheets to illustrate year-on-year changes. Let’s say you want to import last year’s sales data into a new sheet containing this year’s sales, in order to compare the two and analyze the results.<\/p>\n You can reference a single cell from another Google Sheet, or multiple cells, and pull data from another sheet into your current sheet according to your requirements. Here we\u2019ll detail four methods for referencing data from other Google Sheets. The first will show how to easily import data from other sources into your Google Sheets workbook. The second will show how to import a range of data using the IMPORTRANGE formula. The third will explain how to use hyperlinks to have easy access to another data source where the data does not need to be present within the current workbook. Finally, we will show you how you can link Google Sheets using Sheetgo<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-reference-another-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This first method uses a cell-by-cell reference to identify the source of your data and import it into your Google Sheet.<\/p>\n 1.<\/strong> Open the Google Sheet where you wish to import data.<\/p>\n 2.<\/strong> Click on the cell where you want your data to appear.<\/p>\n 3.<\/strong> Type in the sheet name and cell of the data you wish to import, substituting it into the following format =’sheet_name’!cell. For example, =Sheet1!A1 or =’Sheet number two’!B4.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-link-to-another-sheet-cell-reference.webp” alt=”Google Sheets link to another sheet \u2014 formula referencing cell C2 on the Sales 2020 tab, returning 20402″ title_text=”Formula referencing cell C2 on the Sales 2020 tab, returning 20402″ 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 Please note: When a sheet includes spaces or other non-alphanumeric characters, you should include single quotes around the sheet name, as shown above.<\/p>\n 4.<\/strong> This will copy the data from the cell into the original cell you selected.<\/p>\n 5.<\/strong> Google Sheets may suggest Autofill to import the rest of the data from that column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-link-to-another-sheet-fill-down.webp” alt=”Google Sheets link to another sheet \u2014 cell reference filled down column D with the 2020 sales totals” title_text=”Cell reference filled down column D with the 2020 sales totals” 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 This example would copy the data from C2 ($20,402) from one sheet, into the selected cell in the other sheet. It\u2019s important to note that with this method, your data won\u2019t be formatted in the same way it is in its original source. IMPORTRANGE doesn’t bring the formatting across either, so if you need it, see how to transfer data and formats between Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-pull-data-from-another-google-she” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to reference a range of cells in another Google workbook, you should use the IMPORTRANGE function. For more detailed information on how to use this function, check out our post on how to use IMPORTRANGE in Google Sheets<\/a>.<\/p>\n 1.<\/strong> Open your two Google Sheet files; the one where you want to import the data, and the one which contains the data you wish to import.<\/p>\n 2.<\/strong> Select the cell where you want to import your data to.<\/p>\n 3.<\/strong> Use the formula =IMPORTRANGE("sheet URL or key", "sheet name! cell range") to select the cells you wish to link to. In this example, the URL would be followed by \u201cSales 2020!C2:C19\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-link-to-another-sheet-importrange.webp” alt=”Google Sheets link to another sheet with IMPORTRANGE \u2014 formula with the spreadsheet URL and Sales 2020!C2:C19″ title_text=”Formula with the spreadsheet URL and Sales 2020!C2:C19″ 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 Please note:<\/strong><\/p>\n 4.<\/strong> Ensure that IMPORTRANGE is not within another formula.<\/p>\n 5.<\/strong> Ensure that IMPORTRANGE has any necessary permissions to work with both sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-link-to-another-sheet-importrange-result.webp” alt=”Google Sheets link to another sheet with IMPORTRANGE \u2014 imported sales values filling column D” title_text=”Imported sales values filling column D” 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 Google Sheets will ask for your permission to connect the sheets before linking the data. Simply click the button to allow access and the process will complete automatically.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-link-data-between-multiple-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sometimes you\u2019ll want to have easy access to other Google Sheets data sources, but won\u2019t want to have that data present in your current workbook. In this instance, it makes sense to use a hyperlink, so the other data source (or sources) are a click away, without taking up space in your current google sheet. Creating a hyperlinked cell in Google Sheets is simple. Follow the steps below to create a link to another data source.<\/p>\n 1.<\/strong> Select the cell in which you want to insert the hyperlink.<\/p>\n 2.<\/strong> Open the \u201cInsert\u201d menu and click \u201cLink\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-hyperlink-to-another-sheet-insert-link.webp” alt=”Google Sheets hyperlink to another sheet \u2014 right-click menu with the Insert link option” title_text=”Right-click menu with the Insert link option” 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> A dialog box will open; paste the URL of the link you wish to insert.<\/p>\n To link to another tab in the same file, click “Sheets and named ranges” at the bottom of the dialog box and pick the sheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-hyperlink-to-another-sheet-link-dialog.webp” alt=”Google Sheets hyperlink to another sheet \u2014 link dialog with the search or paste a link field” title_text=”Link dialog with the search or paste a link field” 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> Click \u201cApply\u201d.<\/p>\n 5.<\/strong> Alternatively, select the cell in which you want to insert the hyperlink and press Ctrl and K together. This will bring up the dialog box and you can paste your URL from there.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-hyperlink-to-another-sheet-paste-url.webp” alt=”Google Sheets hyperlink to another sheet \u2014 Sales 2020 text with a pasted spreadsheet URL and Apply button” title_text=”Sales 2020 text with a pasted spreadsheet URL and Apply 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 Hyperlinks are not limited to other Google Sheets either. You can create a hyperlink to any URL on the web<\/a>, allowing you to add quick access to videos, articles, reports, or images, or even advanced data created in external programs such as IBM SPSS.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-link-google-sheets-with-sheetgo” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, there are different methods available to link your Google Sheets data. However, they tend to involve the use of complex formulas and references, which have a tendency to break and result in errors. Fortunately, you can quickly and easily link your files without having to write any formulas or reference any ranges. Using Sheetgo<\/a>, an AI-powered data automation platform, you can link your Google Sheets in three simple steps.<\/p>\n 1.<\/strong> Choose the file with the source data.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/link-google-sheets-sheetgo-source-file.webp” alt=”Link Google Sheets with Sheetgo \u2014 New connection screen with the CUSTOMERS file and Sheet1 tab as the source” title_text=”New connection screen with the CUSTOMERS file and Sheet1 tab as the source” 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> Select whether you would like to process the selected data by splitting or filtering.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/link-google-sheets-sheetgo-data-processor.webp” alt=”Link Google Sheets with Sheetgo \u2014 Select a data processor screen with Filter and Split options” title_text=”Select a data processor screen with Filter and Split options” 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> Choose exactly where you want to send the data and click to save.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/link-google-sheets-sheetgo-destination.webp” alt=”Link Google Sheets with Sheetgo \u2014 destination set to the existing TRANSACTIONS file and Sheetgo_Sheet1 tab” title_text=”Destination set to the existing TRANSACTIONS file and Sheetgo_Sheet1 tab” 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 To learn more about this, read our blog post on how to link Google Sheets data automatically<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Many people who work with spreadsheet data need to link and reference several Google Sheets files. Where data needs to be accessible but not present within the current file, or you want to reference data that is incompatible with Google Sheets (e.g., video), using a hyperlink is an easy and effective option.<\/p>\n You also know different methods you can use to link your Google Sheets when you do need to have the data present in the current file, by using formulas like IMPORTRANGE to import the data directly. However, if you regularly need to link multiple files, writing and maintaining these formulas can be time-consuming and result in errors. Fortunately, you can use Sheetgo to link these files in a few clicks, and its AI Processor<\/a> can clean and standardize the data on the way.<\/p>\n Did we help you find what you were looking for? Here are some other articles you may find useful:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Precisa vincular o Google Sheets a outra planilha? Veja como fazer refer\u00eancia a uma c\u00e9lula, importar um intervalo com IMPORTRANGE ou adicionar um hiperlink para outro arquivo ou aba.<\/p>","protected":false},"author":2,"featured_media":262648,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-262637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262637"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262648"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Why reference another Google Sheet?<\/h2>\n
How to reference another Google Sheet?<\/h2>\n
How to pull data from another Google Sheet using IMPORTRANGE?<\/h2>\n
\n
How to link data between multiple Google Sheets with hyperlinks?<\/h2>\n
How to link Google Sheets with Sheetgo<\/h2>\n
Conclusion<\/h2>\n
\n