Pulling API data into Excel is quite a bit easier than what I expected. The most difficult part is understanding how to build the URL you will use to request the data.
In my case, I have been working with the Sportradar API to analyze Husker football data. The first step for me was to get an API key that allows me to get back data from Sportsradar. Once I had that, it was simply a matter of taking these simple steps:
- Open a new Excel workbook
- Click on the Data tab in Excel
- Click From the Web
- Enter the API URL
It’s as easy as that. Unless you have come across an error you should have your data tables listed in Excel.
If you are interested in using the Sportsradar API, checkout http://developer.sportradar.us/