Importing Tables to Google Spread Sheet: need help from Excel/ spreadsheet guru.

Hi to help admin work easier I wanna import tables on the google spreadsheet. 

By doing this I will have a fast access to top players list of the team. Team members, Top players, Team match results, etc etc.... 

Today I do import this just to copy paste. But It would be much better to automaticly updating this. 

I know I can create an excel sheet with a update of a webquery. But excel are as far as I know locked down with crappy IE wich is not a good browser at all. 

I very familiar with Excel But havent used Google Spreadsheet much. 

Just to show how it can be done through youtube. Look at this Video: 

And This is How It looks like when I download to my google spread my self. 

EXAMPE 1. Shows how It can WORK! This was just to test forumula in another website: 

Just a Premier league table. 

Forumla can be seen in the Green color

EXAMPLE 2: CHESS:COM

This one do not work. Not on V2 or v3. I only get the HEadline of the table. 

Am I doing something wrong?  Any Spreadsheet Guru who knows if the forumla is wrong? Etc etc. 

Hi Rune,

I tried importXML, but get same result as you.

I assume it is a problem because of dynamic content. Google spreadsheet may try to read content while it is not loaded/ready and therefore not getting any results. Just a hypothesis. 

I tried to grep on several attributes and classes, but it only returns the table headers. I cannot grep on content inside the table. I can see in the code that win/loss/draw is a list, but it is not shown in the spreadsheet, like it does not exist.

You may get a better answer on Stack Overflow or other forums for web scraping.

EDIT:

If I do the following (A1 is the URL), it returns the code for the page, but does not include the dynamic content. It lacks all ng-bind, ng-repeat parts (AngularJS?)

=importXML(A1, "//*")

 Thanx. I will search in other forums. 

I know it have to be possible. But I can always use the Excel and the Awfull IE browser. 

Good luck

PS: See my edit in my last post.

Thanks. Im not so famliar with the HTML coding. But I have a feeling its the dynamic content. But Its also the same in V2. Wich is not dynamic. 

Please feel free to join the official Chess.com Developer Community club at https://www.chess.com/club/chess-com-developer-community

Even if you are not familiar with coding, watching the activity there will alert you to when (if) we make a programming interface for downloading leaderboard information.

Thanks I will join. 

I'm not familiar with coding. But are a decent excel user.