I Love Egypt!

Thursday, October 3, 2019

How to Import Data from Another Google Sheet

Google Sheets Logo

Should you need to import data from another spreadsheet in Google Sheets, you can do it a couple of ways. Whether you want to pull the data from another sheet in the file or an entirely different spreadsheet, here’s how.

Import Data from Another Sheet

This first method requires you to have more than one sheet inside of a document. You can see whether your document has more than one sheet by looking at the bottom of the page. And to add another one, just hit the plus sign (+) to create a new one.

Multiple sheets inside of a document are located at the bottom of the page.

Fire up your browser, head to Google Sheets, and open up a spreadsheet. Click and highlight the cell where you want to import the data.

RELATED: The Beginner’s Guide to Google Sheets

Click an empty cell where you want the data to go.

Next, you need to type in a formula that references the cell from the other sheet. If your sheets are named, you will want to put its name in place of <SheetName> and the cell you want to reference after the exclamation mark. It should look something like this:

=<SheetName>!B7

Type = followed by the name of the sheet and the cell you want to import.

Read the remaining 18 paragraphs



from How-To Geek https://ift.tt/2Og0XoB
via IFTTT

No comments :

Post a Comment