Google Sheets Tips

IMPORTFEED function in Google Sheets: import an RSS or Atom feed

IMPORTFEED imports an RSS or Atom feed into Google Sheets: the titles, links, dates and summaries of the latest posts of a blog or news site. This guide covers the syntax, every value of the query argument, headers and item limits, how to combine several feeds and filter them, how often the data refreshes, and the errors the function returns.

Google Sheets TipsVadym Kramarenko8 min read

IMPORTFEED function in Google Sheets: import an RSS or Atom feed

IMPORTFEED imports the items of an RSS or Atom feed into the sheet:

=IMPORTFEED("http://news.google.com/?output=atom", "items", TRUE, 10)

The formula returns the ten latest items of the feed with a header row: the title, the author, the link and the summary of each.

Google Sheets with the formula =IMPORTFEED(“http://news.google.com/?output=atom”, “items”, TRUE, 10) returning a table with the columns Title, Author, URL and Summary and one news item per row

Reading to get this done?

IMPORTFEED syntax

IMPORTFEED syntax

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

  • url: the address of the feed, with its protocol (http:// or https://). In quotation marks, or a reference to a cell that holds it.
  • query: optional, “items” by default. What to return; see the table below.
  • headers: optional, FALSE by default. TRUE adds a header row on top of the result.
  • num_items: optional. How many items to return, starting from the most recent. Without it, all items currently in the feed are returned.

Google Sheets with =IMPORTFEED( typed in a cell and the function hint describing the url, query, headers and num_items arguments

The only required argument is the address: =IMPORTFEED("http://news.google.com/?output=atom") returns every item of the feed without headers.

The query argument

According to Google’s help, the query takes these values:

Query Returns
"items" A table of the items: one row per post
"items title" Only the titles
"items summary" Only the summaries: the content without links and images
"items url" Only the links
"items created" Only the dates of the posts
"feed" One row about the feed itself; in our test four values: title, author, description and URL
"feed title", "feed description", "feed author", "feed url" One attribute of the feed

The first time: allow access

The first time IMPORTXML, IMPORTHTML, IMPORTDATA or IMPORTFEED is used in a file, Sheets shows a warning bar above the grid, “Some formulas are trying to send and receive data from external parties”, and the formula shows #REF! until Allow access is clicked in that bar. We saw exactly this in our test file.

Google Sheets with the yellow warning bar Some formulas are trying to send and receive data from external parties above the grid and #REF! in the cell that holds the import formula

According to Google’s help, the bar appears once per spreadsheet, only an editor of the file can click it, and on a phone it has to be done in a desktop browser.

Examples

Examples

Titles only

=IMPORTFEED("http://news.google.com/?output=atom", "items title", TRUE, 5)

Google Sheets with the formula =IMPORTFEED(“http://news.google.com/?output=atom”, “items title”, TRUE, 5) returning a Title header and five headlines

Two formulas side by side build a compact reading list:

=IMPORTFEED(A2, "items title", FALSE, 10)

=IMPORTFEED(A2, "items url", FALSE, 10)

With the feed address in A2, replacing it switches the whole list to another site.

The name of the feed

=IMPORTFEED(A2, "feed title")

Useful as a label above the list when a sheet follows several feeds.

Several feeds in one list

Curly braces stack the results of several formulas. Ask each feed for the same query so that the columns match:

={IMPORTFEED(A2, "items title", FALSE, 5); IMPORTFEED(A3, "items title", FALSE, 5)}

Only the items that mention a keyword

Wrap the result in FILTER with REGEXMATCH. The (?i) at the start makes the search ignore case:

=FILTER(IMPORTFEED(A2, "items title"), REGEXMATCH(IMPORTFEED(A2, "items title"), "(?i)analytics"))

QUERY works on the full table too, with the columns called Col1, Col2 and so on: =QUERY(IMPORTFEED(A2, "items", FALSE), "select Col1, Col3 where lower(Col1) contains 'sheets'", 0). The 0 tells QUERY there is no header row, and lower makes the match ignore case.

Hand this to your AI

You check competitor blogs and industry news by opening each site, and IMPORTFEED keeps returning errors.

Paste this into your AI assistant. It finds the feed addresses of the sites you follow and writes IMPORTFEED formulas that list their posts in one sheet, filtered by your keywords.

The prompt

write me IMPORTFEED formulas that combine the feeds of the blogs I follow into one list in my sheet, newest first, showing only posts that mention my keywords

Find the feed address

Find the feed address

IMPORTFEED needs the address of the feed, not of the site. Ways to find it:

  • Look for an RSS link or icon on the blog, often in the footer.
  • Try the usual addresses: /feed, /rss, /rss.xml, /atom.xml after the address of the blog.
  • Open the page source (View page source) and search for application/rss+xml or application/atom+xml; the link next to it is the feed.

A feed opened in the browser looks like XML, with <rss> or <feed> at the top. If the address shows an ordinary web page, it is not the feed.

How often the data refreshes

How often the data refreshes

IMPORTFEED re-reads the feed by itself. Google’s calculation settings page lists one hour for IMPORTFEED, together with IMPORTHTML, IMPORTDATA and IMPORTXML. For those three, Google adds that the check runs only while the spreadsheet is open and that reloading the page does not trigger it; deleting the formula and entering it again does. Expect the same of IMPORTFEED.

Two consequences:

  • The list moves. New posts push old ones out; a feed holds only its latest items, often ten to a few dozen. The sheet is a window on the feed, not an archive. To keep a post, copy the row and paste it as values elsewhere.
  • The default is not the whole feed. In our test the Google News feed returned 20 items without num_items and 100 with num_items set to 100; a num_items of 500 returned #VALUE!. Set the number you need.

What IMPORTFEED cannot do

What IMPORTFEED cannot do

  • Sites without a feed. For pages that have none, IMPORTXML can read headings and links from the HTML.
  • Feeds behind a login. The request comes from Google’s servers, so only public feeds can be read.
  • Full articles. The summary is what the publisher puts in the feed, usually a teaser.

The import functions compared

The import functions compared

Function Imports
IMPORTFEED An RSS or Atom feed
IMPORTXML Any elements of a page or XML file, chosen by XPath
IMPORTHTML A table or a list from a web page
IMPORTDATA A CSV or TSV file from a URL
IMPORTRANGE A range from another Google spreadsheet

Errors in IMPORTFEED

Errors in IMPORTFEED

⚠️ Error: An error right after entering the formula, with a warning bar above the sheet.

✅ Solution: The file has not been allowed to fetch external data yet. Allow access in the warning bar.

⚠️ Error: #N/A.

✅ Solution: The address is not a feed (in our test, the address of a home page returned #N/A), or the feed has no such field: “items created” returned #N/A with “Imported content is empty” on a feed without that field. Open the address in the browser: a feed shows XML.

⚠️ Error: #REF! with “Array result was not expanded”.

✅ Solution: The cells the result needs are not empty. Clear the area below and to the right of the formula, or limit the result with num_items.

⚠️ Error: #VALUE! after changing the query.

✅ Solution: The query is not one of the values in the table above: “items nothing” returned #VALUE! in our test. Capitals do not matter, “Items Title” worked like “items title”; the words and the space between them do.

⚠️ Error: Columns are missing or empty.

✅ Solution: The feed does not provide them. Not every feed has an author or a date for each item.

⚠️ Error: “Loading…” with the note “Loading data may take a while because of the large number of requests”.

✅ Solution: Too many import requests. Google counts them per creator of the file, across all the files that person has open, so the fix is fewer import formulas, not a faster connection. Replace finished results with values.

⚠️ Error: #ERROR! with “This function is not allowed to reference a cell with NOW(), RAND(), RANDARRAY(), or RANDBETWEEN()”.

✅ Solution: An import function cannot depend on a volatile function, directly or through another cell, which rules out the trick of adding NOW() to the address to force a refresh. TODAY is the one exception.

Related guides

A feed tells you what was published, not how it performed

A feed tells you what was published, not how it performed

IMPORTFEED shows what a site publishes. What the feed does not carry is everything a content report is for: sessions, signups and revenue per article. Those numbers sit in analytics and in the warehouse, and they do not come through an RSS feed.

The OWOX Data Marts extension for Google Sheets covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export

What changes for the person who maintains the sheet:

  • Refresh replaces re-export. Refresh current report in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
  • The source is written on the sheet. The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
  • No SQL and no warehouse access needed. The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. The list of posts from IMPORTFEED can sit next to it, as the public half of a content report. The extension comes with the OWOX Cloud plans of OWOX Data Marts; spreadsheet reporting describes both ways data reaches a sheet.

Hand this to your AI

You check competitor blogs and industry news by opening each site, and IMPORTFEED keeps returning errors.

Paste this into your AI assistant. It finds the feed addresses of the sites you follow and writes IMPORTFEED formulas that list their posts in one sheet, filtered by your keywords.

The prompt

write me IMPORTFEED formulas that combine the feeds of the blogs I follow into one list in my sheet, newest first, showing only posts that mention my keywords

FAQ

Frequently Asked Questions

Why is my ImportFEED formula returning an error in Google Sheets?

The usual causes: the address is a web page and not the feed itself, the protocol (https://) is missing, the query is not one of the accepted values such as "items" or "items title", the cells below the formula are not empty, or the file has not yet been allowed to fetch external data. Open the address in a browser: a feed shows XML.

What types of data can ImportFEED extract?

With the query "items" it returns a table of the feed's posts; "items title", "items summary", "items url" and "items created" return one attribute of each post. "feed" returns the title, description and URL of the feed itself. What is filled in depends on what the publisher puts into the feed.

How do I find the feed URL for ImportFEED in Google Sheets?

Most websites with blogs or news sections have RSS or Atom feeds. Look for the RSS icon or search for “[site name] RSS feed” to get the correct URL to use in ImportFEED.

What is ImportFEED?

ImportFEED is a Google Sheets function designed for importing data from RSS and ATOM feeds. It's useful for tracking updates from blogs, news sites, and other online publications directly into your spreadsheet.

Who wrote this

Vadym Kramarenko

Vadym Kramarenko Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.