Imports an RSS or Atom feed.

Sample usage




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

  • url – 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.
  • query[ 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).

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

  • num_items[ OPTIONAL ] – For queries of items, the number of items to be returned, starting from the most recent.

    • If num_items is not specified, all items currently published on the feed are returned.

Related articles

  • IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV and RSS and Atom XML feeds.
  • IMPORTRANGE: Imports a range of cells from a specified spreadsheet.
  • IMPORTHTML: Imports data from a table or list within an HTML page.
  • IMPORTDATA: Imports data from a given URL in .csv (comma-separated value) or .tsv (tab-separated value) format.


Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu