The NFL released the official 2013-14 schedule today, and what can I say… for the 10th (11th?) straight year, I’ve got your Pittsburgh Steelers schedule for Outlook ready to go!
I have made a few changes since last year’s schedule:
For one thing, I marked the end times of 13:00 games at 16:25 instead of 16:15, in keeping with the NFL’s new broadcasting policy.
I also no longer mark flex games in the schedule. I figure that if you’re excited enough about football to want to add games to your Outlook calendar, then you probably already know how flex scheduling works. If not, read this.
Lastly, while I still have four versions of the schedule – one CSV format with the Steelers schedule only; one CSV format with the Steelers schedule and the NFL playoffs, and ICS versions of both – I decided to put all files in the same zip package. So please be sure to choose wisely when it’s time to import the calendar. File names are as follows: steelers_2013.csv (or .ics) is the Steelers schedule only; steelers_nfl_2013.csv (or .ics) is the Steelers schedule and NFL playoffs.
The CSV version of the schedule is compatible with Microsoft Outlook 98 or later. It might also work with any calendar app that can import from CSV files; it has only been tested with Outlook 2010, however.
The iCal version of the schedule is for Google Calendar and iTunes\iPhone. It 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!
Either 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.
* * *
For complete instructions, click the “Continue Reading” link below!
Instructions for Outlook users:
- Download the zip 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 and later: 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 18, 2013 on a computer running Windows 7 Ultimate x64 and Microsoft Office 2010. They were scanned with Microsoft Security Essentials 126.96.36.199 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.