Connecting data to the web
It's great that you can get data from the web. Not only can you get the data, but you can also clean it, getting rid of any unwanted data and formatting it in the correct format before loading it into Excel. By doing this, the next time you want to use this data, you can simply refresh it and automatically get all the new updates.
Note
There is one limitation while getting data from the web: the data must be formatted as HTML tables and not as JavaScript.
We are going to look at two different ways to connect to the web, as follows:
- The first way will show you how to connect multiple different tables from the same site, although there are not many rows in each table.
- The other way is to connect to a CSV file that contains just over a hundred thousand rows of data.
Being a typical South African, I am really into sports, especially cricket. Let's have a look at Sky sport's cricket tables, which can be found at https://www...