How to Quickly Copy Tables from Website to Google Sheets | Google Sheets Tutorials
On this occasion, I would like to share a tutorial on how to quickly copy tables from the website to Google Sheets. Considering that some websites present quite a lot of information or data in the form of tables and it might take a long time if you have to copy data from these tables, this tutorial will make it easier for you to copy them quickly. Here's a description of the steps:
1. Open your Google Sheets worksheet,
2. Open the website that contains the table data to be copied,
3. Then, return to your Google Sheets worksheet view and type the formula in one of the Sheets cells with the format =IMPORTHTML("web address", "table") . As an example in the video tutorial, I will copy a table from the Wikipedia website with the article title East Java, so the formula I type is =IMPORTHTML("https://id.wikipedia.org/wiki/Jawa_Timur", "table") .
4. Press the "Enter" key on the keyboard,
5. Done.
As additional info, if the website has several tables or more than one table, then you type the following formula:
=IMPORTHTML("web address", "table", 1)
Number one above is the order of the table from the website. If there is more than one table on the website, enter the numbers in order.
Hope it is useful.