IMPORTFEED for RSS in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import RSS feed from a URL.

Google Sheets

=IMPORTFEED([1])

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

AA1

Bhttps://example.com/feed

Cfeed_url

D"https://example.com/feed"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the URL in quotes

Using a cell reference without quotes when the cell is empty

The URL must be a text string inside quotes for IMPORTFEED to work correctly.

2fill in blank

medium

Complete the formula to import only the titles from the RSS feed.

Google Sheets

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

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

A"items title"

B"feed url"

C"items description"

D"items link"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "items description" instead of "items title"

Forgetting to put the query in quotes

To get only the titles from the RSS feed, use the query "items title".

3fill in blank

hard

Fix the error in the formula to import the latest 5 items from the RSS feed.

Google Sheets

=IMPORTFEED("https://example.com/feed", "items title", [1])

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

A"5"

B5

CTRUE

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the number 5 inside quotes

Using TRUE or FALSE instead of a number

The third argument is the number of items to import and must be a number, not a text string.

4fill in blank

hard

Fill both blanks to import the RSS feed URL and get the item links.

Google Sheets

=IMPORTFEED([1], [2])

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

A"https://news.example.com/rss"

B"items title"

C"items link"

D"feed description"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "items title" instead of "items link" for links

Not quoting the URL

The first blank is the RSS feed URL in quotes, the second blank is the query to get item links.

5fill in blank

hard

Fill all three blanks to import the RSS feed URL, get item descriptions, and limit to 3 items.

Google Sheets

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

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

A"https://blog.example.com/feed"

B"items description"

C3

D"items title"

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number as text ("3") instead of number 3

Mixing up "items title" and "items description"

The first blank is the feed URL, second is to get descriptions, third is the number 3 to limit items.