FSA Tip #39 Connect Two Google Sheets With Importrange

Sometimes you’ve got a couple Google Sheets that you would like to have speak to each other. 

In my Farm Spreadsheets I use a master crop list with all the growing info for that crop – DTM, yield, spacing, and so forth. I then refer to that crop list from a bunch of other spreadsheets – especially my crop plan spreadsheets.

Different spreadsheet systems have different ways to connect those sheets.

In Google Sheets, you’ve got the IMPORTRANGE formula.

You enter that formula in the one cell, and then the formula imports all the data from the other sheet.

It’s important to realise that you cannot modify this imported data – it can only be modified in the original sheet. But if you modify the original data, it will also update the imported data.

That being said, you can reference that imported data with your whole arsenal of spreadsheet formulas – SUMIF, INDEX MATCH, FILTER, and more!

Go and get connected!

In this tip, we’ll see how to …

  • Link two Google sheets with IMPORTRANGE
  • Modify the data in original sheet and not the imported data
  • Use formulas to reference the imported data

You can get the spreadsheet fro this tip to follow along at home.

Go and get Connected!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s