How to Retrieve Data from a Different Spreadsheet in Google Sheets (PC or Mac)

Today, Mytour will guide you on how to retrieve data from sheets within the same Google Sheets document as well as from other Google Sheets files. To import data from a different document, you will need the URL of the spreadsheet from which you want to pull the data.

Go to https://sheets.google.com on your web browser. If you're logged into your Google account, a list of your linked Google Sheets documents will appear.

• Log into your Google account if you're not already signed in.

Navigate to the spreadsheet where you want to import data. On the bottom tab, click on the sheet where you will input the data.

• If your spreadsheet doesn't have many sheets, click the ＋ icon at the bottom left of the page.

Select a cell. Click on the cell where you want to place the data. This cell will be highlighted.

Enter =Sheet1!A1 into the cell. Replace "Sheet1" with the name of the sheet and "A1" with the cell you wish to copy. The formula will include: an equals sign, the sheet name, an exclamation mark, and the cell you want to copy.

• If the sheet name contains spaces or special characters, enclose the name in single quotation marks. For example, if you want to copy cell A1 from a sheet named Budget Sheet $$$, the formula would be ='Budget Sheet $$$'!A1

Press ↵ Enter. The formula will execute, and the data from the specified sheet will appear in the selected cell.

Drag the mouse over the green handle to copy adjacent cells. To input multiple cells within the same spreadsheet, click and drag the mouse over the blue frame at the bottom-right corner of the highlighted cell, then pull it down or across to select a range and copy several cells.

Go to https://sheets.google.com on your web browser. If you're logged into your Google account, a list of Google Sheets documents linked to your account will appear.

• Log in to your Google account if you are not signed in automatically.

Open the Google Spreadsheet from which you want to retrieve data. Click on the spreadsheet document that you want to pull data from.

Right-click on the URL and select Copy. Once the spreadsheet document is open, right-click on the URL in the browser's address bar to highlight the full URL, then select Copy from the dropdown menu.

• If you are using a Mac with a trackpad or Magic Mouse, tap with two fingers, or hold down the Control key and click to simulate a right-click action.

Open the spreadsheet where you want to input the data. In a new tab or browser window, go to https://sheets.google.com, then click on the spreadsheet you want to work with.

Select a cell. Click on the cell where you want to input data. The cell will be highlighted to show it's selected.

Enter the following formula into the cell:
=IMPORTRANGE("spreadsheetURL", "Sheet1!A1:B14") Replace "spreadsheetURL" with the URL you copied earlier, and substitute "Sheet1!A1:B14" with the sheet name and cell range you want to import. The formula should be: equal sign, the function name IMPORTRANGE in uppercase, opening parentheses, double quotation marks, the spreadsheet URL, closing quotation marks, a comma, space, another set of quotation marks for the sheet name, a period for the sheet, the first cell in the range, a colon, the last cell in the range, closing quotation marks, and closing parentheses.

• To paste the URL, right-click and select Paste. Alternatively, press Ctrl+V on Windows or ⌘ Command+V on Mac.

Press ↵ Enter. The formula will execute, and data from the other spreadsheet will populate the selected cell.

Click on the Allow Access button in the pop-up window. You'll be prompted to grant permission to access the data from the other spreadsheet. Once you approve, the data will be imported into your spreadsheet.