Imports a RSS or ATOM feed.
Sample Usage
IMPORTFEED("http://news.google.com/?output=atom")
IMPORTFEED(A2,B2,C2,D2)
Syntax
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.
- The value for
-
query
- [ OPTIONAL -"items"
by default ] - Specifies what data to fetch fromurl
.-
"feed"
returns a single row containing feed information including title, description, and url. -
"feed <type>"
returns a particular attribute of the feed, where<type>
istitle
,description
,author
, orurl
. -
"items"
returns a full table containing items from the feed. Ifnum_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>
istitle
,summary
(the item content, minus hyperlinks and images),url
(the URL of the individual item), orcreated
(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 return, starting from the most recent.- If
num_items
is not specified, all items currently published on the feed are returned.
- If
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 at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.