The NFL released the official 2011-12 schedule today, and this year I was ON IT! The new Steelers schedule is ready to go in record time! Let’s hope the lockout ends soon so that the schedule doesn’t have to be altered any, eh?
I have something new to offer this year: the download is available in the traditional CSV format (used by Microsoft Outlook and Yahoo! Calendar) as well as the iCalendar format (used by Google Calendar, iPhone, and iCal). So be sure to choose the correct version when you download!
The CSV version of the schedule is compatible with Microsoft Outlook 98 or later. It might also work with Google Calendar or any other calendar app that can import calendar events from CSV files. However, it has only been tested with Outlook 2010.
The iCal version of the schedule has not been tested at all. I used this handy online tool to convert the CSV to iCal format, so if there are any problems with the iCal version, please take it up with the webmaster there! 🙂 I did, however, open the iCal file in Outlook and it appears to be correct.
Both schedules contain 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 are free to 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 2011-12 schedule only, the 2011-12 Steelers schedule with the NFL playoffs and Super Bowl XLVI, and a calendar with the playoffs and Super Bowl XLVI only.
Pick your poison by clicking the appropriate link below:
CSV (OUTLOOK FORMAT):
ICAL (GOOGLE\IPHONE FORMAT):
* * *
Outlook users may follow these simple instructions to import the schedule. Make sure to read the all the directions below before you begin:
- Download the appropriate file to your desktop and unzip.
- OUTLOOK 2007 and earlier: Open Outlook and select “File” > “Import and Export” > “Import from another program or file”, then click “Next”.
OUTLOOK 2010: Open Outlook and select “File” > “Open” > “Import” > “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: These files were tested on April 19, 2011 on a computer running Windows 7 Ultimate x64 and Microsoft Office 2010. It was scanned with Microsoft Security Essentials 2.0.657.0 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.