Excel data from web not able to select JSON table data

Posted on 2014-08-19
Last Modified: 2014-08-26
Excel has a nice data connection from web feature. It allows you to select a table from the URL that will load the data into Excel automatically. The problem I'm having is the following URL the data must be loading via JSON (or similar) as Excel is not able to view the table in order to select it with the From Web data connection feature.

Any ideas?
Question by:intoxicated_curveball
    LVL 107

    Expert Comment

    by:Ray Paseur
    The referenced URL is an HTML document.  Most of the content is loaded via JavaScript.  This design is usually chosen to prevent unwanted theft of data via "web scraping" of licensed content.

    Does the MLB site have an API that provides a formal interface to retrieve the data?  If so, we might be able to help you use that.

    Author Comment

    You're probably right, but of course just as you can copy and paste the data I am looking for a way to extra it into my Excel sheet.
    LVL 107

    Expert Comment

    by:Ray Paseur
    Let's go back to this.  If you're going to do this with automation, you need something that is susceptible to automation.  Does the MLB site have an API that provides a formal interface to retrieve the data?  If so, we might be able to help you use that.

    Accepted Solution

    There is nothing formal but I've found the JSON live data feed.

    I'm now parsing this data via a server-side page which generates the Table of which I'm importing it into Excel.

    I will except my solution as the solution.
    LVL 107

    Expert Comment

    by:Ray Paseur
    Please be aware of this:
    The accounts, descriptions, data and presentation in the referring page (the "Materials") are proprietary content of MLB Advanced Media, L.P ("MLBAM").  
    Only individual, non-commercial, non-bulk use of the Materials is permitted and any other use of the Materials is prohibited without prior written authorization from MLBAM.  
    Authorized users of the Materials are prohibited from using the Materials in any commercial manner other than as expressly authorized by MLBAM.

    Author Closing Comment

    I found a workable solution on my own.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In my daily work (mainly using, I need to write a lot of JavaScript code. One of the most repetitive tasks I do are the jQuery Ajax calls. You know: (CODE) I don't know if for you it's the same, but for me is soooo tedious to write the …
    This article discusses the difference between strict equality operator and equality operator in JavaScript. The Need: Because JavaScript performs an implicit type conversion when performing comparisons, we have to take this into account when wri…
    Video by: Zack
    Viewers will learn about using Excel in a browser with Excel Online.
    Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now