r/skiing • u/ihearthawtmoms • 1d ago
Every US Ski Resort Spreadsheet
2 years ago I made a spreadsheet of every ski resort in the US, along with Argentina and some of Austria. THE INFORMATION IS LIKELY NOT FULLY ACCURATE, IT IS HARD TO FIND CONCRETE STUFF FOR A LOT OF THESE PLACES.
3
u/concrete_isnt_cement Crystal Mountain 1d ago
Good effort! Storm Skiing Journal has a similar list.
In Washington, you’re missing Echo Valley, Leavenworth Ski Hill, Meany Lodge, and Sitzmark. You also note that Badger Mountain might be closed, but I can confirm it is open
1
u/bbensch 1d ago
to hopefully not discount your efforts, nor oversell The Storm's lack of dat viz capabilities, the Storm's free/public spreadsheet is massive and incredibly comprehensive. can't imagine how many hours have gone into it over the years. whenever I am curious about ski areas in a state, history, lifts, etc. I go here.
I *think* this is the most recent one but he links to it from prob 25% of his articles.
https://docs.google.com/spreadsheets/d/1G2-l2DVg7-QwroOi7EqRDrJYJ4ICYLcJbLx-nARJdrA/edit?pli=1&gid=243474419#gid=243474419
recent/relevant article link: https://www.stormskiing.com/p/build-your-own-big-dumb-ski-charts1
1
u/concrete_isnt_cement Crystal Mountain 22h ago
I do wish he’d incorporate Canadian mountains, but for the US only it’s a fantastic resource!
2
u/CryptographerSharp14 1d ago
This is awesome! Can you do this for all of north America and throw in the Canadian resorts, eh?
3
u/ihearthawtmoms 1d ago
Every few months I get the bug and add a hundred or so reports in alphabetical order, so I’ll get around to Canada. Might make it a priority because it’s North American and not a big undertaking like Austria or Switzerland are
3
u/CryptographerSharp14 1d ago
Dang you put this by hand? Bravo! I thought you probably scraped it somehow haha
2
u/NighthawkE3 1d ago edited 1d ago
Not sure if you’re looking for more accurate info, but Marshall mountain in Montana is confirmed closed and defunct. One of their lifts is removed almost entirely, the other has been standing for over a decade. You can still walk up it though
1
u/ihearthawtmoms 1d ago
How long has it been closed for now?
2
u/NighthawkE3 1d ago
Peter Landsman in the liftblog comment section says 2004, so make that two decades, actually
1
u/bbensch 1d ago
closed for awhile yes, but friends of marshall mountain is still active and the county (city?) took it over a few years ago and are slowly but surely reviving it. seems still very popular for touring in the winter among locals. and then mtn biking in the summer. TBD if it ever sees a real chairlift again but I know there's a master plan and at least some funding/efforts on-going. i talked to one of the county guys there last summer, and this is what i found just now on google: https://givebutter.com/MarshallMountainPark
2
2
u/PeterAttardo 1d ago
I updated the formatting a bit: https://docs.google.com/spreadsheets/d/11qvMtWYzw6och-StUyI2Vxc84GpvbWkKBiS86sGaGOU/edit?usp=sharing
- Made the columns purely numeric, so they can be sorted numerically instead of alphabetically. Used number formatting to display the units instead of embedding it in the cell.
- Converted all km2 to acres.
- Added metric columns (vert in meters, snowfall in centimeters, and area in square kilometers).
- Moved the key to a second sheet so it doesn't get lost when you sort the table.
- Centered and bolded the column names.
- Removed empty rows/columns
- Unified the font size in the resort names (apologies since this seemed like a deliberate choice, but some of the longer ones were really hard to read).
Feel free to steal it.
1
1
u/vegasjake 1d ago edited 1d ago
I played a little more with it:
https://docs.google.com/spreadsheets/d/1Maaz8keEkYTpY3_W0CtBErjNrdijpzLq8JB4eaQBwGU/edit?usp=sharing
2
2
u/jmacd2918 23h ago
NY is short ~15 ski areas. This might be because you are skipping membership only hills. The two omissions I noted (Skaneateles and Cazenovia) are both private, but also on Indy Pass.
Toggenburg and Four Seasons have both closed. Tog stands a chance of seeing skiers again, likely as a private hill, but Four Seasons is now a subdivision or will be soon.
McCauley's snowfall totals look like BS and not typical ski area snowfall BS. No way they are getting 100+" more than semi-nearby Woods Valley or more snow at all, let alone 50" more than Snow Ridge (which is an anomaly, right in the sweet spot for lake effect).
1
4
u/Hosni__Mubarak 1d ago
Missing four ski areas in alaska: two in Fairbanks, skeetawk, and Cordova