Syntax<\/h3>\n
IMPORTDATA(url)<\/span><\/strong><\/p>\n It might be useful to note that Google Sheets accommodates up to 50 IMPORTDATA formulas on a single spreadsheet.<\/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\u00a0<\/span>destination to key\u00a0<\/span>in the IMPORTDATA formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/Google-Sheets-importdata-1.png” alt=”Google Sheets importdata 1″ title_text=”Google Sheets importdata 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<\/span>url<\/strong><\/span>\u00a0is valid, and then enter the formula properly (i.e. enclose\u00a0<\/span>url<\/span>within double quotes) and\u00a0hit the Enter key. Below\u00a0is what we see as Google Sheets tries to fetch the data. Bigger the file, the longer it takes to finish the data import.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata2.png” alt=”Google Sheets Importdata: Google Sheets Fetching Data” title_text=”fetch-data-importdata” 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 (as indicated by a little red speck on the top right corner of the cell). But, it isn\u2019t an error, just a transient state. 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\/importdata3.png” alt=”Google Sheets Importdata: Loading Data” title_text=”loading-data-error” 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\/Google-Sheets-importdata-4.png” alt=”Google Sheets importdata 4″ title_text=”Google Sheets importdata 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 keep the expected real estate of the result clear of any preoccupied values. Otherwise, IMPORTDATA 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\/Google-Sheets-importdata-5.png” alt=”Google Sheets importdata 5″ title_text=”Google Sheets importdata 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, we have already\u00a0stored the\u00a0<\/span>url<\/strong>\u00a0<\/span>to the .csv in the cell B1. So, we\u2019ll use that cell to refer in the IMPORTDATA formula, and the result is same as that of\u00a0the first case.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/Google-Sheets-importdata-6.png” alt=”Google Sheets importdata 6″ title_text=”Google Sheets importdata 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 Learn in\u00a0<\/span>this blog post<\/a>\u00a0how to easily\u00a0<\/span>import RSS feed to Google Sheets.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" The\u00a0IMPORTDATA\u00a0formula in Google Sheets is quite a handy tool. It helps us fetch data, that is stored\u00a0in\u00a0.csv (comma separated values)\u00a0or\u00a0.tsv (tab separated values)\u00a0files, from a location on the web. Syntax IMPORTDATA(url) url\u00a0\u2013 this is the address (uniform resource locator) on the web, where the .csv file or .tsv file is located.\u00a0This can take two forms. […]<\/p>\n","protected":false},"author":40,"featured_media":4070,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The IMPORTDATA<\/a>\u00a0formula in Google Sheets is quite a handy tool. It helps us fetch data, that is stored\u00a0in .csv (comma separated values) or .tsv (tab separated values) files, from a location on the web.\n\n
\n
Usage: IMPORTDATA Formula<\/h3>\n
Case # 1: IMPORTDATA(\u201clocation of the csv or tsv file located on the web\u201d)<\/h5>\n
Case # 2: IMPORTDATA(reference to a cell where url is stored)<\/h5>\n
Syntax<\/h3>\nIMPORTDATA(url)<\/span><\/strong>\n
\n \t
\n \t
Usage: IMPORTDATA Formula<\/h3>\n
Case # 1: IMPORTDATA(\"location of the csv or tsv file located on the web\")<\/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 IMPORTDATA formula.\n\n
![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata1.png\")
\n\nWe ensure the url<\/strong><\/span>\u00a0is valid, and then enter the formula properly (i.e. enclose url<\/span> within double quotes) and\u00a0hit the Enter key. Below\u00a0is what we see as Google Sheets tries to fetch the data. Bigger the file, the longer it takes to finish the data import.\n\n![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata2.png\")
\n\nWhile the data import is in progress, the cell in which we keyed in the formula, looks like it\u00a0returned an error (as indicated by a little red speck on the top right corner of the cell). But, it isn't an error, just a transient state. Hover the mouse on the cell, to see the following description.\n\n![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata3.png\")
\n\nAs soon as Google Sheets loads the data, the red speck disappears. You'll notice the data extends from the formula cell (B3) to right and also further down.\n\n![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata4.png\")
\n\nSo, it is of utmost importance that we keep the expected real estate of the result,\u00a0clear of any preoccupied values. Otherwise, IMPORTDATA 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![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata5.png\")
\n\n\u00a0\nCase # 2: IMPORTDATA(reference to a cell where url is stored)<\/h5>\nHere, we have already\u00a0stored the url<\/strong> <\/span>to the .csv in the cell B1. So, we'll use that cell to refer in the IMPORTDATA formula, and the result is same as that of\u00a0the first case.\n\n
![\"IMPORTDATA](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importdata6.png\")
\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2534","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\/pt\/wp-json\/wp\/v2\/posts\/2534","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=2534"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2534\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/4070"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}