Anyone have success bringing in Stats.NBA.com data to Google Sheets?

Home for all your discussion of basketball statistical analysis.
Post Reply
RyanRiot
Posts: 23
Joined: Wed Oct 19, 2016 2:26 am

Anyone have success bringing in Stats.NBA.com data to Google Sheets?

Post by RyanRiot » Thu Mar 07, 2019 10:33 pm

I'm sure many of us use Google Sheets' ImportHTML function to automate pulling data from various sites, although it unfortunately doesn't work with Stats.NBA.com. I'm wondering if anyone has been able to find a good way to automatically pull in data from the site. Using the API, I'm able to get a JSON string like the one https://stats.nba.com/stats/leaguedasht ... sDivision= which contains the data from this table, but I'm unsure of how to use that to recreate the table in Sheets. Does anyone have experience with this?

Rd11490
Posts: 114
Joined: Mon Sep 29, 2014 4:54 am

Re: Anyone have success bringing in Stats.NBA.com data to Google Sheets?

Post by Rd11490 » Fri Mar 08, 2019 2:48 am

I know this isn't exactly what you want but this chrome extension: https://chrome.google.com/webstore/deta ... njkfbcmeha

allows you to download the tables on a page as a csv.

Post Reply