You are viewing the article How to Get Data from Another Sheet on Google Sheets (PC or Mac) at Lassho.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 66,844 times.
This wikiHow teaches you how to get data from sheets on the same Google Sheets document as other Google spreadsheets. To import data from another document, you need the URL of the sheet from which you want to get the data.
Steps
Get data from sheets in the same workbook
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 1.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/a/ac/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Go to https://sheets.google.com on a web browser. If you’re signed in to your Google account, a list of Google Sheets documents associated with your account will appear.
- Sign in to your Google account if you haven’t signed in automatically.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8a/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 2.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/8/8a/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Click on a certain Google Sheet document. The spreadsheet you want to use will appear.
- You can also create a new spreadsheet by clicking the . sign
{“smallUrl”:”https://www.wikihow.com/images_en/0/0a/Android_Google_New.png”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0a/ Android_Google_New.png/30px-Android_Google_New.png”,”smallWidth”:460,”smallHeight”:460,”bigWidth”:30,”bigHeight”:30,”licensing”:”<div class=”mw-parser-output “></div>”}.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8b/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 3.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/8/8b/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Go to the sheet that you want to import data into. On the sheet tab at the bottom, click the sheet that you’ll import the data into.
- If your worksheet doesn’t have multiple worksheets, click the ＋ sign at the bottom left of the page.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/08/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 4.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/0/08/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Select a cell. Click the cell where you want to put the data. This box will be highlighted.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1c/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 5.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/1/1c/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:552 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Type =Sheet1!A1 in the cell. In the “Sheet1” location, enter the sheet name, then replace “A1” with the cell to be copied. The formula will include: an equals sign, the sheet name, an exclamation point, and the cell you want to copy.
- If the sheet name contains spaces or special characters, you need to enclose it in single quotes. For example, if you wanted to copy cell A1 from a worksheet named Budget Sheet $$$, the formula would become =’Budget Sheet $$$’!A1
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8d/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 6.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/8/8d/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Press ↵ Enter . The formula will work, the data from the worksheet that you specify will be entered into the cell.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fb/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 7.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/f/fb/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg”,”smallWidth”:460,”smallHeight”:351,”bigWidth”:728,”bigHeight”:556 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Drag the mouse on the blue handle to duplicate adjacent cells. If you want to enter multiple cells on the same worksheet, click and drag your mouse over the blue frame in the lower-right corner of the highlighted cell, then drag down or across to make a selection to duplicate multiple cells.
Get data from another spreadsheet
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 8.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/a/a4/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Go to https://sheets.google.com on a web browser. If you’re signed in to your Google account, a list of Google Sheets documents associated with your account will appear.
- Sign in to your Google account if you haven’t signed in automatically.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b5/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 9.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/b/b5/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the Google spreadsheet from which you want to get the data. Click the spreadsheet document for which you want to get the data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fa/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 10.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/f/fa/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Right click on the URL and select Copy . After opening the spreadsheet document, right-click the web address in your browser’s address bar to highlight the entire URL, then select Copy from the drop-down menu.
- Name a Mac with a trackpad or magic mouse, click with two fingers, or hold Contrp and click to simulate a right-click.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/98/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 11.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/9/98/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Open the spreadsheet that you want to import data into. On a new browser tab or window, go to https://sheets.google.com, then click the spreadsheet you want to import data into.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 12.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/9/9a/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Select a cell. Click the cell where you want to put the data. This box will be highlighted.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 13.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/3/3c/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:552 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the following formula in the cell:
=IMPORTRANGE("spreadsheetURL", "Sheet1!A1:B14") At the “spreadsheetURL” position, paste the previously copied URL, and replace “Sheet1!A1:B14” with the name of the cell and sheet that you have copied. you want to get the data. The formula will include: equals sign, uppercase IMPORTRANGE word, opening parenthesis, double quote, worksheet URL, double quotes, comma, space, double quotes, sheet name, exclamation point, first cell in range, colon, last cell in range, quotation mark and closing parenthesis.
=IMPORTRANGE("spreadsheetURL", "Sheet1!A1:B14") At the “spreadsheetURL” position, paste the previously copied URL, and replace “Sheet1!A1:B14” with the name of the cell and sheet that you have copied. you want to get the data. The formula will include: equals sign, uppercase IMPORTRANGE word, opening parenthesis, double quote, worksheet URL, double quotes, comma, space, double quotes, sheet name, exclamation point, first cell in range, colon, last cell in range, quotation mark and closing parenthesis.
- To paste the URL, you right-click and select Paste . You can also press Ctrl + V on Windows or ⌘ Command + V on Mac.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3b/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 14.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/3/3b/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Press ↵ Enter . The formula will work, the data from the other sheet will be entered into the cell.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/73/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step- 15.jpg/v4-460px-Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg”,”bigUrl”:”https://www. wikihow.com/images/thumb/7/73/Pull-Data-from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg/v4-728px-Pull-Data- from-Another-Sheet-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:550 ,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Allow Access in the box that pops up. You will be prompted for permission to get data the first time you pull data from another spreadsheet. So your data will be imported into the spreadsheet.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 66,844 times.
This wikiHow teaches you how to get data from sheets on the same Google Sheets document as other Google spreadsheets. To import data from another document, you need the URL of the sheet from which you want to get the data.
Thank you for reading this post How to Get Data from Another Sheet on Google Sheets (PC or Mac) at Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: