{"id":6045,"date":"2017-11-01T17:46:58","date_gmt":"2017-11-01T16:46:58","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=6045"},"modified":"2017-11-01T17:46:58","modified_gmt":"2017-11-01T16:46:58","slug":"importar-feed-rss-para-o-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/import-rss-feed-to-google-sheets\/","title":{"rendered":"Importar feed RSS para o Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; custom_margin=&#8221;||-2px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Google Sheets is an advanced spreadsheets application that has made our lives easier because it is ubiquitously accessible. Not only that, it lets us import information from the Internet with functions built right into the application. In this article, we explain how to import RSS Feed to Google Sheets. We do so with the help of the\u00a0<a href=\"https:\/\/support.google.com\/docs\/answer\/3093337?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">IMPORTFEED<\/a>\u00a0formula, which supports both RSS and Atom feed.<\/p>\n<h4>Syntax<\/h4>\n<p><strong>IMPORTFEED(url, [query], [headers], [num_items])<\/strong><\/p>\n<ul>\n<li><strong>url<\/strong>\u00a0\u2013 this is the address (uniform resource locator) to the HTML page on the web, where the table or list that we are looking to import are located.\u00a0This can take two forms.\n<ul>\n<li>A valid and fully qualified location in the form of text in double quotes (e.g.\u00a0<strong>\u201chttp:\/\/news.google.com\/?output=atom\u201d<\/strong>).<\/li>\n<li>Or it can be a reference to a cell (like\u00a0<strong>B1<\/strong>) within Google Sheets, where we stored the\u00a0<strong>url<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<li><strong>query<\/strong>\u00a0\u2013 this (optional) parameter specifies what information to fetch from the\u00a0<strong>url<\/strong>. For the list of available query options, check out this\u00a0<a href=\"https:\/\/support.google.com\/docs\/answer\/3093337?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">link<\/a>.<\/li>\n<li><strong>headers<\/strong>\u00a0\u2013 (optional) specifies whether the column headers should be included in the data import or not. It is\u00a0<strong>FALSE<\/strong>\u00a0by default.<\/li>\n<li><strong>num_items<\/strong>\u00a0\u2013 (optional) specifies the number of items to fetch, starting from the most recent. If we don\u2019t specify this parameter, Google Sheets returns all the items published on the channel feed.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h4>Examples: Import RSS Feed to Google Sheets<\/h4>\n<p>1: IMPORTFEED(url)<\/p>\n<p>Please consider the image below. B3 is the cell where we are entering the<span>\u00a0<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3093337\" target=\"_blank\" rel=\"noopener noreferrer\">IMPORTFEED<\/a><span>\u00a0<\/span>formula.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/rss-to-google-sheets-1.png&#8221; alt=&#8221;rss to google sheets 1&#8243; title_text=&#8221;rss to google sheets 1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span>We make sure that the\u00a0<\/span><strong>url<\/strong><span>\u00a0is within double quotes and\u00a0hit the Enter key. As soon as we do that, Google Sheets tries to fetch the data. Larger the feed, the longer it might take to finish the data import.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-2.10.png&#8221; alt=&#8221;RSS to Google Sheets: Data Loading&#8221; title_text=&#8221;data-loading&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span>While the data import is in progress, the cell B3 looks like it\u00a0is holding an error value. Please note a little red triangle on the top right corner of the cell. But, it is not an actual error, but a transient state. To confirm, we can hover the mouse on the cell B3, to see the description as shown below.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-2.png&#8221; alt=&#8221;RSS to Google Sheets: Data Loading 2&#8243; title_text=&#8221;data-laoding-in-google-sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span>Once Google Sheets loads the data, the red triangle on the cell B3 disappears. We\u2019ll notice the data extends from the cell B3 to right and also further down.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/rss-to-google-sheets-4-1.png&#8221; alt=&#8221;rss to google sheets 4&#8243; title_text=&#8221;rss to google sheets 4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span>We may not know how far the data is going to extend. So, it is very important that we keep the expected real estate of the result,\u00a0clear of any preoccupied values. Otherwise, the IMPORTFEED formula will return a #REF! error, as shown in the snapshot below. For the purposes of demonstration, we entered a dummy value in the cell C9.<\/span><\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/rss-to-google-sheets-5.png&#8221; alt=&#8221;rss to google sheets 5&#8243; title_text=&#8221;rss to google sheets 5&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h5>2: IMPORTFEED(url cell reference, items titles, include headers, fetch 20 items)<\/h5>\n<p>Please note that in the cell B1, we have the\u00a0<strong>url<\/strong>\u00a0to the RSS feed from which we need the data from. So, we\u2019ll use that cell reference in the IMPORTFEED function to import RSS feed to Google Sheets.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/rss-to-google-sheets-6.png&#8221; alt=&#8221;rss to google sheets 6&#8243; title_text=&#8221;rss to google sheets 6&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Congratulations! We just learned how to import RSS feed to Google Sheets using the native IMPORTFEED function.<\/p>\n<p>Read through the following blog post to learn how to<span>\u00a0<\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/import-html-table-to-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">import HTML tables into Google Sheets.<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets is an advanced spreadsheets application that has made our lives easier because it is ubiquitously accessible. Not only that, it lets us import information from the Internet with functions built right into the application. In this article, we explain how to import RSS Feed to Google Sheets. We do so with the help [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":6046,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Google Sheets is an advanced spreadsheets application that has made our lives easier because it is ubiquitously accessible. Not only that, it lets us import information from the Internet with functions built right into the application. In this article, we explain how to import RSS Feed to Google Sheets. We do so with the help of the&nbsp;<a href=\"https:\/\/support.google.com\/docs\/answer\/3093337?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">IMPORTFEED<\/a>&nbsp;formula, which supports both RSS and Atom feed.\n<h4>Syntax<\/h4>\n<strong>IMPORTFEED(url, [query], [headers], [num_items])<\/strong>\n<ul>\n \t<li><strong>url<\/strong>&nbsp;\u2013 this is the address (uniform resource locator) to the HTML page on the web, where the table or list that we are looking to import are located.&nbsp;This can take two forms.\n<ul>\n \t<li>A valid and fully qualified location in the form of text in double quotes (e.g.&nbsp;<strong>\u201chttp:\/\/news.google.com\/?output=atom\u201d<\/strong>).<\/li>\n \t<li>Or it can be a reference to a cell (like&nbsp;<strong>B1<\/strong>) within Google Sheets, where we stored the&nbsp;<strong>url<\/strong>.<\/li>\n<\/ul>\n<\/li>\n \t<li><strong>query<\/strong>&nbsp;\u2013 this (optional) parameter specifies what information to fetch from the&nbsp;<strong>url<\/strong>. For the list of available query options, check out this&nbsp;<a href=\"https:\/\/support.google.com\/docs\/answer\/3093337?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">link<\/a>.<\/li>\n \t<li><strong>headers<\/strong>&nbsp;\u2013 (optional) specifies whether the column headers should be included in the data import or not. It is&nbsp;<strong>FALSE<\/strong>&nbsp;by default.<\/li>\n \t<li><strong>num_items<\/strong>&nbsp;\u2013 (optional) specifies the number of items to fetch, starting from the most recent. If we don\u2019t specify this parameter, Google Sheets returns all the items published on the channel feed.<\/li>\n<\/ul>\n<h4>Examples: Import RSS Feed to Google Sheets<\/h4>\n1: IMPORTFEED(url)\n\nPlease consider the image below. B3 is the cell where we are entering the <a href=\"https:\/\/support.google.com\/docs\/answer\/3093337\" target=\"_blank\" rel=\"noopener noreferrer\">IMPORTFEED<\/a> formula.\n\n<img class=\"aligncenter size-full wp-image-10761\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-1.png\" alt=\"Import RSS feed to Google Sheets - Illustration 1\" width=\"869\" height=\"675\">\n\nWe make sure that the&nbsp;<strong>url<\/strong>&nbsp;is within double quotes and&nbsp;hit the Enter key. As soon as we do that, Google Sheets tries to fetch the data. Larger the feed, the longer it might take to finish the data import.\n\n<img class=\"aligncenter size-full wp-image-10764\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-2.10.png\" alt=\"Import RSS feed to Google Sheets - Illustration 2.10\" width=\"870\" height=\"676\">\n\nWhile the data import is in progress, the cell B3 looks like it&nbsp;is holding an error value. Please note a little red triangle on the top right corner of the cell. But, it is not an actual error, but a transient state. To confirm, we can hover the mouse on the cell B3, to see the description as shown below.\n\n<img class=\"aligncenter size-full wp-image-10762\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-2.png\" alt=\"Import RSS feed to Google Sheets - Illustration 2\" width=\"869\" height=\"675\">\n\nOnce Google Sheets loads the data, the red triangle on the cell B3 disappears. We\u2019ll notice the data extends from the cell B3 to right and also further down.\n\n<img class=\"aligncenter size-full wp-image-10765\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-4.png\" alt=\"Import RSS feed to Google Sheets - Illustration 4\" width=\"869\" height=\"675\">\n\nWe may not know how far the data is going to extend. So, it is very important that we keep the expected real estate of the result,&nbsp;clear of any preoccupied values. Otherwise, the IMPORTFEED formula will return a #REF! error, as shown in the snapshot below. For the purposes of demonstration, we entered a dummy value in the cell C9.\n\n<img class=\"aligncenter size-full wp-image-10766\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-5.png\" alt=\"Import RSS feed to Google Sheets - Illustration 5\" width=\"869\" height=\"675\">\n<h5>2: IMPORTFEED(url cell reference, items titles, include headers, fetch 20 items)<\/h5>\nPlease note that in the cell B1, we have the&nbsp;<strong>url<\/strong>&nbsp;to the RSS feed from which we need the data from. So, we\u2019ll use that cell reference in the IMPORTFEED function to import RSS feed to Google Sheets.\n\n<img class=\"aligncenter size-full wp-image-10767\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/Import-RSS-feed-to-Google-Sheets-Illustration-6.png\" alt=\"Import RSS feed to Google Sheets - Illustration 6\" width=\"869\" height=\"717\">\n\nCongratulations! We just learned how to import RSS feed to Google Sheets using the native IMPORTFEED function.\n\nFinally, should you have any questions please feel free to let us know in the comments section below.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-6045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/6045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=6045"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/6045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/6046"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=6045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=6045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=6045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}