#New tab for google sheet update#
![new tab for google sheet new tab for google sheet](https://cdn.extendoffice.com/images/stories/doc-excel/google-sheet/share-one-sheet/doc-google-sheet-share-one-sheet-1.png)
As a result, this argument takes this form: Sheet1!A1:A12
![new tab for google sheet new tab for google sheet](https://i.ytimg.com/vi/hmz23MYyBdM/maxresdefault.jpg)
Keep in mind that a spreadsheet might have many tabs, each being its own sheet. Specifically, when you enter the range in the IMPORTRANGE function, you need to clarify which sheet the cells are located in. The range_string also has its own quirks. Range_string: This is the specific cells in the original spreadsheet you want to import and sync with the new spreadsheet. You actually have an option here: You can use the entire URL, or just what's known as the spreadsheet key. Spreadsheet_url: This is just the URL or web address of the spreadsheet you want to import data from. Here is what the function looks like: =IMPORTRANGE(, )Īs you can see, the IMPORTRANGE function is broken into two separate parts. While the IMPORTRANGE function can look long and unwieldy, that's only because it includes a URL in it, which can make even the simplest function look confusing. What to know about IMPORTRANGE in Google Sheets Instead, you can use the IMPORTRANGE function, which quickly and easily helps you import data from one spreadsheet into another and keeps the two spreadsheets in sync at all times. You could always simply copy and paste the cells in question, but if you do that, there's no live connection between the two sheets - if the original data changes, your second spreadsheet will become outdated. If you work with Google Sheets often enough, you'll inevitably need to get data from one spreadsheet into another.