Heads-up: the 2010-11 calendar is here.
The NFL released the official 2009-2010 schedule yesterday… and for the SIXTH YEAR IN A ROW I’m proud to offer the Pittsburgh Steelers Schedule for Microsoft Outlook!
The jimcofer.com “Pittsburgh Steelers 2009 Schedule For Outlook” is compatible with Microsoft Outlook 98 or later. It might also work with Google Calendar or any other program that can import calendar events from CSV files. It has only been tested with Outlook 2003 and Outlook 2007, however.
The schedule contains all preseason and regular season Steelers games as well as the name of the network airing the game. All times are for the Eastern (USA) time zone. A reminder is also scheduled for 8:00PM the day before each game. Fans of other (lesser) teams can also download the file and use it as a template to create a schedule for their favorite team using any spreadsheet app that supports CSV files.
There are three editions of the schedule available for download: the Steelers 2009-10 schedule only, the 2009-10 Steelers schedule with the NFL playoffs and Super Bowl, and a calendar with the playoffs and Super Bowl only. Pick your poison by clicking the appropriate link below:
Steelers 2009-2010 Schedule
Steelers 2009-2010 Schedule with NFL Playoffs
NFL 2009-2010 Playoff Schedule only
* * *
To import the calendar, follow these simple instructions. Make sure to read the all the directions below carefully before you begin:
- Download the file to your desktop and unzip.
- Open Outlook and select “File” > “Import and Export” > “Import from another program or file”, then click “Next”.
- Choose “Comma Separated Values (Windows)”, then click “Next”.
- Use the “Browse” button on the next screen to select the CSV file you unzipped in step 1.
- On the next screen make sure to select “Calendar” as the destination then click “Next” and “Finish”… That’s it!
DISABLING REMINDERS: If you wish to disable the reminders, open the CSV file and change the value of “reminder on/off” (column G) to FALSE for each game before you import the Calendar into Outlook.
CHANGING “SHOW TIME AS”: By default, the entries will display their time as “Free” on your calendar. If you wish to change this to something else, open the file in your favorite spreadsheet app and change the value of each entry in Column V (“Show Time As”) from FREE to “1” (Tentative), “2” (Busy), “3” (Free) or “4” (Out of the Office) – without the quotes.
TROUBLESHOOTING: If you try to import the schedule but don’t see any of the games listed in your calendar (especially if you do not get any kind of error message), shut Outlook down completely (open Task Manager to make sure that OUTLOOK.EXE is not running) and re-open Outlook and try the import again.
VERSION INFORMATION: This file was tested on 15 April 2009 on a Windows Vista x64 machine running Office 2007 and a virtual machine running Windows XP Professional and Office 2003. It was scanned with AVG 8.5 (8.5.287) and found to be virus-free. It’s the exact same file I’ve used for all prior versions of the schedule, so it should work for just about everyone.
Wow! That was fast! thanks!
you can get the other teams at http://www.mysportscal.com
Works. THANKS
This is great! One issue however is that the Superbowl end date on the download is transposed. It reads 7/20/2010. This appears in Outlook like the game starts on 2/7 and ends on 7/20!
Holy crap! You’re right, Dave!
I’ve uploaded corrected versions to the server, so it should be “all good” now.
Thanks for spotting that “bug”!
Jim
Great Job!!!!!
THANK YOU!
Thanks!!!
I keep separate calendars in Outlook to cover Penquins & Steelers schedules. Yours imported perfectly. You saved me a lot of typing.
You’ve offered it for 6 years and I think I’ve downloaded it all 6! Can always count on you for my schedule.
Thanks man! You Rock!
Awesome – thanks!
Worked great in Google Calendar!
Thanks so much. That was perfect.
Thanks! I, too, can confirm it works great in Google calendar.
Can’t wait until Thursday night.
Thanks, this helps a ton. Go Steelers!
How do I change the “show time as” column to reflect Busy or Tentative. I tried typing in busy and tentative, but it has not worked. I am using Outlook 2007.
@Tree: I’ve updated the main article to answer your question. I hope this helps! 🙂
Greatly appreciate you putting this together. This is very helpful and I got a chance to learn a little about csv files.
Go Steelers!
all times are EST?
Well, all times are in the Eastern time zone. I think it changes from EDT to EST at some point during the season.
WOW! That was easy. Thanks for brining this together.
Keith
Hey Jim, thanks for your outlook downloads of the Steelers schedules. I beleive I have used for the past 2 years. The directions are always easy to follow & 100% correct!! Thanks again!! Will you be doing the 201–2011 schedule?
Chris
Hi Chris! Glad you’ve enjoyed the Steelers schedules in the past!
I’ve been working on my (in)famous recaps of the British show “Ashes to Ashes” this week, and haven’t had the time to put the new schedule together yet.
However, when I saw your comment today I checked online and saw that the pre-season games have not been finalized yet (opponents and dates have been determined, bit not exact times and TV coverage). I’ll keep an eye on this and update the schedule as soon as this is done!
(If I’ve missed something and there is a finalized 2010 schedule, please post a link!)
Thanks!
Jim
Jim,
I beleive the preseason schedule has been posted on the steelers website. You are the top dog doing this stuff. I download to my pda, my 2 son’s calendars & my wife’s pda. Thanks again!
Chris
Hey Chris!
I hope you downloaded the right schedule:
http://jimcofer.com/personal/?p=5794