How do I get soccer data from website automatically to excel

**MPiii** · 05-06-2021, 05:06 PM

Hello,

I want to import all soccer tables from soccerstats .com to excel.

How can I do that?

Im new in VBA, so I dont have any idea, what to do..

It would work if I import each table individually, can I do it automatically?

Thanks for your help.

**Keebellah** · 05-06-2021, 05:13 PM

Hi, welcome to the forum.
You should search in Google for webscraping soccer data and you can search specifically for the German soccer data.
Will be simpler then teaching you VBA
If you look at the website where you have all the data and right click the webpage look for the 'View Page Source' option then you'll see all the data en there you need to start looking for specific parts to get the right table and data
I have my own version for the Dutch competition use FCUpdate.com

Try https://www.fcupdate.nl/competities/...nd/bundesliga/

**MPiii** · 05-07-2021, 01:42 AM

Hi. Thanks for your answer.

Yes, but my website is difficult, because there are 2 dropdown menu when you click on teams and then, you have to click on the league first, before you can get the stats from the teams of the league.

Is this also possible?
When yes, how?

Thanks for your help

**Keebellah** · 05-07-2021, 02:17 AM

Hi, that is why you do the web-scraping, you don't look at the website but at the content's code and there you have to look for what you need
Which website are you using to extract the data from? Can you post the link to it?

**MPiii** · 05-07-2021, 02:19 AM

Hi, thanks for the reply.

Can you please look into your private messages?

I cant post links here, because Im new..

**Keebellah** · 05-07-2021, 03:01 AM

Hi Manuel, paste the entire link below including the text view-source in your browser and you will see what the content of the site is for 2. Bundesliga 2020/2021

view-source:https://www.soccerstats247.com/compe.../2-bundesliga/

This is where you have to scrape the data.
You’ll see it’s not that simple

If you never even heard of that then you should start with looking it up in Google and start trying, I cannot solve this for you because it will require a lot of searching and time, we are a forum to help.
If you want the forum to create something for you then you’ll have to think if it’s worth for you to apply for paid support.

**MPiii** · 05-07-2021, 03:19 AM

I would pay $30, if everything is working and I know how to do it..

**Keebellah** · 05-07-2021, 03:48 AM

To apply for paid support read the forum rules and place the request there but personally I think you'll get better results if you learn for yourself, once you get the idea you'll see it is quite simple and you can then apply it to other needs.

See the attached file, it's from a site that has tutorials and more