Syntax<\/h3>\n
IMPORTFEED(url, [query], [headers], [num_items])<\/strong><\/span><\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the\u00a0snapshot below, we are trying to import the data into the cell B3, which therefore becomes the destination to key in the IMPORTFEED formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importfeed-1-1.png” alt=”importfeed 1″ title_text=”importfeed 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We ensure the\u00a0<\/strong><\/span>url\u00a0is valid, i.e. enclose\u00a0<\/span>url\u00a0within\u00a0<\/span>double quotes<\/strong>\u00a0and\u00a0hit the\u00a0<\/span>Enter\u00a0<\/strong>key. Below\u00a0is what we see as Google Sheets tries to fetch the data. The larger the feed, the longer it might take to finish the data import.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed2.png” alt=”Importfeed in Google Sheets” title_text=”importfeed-google-sheets” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n While the data import is in progress, the cell in which we keyed in the formula, looks like it\u00a0returned as an error. Please note a little red speck on the top right corner of the cell. However, it isn\u2019t an error, but a\u00a0<\/span>transient state<\/strong>. Hover the mouse on the cell, to see the following description.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed3.png” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As soon as Google Sheets loads the data, the red speck disappears. You\u2019ll notice the data extends from the formula cell (B3) to right and also further down.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importfeed-4.png” alt=”importfeed 4″ title_text=”importfeed 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n So, it is of utmost importance that we\u00a0<\/span>keep the expected real estate of the result,\u00a0clear of any preoccupied values. Otherwise, IMPORTFEED formula might cough up a #REF! error. For example, following image explains what could happen, if we had any values, for instance, in cell\u00a0C9.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importfeed-5.png” alt=”importfeed 5″ title_text=”importfeed 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here, in the cell B1, we have stored the\u00a0<\/span>URL<\/strong>\u00a0<\/span>to the RSS feed from which we are trying to import data. So, we\u2019ll use that cell to refer in the IMPORTFEED formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importfeed-6.png” alt=”importfeed 6″ title_text=”importfeed 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This is how you use the IMPORTFEED formula in Google Sheets. If you want to read more about the formula, you can check out the\u00a0<\/span>Google support page<\/a>. If you want to know how to import data from .csv or .tsv files from the web, check out the following\u00a0<\/span>blog post<\/a>.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" With the IMPORTFEED\u00a0formula, we can\u00a0import data from RSS and Atom feeds into Google Sheets. Syntax IMPORTFEED(url, [query], [headers], [num_items]) url\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. A valid and […]<\/p>\n","protected":false},"author":40,"featured_media":4238,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"With IMPORTFEED<\/a> formula, we can import data from RSS and Atom feeds into Google Sheets.\n\n
\n
Usage: IMPORTFEED Formula<\/h3>\n
Case # 1: IMPORTFEED(url)<\/h5>\n
Case # 2: IMPORTFEED(url cell reference, titles of the items, include headers, fetch 20 items)<\/h5>\n
Syntax<\/h3>\nIMPORTFEED(url, [query], [headers], [num_items])<\/strong><\/span>\n\n\u00a0\n
\n \t
\n \t
Usage: IMPORTFEED Formula<\/h3>\n
Case # 1: IMPORTFEED(url)<\/h5>\nIn the\u00a0snapshot below, we are trying to import the data into the cell B3, which therefore becomes the destination to key in the IMPORTFEED formula.\n\n
![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed.png\")
\n\nWe ensure the url<\/strong><\/span>\u00a0is valid, i.e. enclose url<\/strong><\/span> within double quotes and\u00a0hit the Enter key. Below\u00a0is what we see as Google Sheets tries to fetch the data. Larger the feed, the longer it might take to finish the data import.\n\n![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed2.png\")
\n\nWhile the data import is in progress, the cell in which we keyed in the formula, looks like it\u00a0returned an error. Please note a little red speck on the top right corner of the cell. But, it isn\u2019t an error, but a transient state. Hover the mouse on the cell, to see the following description.\n\n![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed3.png\")
\n\nAs soon as Google Sheets loads the data, the red speck disappears. You\u2019ll notice the data extends from the formula cell (B3) to right and also further down.\n\n![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/imporfeed4.png\")
\n\nSo, it is of utmost importance that we keep the expected real estate of the result,\u00a0clear of any preoccupied values. Otherwise, IMPORTFEED formula might cough up a #REF! error. For example, following image explains what could happen, if we had any values, for instance, in cell\u00a0C9.\n\n![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed5.png\")
\nCase # 2: IMPORTFEED(url cell reference, titles of the items, include headers, fetch 20 items)<\/h5>\nHere, in the cell B1, we have stored the url<\/strong> to the RSS feed from which we are trying to import data. So, we\u2019ll use that cell to refer in the IMPORTFEED formula.\n\n
![\"IMPORTFEED](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importfeed6.png\")
\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/2677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=2677"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/2677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/4238"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=2677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=2677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=2677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}