How to Get Web Page Data with Google Sheets

A myriad of tools like browser extensions exist to help ease the necessary technical knowledge. But even if they are a bit "too much" for you, do not worry. Google Sheets will come to help you

Google Sheets has a handy little formula that allows you to extract lists or data sheets of web pages into your chosen worksheet. That formula is called importhtml and works like this:

Find the Site You May Need to Retrieve Data

For example, consider the list of top technology companies in terms of revenue on Wikipedia:

https://en.wikipedia.org/wiki/List_of_largest_technology_companies_by_revenue

Specify the Table or List You May Need to Extract Data from

In this case, select the second table on the page, in the '2019 list' section.

Now, Enter the Following in the Arbitrary Box (Suppose A1)

=IMPORTHTML('https://en.wikipedia.org/wiki/List_of_largest_technology_companies_by_revenue', 'table', 2)

As you can see, you will have to declare three things in the formula: the URL you may need to get data from, the type of data (table or list) and the position (in this case, the second table, so, the number in the formula is 2 ).

Hit Enter and the table will appear in the worksheet:

The table will appear in the worksheet

To go to the next level and actually convert or delete that data, first make sure that it is put in a static state instead of linked data. To do so, select the table, right-click in cell A1 , select Paste special> Paste values only .

All operations are completed. Feel free to do what you like with data in Google Sheets!