IMPORTHTML(url, query, index)<\/strong><\/span><\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections T – Automate between spreadsheets – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_module=”50460″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Automate data transfers between spreadsheets Find out how<\/a><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please consider the image below. B3 is the cell where we are entering the IMPORTHTML formula. On the web page where the URL (mentioned above) takes us, we are rather interested in the second table. Hence we\u2019re going to use \u201ctable\u201d for\u00a0<\/span>query<\/strong><\/span>\u00a0<\/span>parameter and 2 for\u00a0the\u00a0<\/span>index<\/strong><\/span>\u00a0<\/span>parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-1.png” alt=”HTML Table to Google Sheets: IMPORTHTML Formula and Explanation Window” title_text=”importhtml-formula” align=”center” _builder_version=”4.23.1″ 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 make sure that the\u00a0<\/span>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. Bigger the table data, 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\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-2.webp” alt=”HTML Table to Google Sheets: Google Sheets Fetching Data” title_text=”fetch-data-google-sheets” align=”center” _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 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>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-3.png” alt=”HTML Table to Google Sheets: Snapshot of Data Loading” title_text=”loading-data-google-sheets” align=”center” _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 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>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-4.png” alt=”HTML Table to Google Sheets: Imported Sample Data of Cities and Details” title_text=”imported-sample-data” align=”center” _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 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\u00a0<\/span>IMPORTHTML<\/a>\u00a0formula will return a\u00a0<\/span>#REF!<\/strong>\u00a0error, as shown in the snapshot below. Please note, for the purposes of demonstration, we entered a dummy value in the cell C9.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-5.png” alt=”HTML Table to Google Sheets: REF Error” title_text=”html-table-google-sheets” align=”center” _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 Congratulations! We now learned how to\u00a0<\/span>import a web HTML table to Google Sheets<\/strong><\/em>, by making use of the native IMPORTHTML formula! Go through the following blog post to learn how to\u00a0<\/span>import RSS feed to Google Sheets<\/a>.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”] Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" We all know how resourceful Google Sheets application has become in our daily life. While it is extremely good with all the basic and advanced spreadsheet needs, it also lets us connect with the outside information with ease. For instance, if we need to\u00a0import a web HTML table to Google Sheets, it has a native […]<\/p>\n","protected":false},"author":40,"featured_media":6049,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We all know how resourceful Google Sheets application has become in our daily life. While it is extremely good with all the basic and advanced spreadsheet needs, it also lets us connect with the outside information with ease. For instance, if we need to import a web HTML table to Google Sheets<\/strong><\/em> , it has a native function called as IMPORTHTML<\/a>\u00a0formula. Here's the syntax:\n\nIMPORTHTML(url, query, index)<\/strong><\/span>\n\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\"){kind=icon}
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\n
<\/span><\/p>\nExample: import a web HTML table to Google Sheets<\/h3>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n<\/p>\n\n \t
Example: import a web HTML table to Google Sheets<\/h3>\nPlease consider the image below. B3 is the cell where we are entering the IMPORTHTML formula. On the web page where the URL (mentioned above) takes us, we are rather interested in the second table. Hence we're going to use \"table\" for query<\/strong><\/span> parameter and 2 for index<\/span><\/strong><\/span> parameter.\n\n
![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-1.png\")
\n\nWe make sure that the\u00a0url<\/strong><\/span>\u00a0is within double quotes and\u00a0hit the Enter key. As soon as we do that, Google Sheets tries to fetch the data. Bigger the table data, the longer it might take to finish the data import.\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-2.png\")
\n\nWhile 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.\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-3.png\")
\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![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-4.png\")
\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,\u00a0clear of any preoccupied values. Otherwise, the IMPORTHTML<\/a> formula will return a #REF!<\/strong> error, as shown in the snapshot below. Please note, for the purposes of demonstration, we entered a dummy value in the cell C9.\n\n![\"Import](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/Import-Tables-from-the-web-to-Google-Sheets-Illustration-5.png\")
\n\nCongratulations! We now learned how to import a web HTML table to Google Sheets<\/strong><\/em>, by making use of the native IMPORTHTML formula! Please let us know if you have any questions in the comments section below.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-6048","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\/6048","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=6048"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/6048\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/6049"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=6048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=6048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=6048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}