Skip to content
Google Sheets

IMPORTFEED function in Google Sheets

Imports a RSS or ATOM feed.

=IMPORTFEED(url, [query], [headers], [num_items])

IMPORTFEED syntax and parameters

Four arguments, one required.

  • urlstringRequired

    The URL of the RSS or ATOM feed, including protocol (e.g. http://). The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

  • querystringOptional

    [ OPTIONAL - "items" by default ] - Specifies what data to fetch from url. "feed" returns a single row containing feed information including title, description, and url. "feed <type>" returns a particular attribute of the feed, where <type> is title, description, author, or url. "items" returns a full table containing items from the feed. If num_items is not specified, all items currently published on the feed are returned. "items <type>" returns a particular attribute of the requested item(s), where <type> is title, summary (the item content, minus hyperlinks and images), url (the URL of the individual item), or created (the post date associated with the item).

  • headersbooleanOptional

    [ OPTIONAL - FALSE by default ] - Whether to include column headers as an extra row on top of the returned value.

  • num_itemsnumberOptional

    [ OPTIONAL ] - For queries of items, the number of items to return, starting from the most recent. If num_items is not specified, all items currently published on the feed are returned.

IMPORTFEED examples

Formulas you'll actually reuse.

  1. The ten latest post titles from an RSS feed, with a header row:

    =IMPORTFEED("https://example.com/blog/feed", "items title", TRUE, 10)

  2. Full item rows — title, URL, date, summary — for the last five posts:

    =IMPORTFEED("https://example.com/blog/feed", "items", FALSE, 5)

IMPORTFEED in Excel

No direct equivalent — here's the way around.

Try IMPORTFEED in the playground

Edit the example — nothing to install.

Preloaded with the IMPORTFEED formula from Example 1 — change anything and watch it respond.

Loading the editor…

IMPORTFEED errors

What they mean — and the fixes.

  • #N/A

    The URL isn't a valid RSS or Atom feed — open it in a browser and check for XML.

Related functions

More ways Google Sheets gets this done.