Excel - Get Data From Web - HTML table - Part 1

Learn how to get data from web pages that have HTML tables in them to Excel and keep active connection to the page.

This tutorial is Part 1 from "Excel - Get Data From Web" series.

#excel #web #html

[hvkadam]

That was very helpful. I wanted some more where I should be able to take particular table periodically like every 30 mins and append to existing data. I don't want to override the existing data

[riteshpandey]

Sir please make video on Google Script and sheet, we know you for this, please don't become the member of crowd, you are unique person with unique knowledge.

[chantinon]

Great!! Idea for creating a Google Script to extracts all tables and lists from a site and lists them in a spreadsheet.

[MrAstonmartin]

Do we have such a tool in Google Sheets? Or =importhtml only?

[snwlms]

Can we get live data in google sheets as well sir?

[AmauryVanEspen]

Hi, nice tutorial, is there the same tutorial for Spreadsheet and Google Apps Script method ? Thank you

[khemrajrana]

Sir how to protect one Google spreadsheet and one column unprotected to other user can edit

[johnjacobjinglehimerschmid]

How about when the table exists behind a login?

How do you get excel to login to said page? I'm having a hard time figuring out the selenium library. Namely, how to get it installed on my laptop so that I can use it.

[harishkumar-vbeo]

That magnifier is very irritating and i got headache after seeing this video. Please dont use that magnifier. I love ur videos

[YoutubeSalvatrucha]

but my problem is, excell
does not recognize any tables on the website. PLS HELP !

[nishantkumar]

What if there is no table format on some websites? Could you please explain that? Thank You