How to import data from a HTML table on a website to excel

Question

I would like to do some statistical analysis with Python on the live casino game called Crazy Time from Evolution Gaming. I want the data of the lowest table 'Spin History' to be imported into excel. However, I do not now how this can be done. Could anyone give me an idea where to start?

Thanks in advance!

Answer 1

Hello 
To import any HTML file in excel there are a few tips and steps that you'll have to follow.

1. Open your excel file. now change to the DATA tab and press EXISTING CONNECTIONS in getting EXTERNAL Data section.

2. Now press browse for more options in the lower-left corner of the popping out window 

3.Find the HTML file you want to import in the folder, then double-click it or hit open

4. As suggested by the tip, click the arrow icon to select the area of data then hit import in the lower-right corner of the window.

5. You can locate the new table at an existing worksheet or a new worksheet. Choose the location to put the data, then click ok

6. The table in the HTML file has been imported into the Excel sheet. You can adjust it freely now.