Copy-pasting tabular data from the internet into a spreadsheet can generate formatting issues. For this reason, IMPORTHTML is an easier way to import data from sites like Wikipedia directly into your spreadsheet while retaining the correct layout. In addition, this formula ensures your data is always up-to-date<\/strong>. Google Sheets updates in real time, pulling live data directly into your spreadsheet. When the website is updated, your Google Sheet is updated automatically too. Here’s how to use the formula.<\/p>\n IMPORTHTML(url, query, index)<\/strong><\/span><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Take a look at the screenshot below. I want to import data into cell B3, so this is where I enter my IMPORTHTML formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importhtml-google-sheets-1.png” alt=”importhtml google sheets 1″ title_text=”importhtml google sheets 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 Make sure that the\u00a0<\/span>url\u00a0is valid, i.e. enclose the url\u00a0with\u00a0<\/span>double quotes<\/strong>\u00a0and\u00a0hit\u00a0<\/span>Enter<\/strong>.<\/span><\/p>\n While Google Sheets fetches the table data, it displays a Loading<\/strong> notification. Wait a few moments. The bigger the table, 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\/importhtml2.png” alt=”Importhtml Google Sheets: Loading Data” title_text=”importhtml-data-loading” 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, cell B3 looks like it has returned an error. See the little red speck on the top right hand corner of the cell. However, it isn\u2019t an error, just a\u00a0<\/span>transient state<\/strong>. Hover the mouse over 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\/importhtml3.png” alt=”Importhtml Google Sheets: Snapshot of Error” title_text=”error-message” 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 has finished loading the data, the red speck disappears. You\u2019ll notice the data extends from the formula cell (B3) to the right and further down the spreadsheet.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importhtml-google-sheets-4.png” alt=”importhtml google sheets 4″ title_text=”importhtml google sheets 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 Make sure you leave enough room in the spreadsheet for the entire table of data. If you don’t, IMPORTHTML formula might cough up a #REF! error. Take a look at the following image to see what happens when I have data in cell\u00a0C9.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importhtml-google-sheets-5.png” alt=”importhtml google sheets 5″ title_text=”importhtml google sheets 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 In this example, I have stored the url in cell B1. This is the\u00a0<\/span>url<\/strong>\u00a0<\/span>to the HTML page containing the list we want to import. I\u2019ll refer to that cell in the IMPORTHTML Google Sheets formula, which I enter into cell B3. The result is the same except this time I want a list instead of a table.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/importhtml-google-sheets-6.png” alt=”importhtml google sheets 6″ title_text=”importhtml google sheets 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 Looking for more timesaving formulas and tricks in Google Sheets? If you regularly need to import data from from\u00a0<\/span>.csv or .tsv files from the web, check out the following\u00a0<\/span>how to use the IMPORTDATA formula in Google Sheets.<\/a><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" If you want to\u00a0pull online data into Google Sheets from a website,\u00a0IMPORTHTML\u00a0Google Sheets formula is a great tool to have up your sleeve. It imports data from a table or list on any webpage without you having to copy-paste or adjust the data using other formulas. Copy-pasting tabular data from the internet into a spreadsheet […]<\/p>\n","protected":false},"author":40,"featured_media":4230,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"If we need to pull data into Google Sheets from a table or a list on an HTML page, IMPORTHTML<\/a> formula is the one to go with.\nSyntax<\/h3>\n
\n
\n
How to import data from a webpage into Google Sheets<\/h3>\n
Option 1: IMPORTHTML(url, \u201ctable\u201d, index)<\/h5>\n
Option 2: IMPORTHTML(url cell reference, \u201clist\u201d, index)<\/h5>\n
Syntax<\/h3>\nIMPORTHTML(url, query, index)<\/strong><\/span>\n
\n \t
\n \t
Usage: IMPORTHTML Formula<\/h3>\n
Case # 1: IMPORTHTML(url, \"table\", index)<\/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 IMPORTHTML formula.\n\n
![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml1.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 table data. Bigger the table, the longer it might take to finish the data import.\n\n![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml2.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, just a transient state. Hover the mouse on the cell, to see the following description.\n\n![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml3.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![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml4.png\")
\n\nSo, it is of utmost importance that we keep the expected real estate of the result,\u00a0clear of any preoccupied values. Otherwise, IMPORTHTML 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![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml5.png\")
\nCase # 2: IMPORTDATA(url cell reference, \"list\", index)<\/h5>\nHere, in the cell B1, we have stored the url<\/strong> to the HTML page from which we are trying to import a list. So, we\u2019ll use that cell to refer in the IMPORTHTML formula. And, the result is same as that of\u00a0the first case. Except, now the result is a list instead of a table.\n\n
![\"IMPORTHTML](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/importhtml6.png\")
","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2649","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\/2649","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=2649"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/2649\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/4230"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=2649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=2649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=2649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}