IMPORTRANGE for other spreadsheets in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from another spreadsheet using IMPORTRANGE.

Google Sheets

=IMPORTRANGE([1], "Sheet1!A1:B10")

Drag options to blanks, or click blank then click option'

ASheet1!A1:B10

B"Sheet1!A1:B10"

CA1:B10

D"https://docs.google.com/spreadsheets/d/abc123xyz"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes.

Using the range without quotes as the first argument.

The first argument of IMPORTRANGE is the URL of the other spreadsheet as a text string.

2fill in blank

medium

Complete the formula to import range from a sheet named 'Data' in another spreadsheet.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz", [1])

Drag options to blanks, or click blank then click option'

A"Data!A1:C20"

BData!A1:C20

C"A1:C20"

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting the range in quotes.

Leaving out the sheet name before the exclamation mark.

The range argument must be a text string with the sheet name and cell range in quotes.

3fill in blank

hard

Fix the error in the IMPORTRANGE formula to correctly import cells A1 to A5 from 'Sheet2'.

Google Sheets

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz", [1])

Drag options to blanks, or click blank then click option'

A"Sheet2!A1:A5"

B"Sheet2!A1-A5"

CSheet2!A1:A5

DSheet2!A1-A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash '-' instead of a colon ':' in the range.

Not putting the range in quotes.

The range must be a string with the sheet name and range separated by an exclamation mark, inside quotes.

4fill in blank

hard

Fill both blanks to import data from 'Sheet3' range B2:D10 in another spreadsheet.

Google Sheets

=IMPORTRANGE([1], [2])

Drag options to blanks, or click blank then click option'

A"https://docs.google.com/spreadsheets/d/xyz789abc"

BSheet3!B2:D10

C"Sheet3!B2:D10"

D"B2:D10"

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the URL or the range.

Leaving out the sheet name in the range.

The first blank is the spreadsheet URL in quotes. The second blank is the sheet name and range in quotes.

5fill in blank

hard

Fill all three blanks to import range A1:C5 from 'Sales' sheet in another spreadsheet and assign it to cell A1.

Google Sheets

A1 = [1]([2], [3])

Drag options to blanks, or click blank then click option'

AIMPORTRANGE

B"https://docs.google.com/spreadsheets/d/sales123doc"

C"Sales!A1:C5"

DIMPORTDATA

Attempts:

3 left

💡 Hint

Common Mistakes

Using IMPORTDATA instead of IMPORTRANGE.

Not quoting the URL or range.

Leaving out the sheet name in the range.

Use IMPORTRANGE function with the spreadsheet URL and the sheet name with range as strings.