IMPORTHTML for web tables in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import the first table from a webpage URL.

Google Sheets

=IMPORTHTML([1], "table", 1)

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

A"table"

B"https://example.com"

C1

D"list"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes

Using the wrong argument position for the URL

The first argument of IMPORTHTML is the URL as a text string. Here, you must put the webpage URL inside quotes.

2fill in blank

medium

Complete the formula to specify that you want to import a table from the webpage.

Google Sheets

=IMPORTHTML("https://example.com", [1], 1)

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

A"list"

B1

C"table"

D"html"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "list" instead of "table"

Not putting the argument in quotes

The second argument must be "table" to import tables. "list" is for lists, and other values are invalid here.

3fill in blank

hard

Fix the error in the formula to import the second table from a webpage.

Google Sheets

=IMPORTHTML("https://example.com", "table", [1])

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

A0

B"second"

C"2"

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 as the index (tables start at 1)

Putting the index in quotes

The third argument is the index of the table to import, starting at 1. To import the second table, use 2 without quotes.

4fill in blank

hard

Fill both blanks to import the first list from a webpage URL.

Google Sheets

=IMPORTHTML([1], [2], 1)

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

A"https://example.com"

B"table"

C"list"

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using "table" instead of "list" for the second argument

Not quoting the URL

The first blank is the URL in quotes. The second blank must be "list" to import lists instead of tables.

5fill in blank

hard

Fill all three blanks to import the third table from a webpage URL.

Google Sheets

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

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

A"https://example.com"

B"table"

C3

D"list"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "list" instead of "table"

Putting the index in quotes

Forgetting to quote the URL

Use the URL as the first argument, "table" as the second to specify tables, and 3 as the third to get the third table.