0

I want to get some data from this web site in a google sheet I tried importhtml , importxml but nothing is working for me. Does any one can test if is possible to get the data? How can I do that?

https://www.scorespro.com/livescore-opap/#

Or if not possible from this site what about this site

https://free.scorespro.com/opap-livescore/soccer.php

Rubén
  • 34,714
  • 9
  • 70
  • 166
nikosthe15
  • 21
  • 1
  • 3

1 Answers1

1

This website is generated by javascript and cannot be imported using Google Sheets formulas. You can check it using IMPORTDATA. Normally it pulls out all the contents. But not here.

Also it is a commercial website that provides live data through their API. So it's quite normal that it is not easy to scrape.

Related:

Iamblichus
  • 18,540
  • 2
  • 11
  • 27
Krzysztof Dołęgowski
  • 2,583
  • 1
  • 5
  • 21
  • I appreciate your help. Do you have any suggestion on how should I approach that? I mean what would you do if you wanted to get that table in a google sheet. They do have a free API but is only for web sites. What would you do? – nikosthe15 Mar 09 '21 at 20:38
  • It there's an API Get where you put the information you need (and authorisation key too) in url address then you can import it's contents into google sheets. The easiest way is when they provide data in xml format. Then you can use importxml to fetch the data you need from provided content. – Krzysztof Dołęgowski Mar 09 '21 at 20:45
  • Thank you for your answer. I send them an email to see if they can provide a free xml API for personal use. I hope I can procced further. – nikosthe15 Mar 09 '21 at 21:00
  • FYI ‘to scrap’ means to throw away like rubbish. The correct term for what you’re doing is __scrape__ – DisappointedByUnaccountableMod Mar 09 '21 at 22:09
  • Thanks :-) English is not my native language :-) – Krzysztof Dołęgowski Mar 10 '21 at 06:54