Saints and Festivals of the Scottish Episcopal Church for MS Outlook

Screenshot of Outlook Calendar showing saints\' days
Screenshot of Outlook showing saints’ days and festivals imported into the Calendar.

Better late than never! I’ve finally got around to typing up the Scottish Episcopal Church saints’ days and festivals in a format that can easily be imported into the Microsoft Office Outlook Calendar.

Please feel free to download this file and follow the simple, illustrated instructions on how to import it into Microsoft Office Outlook.


(Right-click and select Save Link As….)

  • Saints’ Days and Festivals of the Scottish Episcopal Church Calendar, from Advent 2005 to The Last Sunday in Pentecost (Christ the King) 2006 (CSV, 23 KB)

Please note:

  1. Back-up: Make sure you back-up your Outlook .PST file before you import. (I recommend that you use the Personal Folders Backup application which works for Outlook 2000, Outlook 2002 XP and 2003.)
  2. Illustrations: All illustrations show Microsoft Office Outlook 2003; details may vary slightly for older copies of Outlook. This does not work for Microsoft Outlook Express, which is an email application and does not offer calendar functions.
  3. Accuracy: Details are as far as possible correct, although a few errors may have crept in in the production of this file (for example in how translated (moved) minor festivals have been scheduled). It was produced for my own personal use, but I’ve also decided to release it into the public domain. Feel free to use and/or adapt it to your own use. The file can be edited in Microsoft Office Excel (or other spreadsheet, eg
  4. Dates only: This file does not contain details of the readings for each day, only the name of the festival.
  5. Enjoy!

1. File > Import and Export …

Screenshot from Outlook 2003 of File, Import and Export

Open Microsoft Outlook, and from the File menu select Import and Export…

2. Import and Export Wizard

Import and Export Wizard

The Import and Export Wizard window will open. Select Import from another program or file, then click Next >.

3. Select Comma Separated Values (Windows)

Comma Separated Values (Windows) is selected=

Select Comma Separated Values (Windows) from the list, and click Next >.

4. Locate the CSV file to import

Import a File window

You will now be prompted to Import a File. Click the Browse … button and locate the file you downloaded called ChurchDates2006.csv, once selected click Next >.

5. Select Calendar under your Personal Folders

Select destination folder

Now select the destination folder from those listed under your Outlook Personal Folders. You want to select Calendar, and then click Next >.

6. Confirm and click Finish

Confirmation screen

You will be presented with a confirmation screen, similar to the one above. Make sure that the details are correct — and if you need to, check that the Map Custom Fields… settings are correct (by default, they should be). Click Finish to begin importing the details into your Outlook Calendar.

7. Import is in progress

Import and Export Progress bar

Outlook will begin to import the information into your Outlook Calendar, showing you its progress (as above).

8. It’s done

Screenshot of Outlook Calendar showing saints\' days

Once complete, you’ll find that details of all the Scottish Episcopal Church saints’ days, festivals and Sundays, from Advent 2005 – The Last Sunday of Pentecost (Chrirst the King) 2006, have been added as all-day events to Outlook.

Published by

Gareth Saunders

I’m Gareth J M Saunders, 52 years old, 6′ 4″, father of 3 boys (including twins). Enneagram type FOUR and introvert (INFP), I am a non-stipendiary priest in the Scottish Episcopal Church, I sing with the NYCGB alumni choir, play guitar, play mahjong, write, draw and laugh… Scrum master at Safeguard Global; latterly at Sky and Vision/Cegedim. Former web architect and agile project manager at the University of St Andrews and previously warden at Agnes Blackadder Hall.

4 thoughts on “Saints and Festivals of the Scottish Episcopal Church for MS Outlook”

  1. How brilliant is this? It must have taken you ages. Well done and thank you!

    I’ll carry the Calendar on my PDA now (surely, some kind of miracle!)

  2. Hey Gareth, this is so much an excellent thing.

    Thank you so very much for the huge amount of work that has gone into this.

    Now, like GadgetVicar I can have it on my PDA, PC and also my phone!

    Life doesn’t get much better than this…and other sycophantic ravings

    You’re simply the best.

  3. It took me about an afternoon to do it — maybe 5 hours, max. It was so much easier having done it last year, I just had a few entries to change, a couple to add, and a few bits of translation-juggling.

    Last year it took me the best part of a whole week to type up.

    I’m sure there will be some mistakes, but if you’re happy to live with those and correct them yourselves then great. If you DO find any then feel free to let me know and I’ll update the original file for others.

    I’d really like to add the readings for Sundays, and if possible the weekday Eucharists too. But that will involve an awful lot more typing … maybe just the Sundays to start with.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.