Hello Everyone,

We have seen a lot of websites having big tables in them with lots of rows and columns. 

What if someday being a developer you feel the need of getting all that data from the website at once without going the nasty way of copy pasting each and everything which would take so much of time and energy.

To extract a table, create a new spreadsheet and enter the following expression in the top left cell:

=ImportHtml(URL, "table", num)

URL here is the URL of the page (between quotation marks), “table” is the tag to look for  and num is the number of the element, in case there are more on the same page.

Once this is done, Google Docs retrieves the data and inserts it into the spreadsheet, including the headers. The last step is to download the spreadsheet as a CSV file.