23 Responses

  1. Keith
    Keith at | | Reply

    Love this stuff though not very good at it. IMPORTHMTL function did not work for me? Checked formula several times and its right but getting circular dependency error, can you help!

    1. Tanner
      Tanner at | | Reply

      Hi Keith, could you share your Google Sheet with me so that I can edit it/see the formula you’re using? I can try to troubleshoot it for you.

  2. Michael Underhill
    Michael Underhill at | | Reply

    Single digit month and day no longer working? How do you make it double digit? Example 2016-04-04. Thanks in advance!

    1. Tanner
      Tanner at | | Reply

      It just looks like it’s not up and running yet. I’ll keep an eye on it and see if it shows up and starts working.

      1. Tanner
        Tanner at | | Reply

        Is this link any different than the 2015 one: http://www.fangraphs.com/leaders.aspx?pos=all&stats=pit&lg=all&qual=0&type=8&season=2015&month=0&season1=2015&ind=0&team=0&rost=0&age=0&filter=&players=p2016-04-03

        I see it doesn’t work for 2016-04-04, but maybe they’re still getting things going for the season.

  3. Mike M
    Mike M at | | Reply

    Hi Tanner,
    I’m having an issue importing my probable pitchers list into Excel. It imported the player ID and team ID maps no problem, but when I try the probable pitchers list from Google Sheets, step 1 of the import wizard gets stuck on “Loading…” in the preview, and nothing happens. Any idea what’s going on here?

    1. Tanner
      Tanner at | | Reply

      Hey Mike,

      Are you saying you’re having a hard time importing the probables into Google Sheets? Or are you saying the Google Sheets part was fine but the Excel piece to pull in from Google is where it’s slowing down?

      The Google piece seems to be working for me. But one small change for the 2016 season is that you may want to change the URL to only include 2016 stats. To do that the URL becomes:

      =”http://www.fangraphs.com/leaders.aspx?pos=all&stats=pit&lg=all&qual=0&type=8&season=2016&month=0&season1=2016
      &ind=0&team=0&rost=0&age=0&filter=&players=p”&A1

  4. Jacon
    Jacon at | | Reply

    This post was really informative and well laid out. The issue I have is trying to get the projections data from Fangraphs automatically. Since there no longer seems to be way to access the entire list via URL variables, so you have to clickthrough each page manually with the mouse or you have to either download the Excel file manually. Any ideas?

    1. Tanner
      Tanner at | | Reply

      Yeah, I agree. I don’t think the projections have ever been able to be pulled in all at once. They’ve always required click throughs to get to the subsequent pages.

      It’s not perfect, but I just set my Excel file up to import a CSV file. And just replace that CSV with a fresh download when I want the projections to update.

  5. Jonathan
    Jonathan at | | Reply

    Thanks for the article! The data from fangraphs is loading into my google sheet by the sheet is asking to set the page size. I figured it had something to do with the amount of players being pulled over from fangraphs so I’ve adjusted the page size there to no avail. Have you seen this before? Everything else works perfectly, it just looks messy when I bring the data over to excel.

    1. Tanner
      Tanner at | | Reply

      Hi Jonathan,

      I don’t think I’ve seen this before. I’ll e-mail you to see if you’re able to send me a screenshot of what you’re seeing.

      Thanks,

      Tanner

  6. Kaz Kalita
    Kaz Kalita at | | Reply

    Hello,

    Great article. How do I do step two under the import published CSV file on a Mac, since there is no spot to copy the Google Sheet URL?

    Thanks.

  7. Ari
    Ari at | | Reply

    Hi, thanks for this post. I was able to include the probable pitchers into my spreadsheet but now i am wondering how i export all the hitters in as well as their stats so that i can create a formula that helps me cut it down to a few guys that will just get a hit for that day. Please help.

    thanks

  8. Kaz Kalita
    Kaz Kalita at | | Reply

    Yeah, I’m looking to do the same thing as Ari. I’m looking to somehow import the starting lineups into a tab as they are released and then based off of that import hitter data of those players from FanGraphs. I’m thinking of having a tab for each position that only includes players that are playing on that particular day so we can eliminate most of the noise.

    Any tips or suggestions on how to do this or where to begin?

    Thanks,
    Kaz

  9. Stephen Coz
    Stephen Coz at | | Reply

    Hey Tanner,

    First off, I love your site. I just came across it trying to find an Excel import for MLB schedules/probables, and I think this might work for what I need. Anyways, I’m having a weird issue that has not been discussed – the first row of data being imported into my Google Sheet is the “Page Size” dropdown from FanGraphs. I think I can just hide those rows in the Excel import, but was just wondering if you’ve encountered that or had a fix. I can send you a screenshot of what is happening.

    Thanks!

  10. Stephen Coz
    Stephen Coz at | | Reply

    Never mind, I fixed it. Just had to start the import at the row with the headers. Best of luck and thanks for making such a great site!

Leave a Reply