How to Extract Data from ANY Website to Excel

Here's to extract data from any website and turn it into a convenient Excel spreadsheet. All done using free web scraping.

0:00 Intro
0:40 Download ParseHub
1:10 Start of web scraping project
1:47 Using the relative select command
2:15 Dealing with Pagination
2:50 Exporting data to excel
---
Follow Us

#webscraping

[pareexitsinghparihar]

You won't believe that I've been waiting for something like this since last 2 years.
Thanks a TON to you.
🙌

[pedrosilveira]

This software just saved my life. Like, at least hours of it. Thanks

[IIISWILIII]

thank you for this straight forward and unconvoluted tutorial. I made my first scrape with ease

[Adelicate]

To whoever built this, I'm in love with you 😍

[TortuousAugur]

Program is beautiful and unbelievably user friendly. However, once I managed to get the program set up through how laggy it was navigating the websites to set up the scrape, it was going well for the first 10-30 minutes. Afterwards, updates were slower and slower until finally, after about an hour, the program no longer updated but gave no warning from windows that it was no longer responding. I let it sit for around 24 hours and still no update to the scrape progress.

I don't know if this is because it's the free version and there is something in the programming to bog the scrape down, maybe my computer couldn't handle it or the program was keeping every one of those 188 out of almost 600 pages open instead of closing them afterwards but the scrape never completed and I had to use task manager to force close the app.

I'll say again: absolutely beautiful and user friendly. I've never needed to scrape info like this before and this program could not have been more easy to learn but unfortunately, something didn't want to work correctly.

[SlyGuy]

TRUST ME! you need this program, takes a few trys to understand it but once you get its such a amazing tool!!!

[maxsteel]

Great job! Wish all tutorials were this concise and clear

[khondokeristehadkabir]

Saved me a full day of work!
& it is a free tool.

Thanks.

[soccerskillz]

What to do if the website has an infinite scroll function rather than loading new pages?

[jestoniperalta]

Hi, Just noticed on the address part you only scrap the first row of the address? how to get the full address because the address only shows the first row? how about the second row?

[nikhilreddythokala]

Tq very ❤❤ much it helped me a lot for my project to collect data

[redskins]

I'm doing a data paper on grocery stores. Is there any way to go to a grocery store Page and copy their web page. Would that be data scraping? I'm sorry I'm so new to this

[sadiajaved]

Excellent Web Scraping Tool... Thanks a lot. I have obtained valuable information using the instructions in this video. Many thanks ... You are Awesome !!!

[wellreadbull]

Somebody is keeping the comment section clean😂

[pedrohenriquecostamendes]

Does it wort to take information from google maps?

[esamelhosiny]

it should that video to get to one billion view, great legends!

[noahsquas]

great stuff! only starting the whole scraping odyssey, and this vid is amazing

[thfugee]

when I saw bbq express I knew you guys were from T.O. Thx for the video well put.

[sirfa]

I tried but it scrapes only 2 pages even though I selected number of pages I wanted to scrape

[fantab]

Is there a way to pickup data from cells in a particular column, use it to search on a website and then paste data on the same excel that we pick up the information from? Please HELP!!!