How to Use IMPORTFEED Function in Google Sheets

0
70
How to Use IMPORTFEED Function in Google Sheets

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

Syntax:

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.

URL – URL is the RSS or ATOM feed URL of your favourite blogs on the web. If you ask me how to find a blog or webpages RSS or ATOM feed URL, my answer is to look on the page source. How?

For example, here for our blog, right click anywhere on the screen and click on “View Page Source”.

find feed url for importfeed function in google sheets

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.

feed url of infoinspired for 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.

Example 1:

Use Importfeed function to fetch the item title of recent 2 posts.

Importfeed function to fetch the item title

Please note that you can replace the above cell reference in the formula as below. This is applicable to all below IMPORTFEED examples.

=IMPORTFEED(“http://infoinspired.com/feed/”,”itemS title”,FALSE,2)

Example 2:

Use Importfeed function to fetch the item title of recent 2 posts with column headings.

Importfeed function to fetch the item title with column headings

Example 3:

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.

Importfeed function to fetch recent two items

Example 4:

Recent 1 Item Summary with column headings.

import feed example 4

Conclusion

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!

LEAVE A REPLY

Please enter your comment!
Please enter your name here