IMPORTFEED

Imports a RSS or ATOM feed. Learn more

Video field
Web

In Google Sheets, the IMPORTFEED function is used to import and display data from an RSS or Atom feed into a spreadsheet.

Here is the syntax of the IMPORTFEED function:

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

Let's go through each parameter:

url: This is the required parameter that specifies the URL of the RSS or Atom feed you want to import. It can be a direct URL or a cell reference containing the URL.

query (optional): This parameter is used to filter the imported feed items based on specific criteria. It allows you to specify a keyword or phrase that the feed items should contain.

If you don't want to use a query, you can leave this parameter blank.

headers (optional): This parameter determines whether or not to include column headers in the imported data. By default, headers are included. You can set this parameter to false if you don't want to include headers.

num_items (optional): This parameter specifies the maximum number of feed items to import. If you omit this parameter, IMPORTFEED will import all available items from the feed.

The IMPORTFEED function will return the imported feed data as a table in your Google Sheets document, with each feed item occupying a row.

The table will include columns such as "Title," "Summary," "Publish Date," and "URL," depending on the structure of the feed.

Note that the IMPORTFEED function may require you to enable the "Google Sheets" service in your Google Cloud Platform project and have the necessary permissions to access the feed.

Also, keep in mind that the function's behavior may be subject to changes or limitations imposed by Google.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!