This is the most powerful method for live web pages. Open Excel and navigate to the Data tab. Select Get Data > From Other Sources > From Web . Paste the URL of the webpage containing the data.
Go to > Get Data > From File > From Text/CSV (note: some versions may list "From HTML" or require you to select "All Files"). Select your file and click Import . download convert html to excel
Comprehensive Guide to Downloading and Converting HTML to Excel This is the most powerful method for live web pages