You can create your own feed reader to read the latest contents from your favourite blogs. With IMPORTFEED function in Google Sheets, you can easily achieve this. Then how to use IMPORTFEED function in Google Sheets? You need not to be a spreadsheet geek to do this. Even if you have limited Excel exposure, you can create your own feed reader in Google Sheets. Get a glimpse of the latest articles that your favourite bloggers publish that from within your spreadsheet.
Purpose of Google Sheets IMPORTFEED Formula
You can use Google Sheets IMPORTFEED formula to import RSS or ATOM feeds, that is in human readable format in a Google Doc Spreadsheet. You can have great control over such feeds using this function.
How to Use IMPORTFEED Function in Google Sheets
IMPORTFEED(url, [query], [headers], [num_items])
In earlier occasions, many times, when dealing with Google Sheets functions, I just skipped the syntax part without much detailing. Because, I was aware that the examples can convey the details. But this time, I think, I should first explain the syntax part, then move to examples. Then only you can learn how to use IMPORTFEED function in Google Sheets clearly. So here we begin.
For example, here for our blog, right click anywhere on the screen and click on “View Page Source”.
Alternatively you can apply keyboard shortcut Ctrl+U. Now search for the keyword “feed” to find the feed URL of our site. This URL you can use with Google Sheets IMPORTFEED function.
QUERY – In order to pull RSS feed data using the IMPORTFEED function, only the above URL is required. Query and other components in the functions are optional. But to have a better control of your imported feed, you should know what are the other components. The first one is QUERY. Remember. This has no relation with the Query function.
Here the Query specifies what data to fetch from the given RSS or ATOM feed URL. By default, the query is “items”. I will explain different IMPORTFEED function Queries in the below examples.
HEADERS – This is also optional. But useful to show the fetched data with proper column headings. It accepts Boolean TRUE or FALSE.
NUM_ITEMS: You can limit the IMPORTFEED function to return the number of contents. When you omit this, the function will fetch all the recently published contents.
Now time to learn how to use IMPORTFEED function in Google Sheets with variety of proper examples.
Google Sheets IMPORTFEED Function Examples
For the below example, I’m using my own blog feed URL. You can use any feed URL for your experiment purpose.
Use Importfeed function to fetch the item title of recent 2 posts.
Please note that you can replace the above cell reference in the formula as below. This is applicable to all below IMPORTFEED examples.
Use Importfeed function to fetch the item title of recent 2 posts with column headings.
Fetch Recent 2 Items with column headings.
This is similar to the above formula. But here just change the value in Cell B2 as “items” instead of “items title”. The result would be as below and this is the best feed reader settings in Google Sheets using IMPORTFEED function.
Recent 1 Item Summary with column headings.
As above you can use different sheet tabs on your Google Sheets to fetch different feed content. That’s all. Hope you could learn different formations of the function Importfeed in Google Sheets. Thanks for the stay. Enjoy!