Import into Microsoft Outlook

This option imports all the SEC Calendar and Lectionary dates into your existing Outlook or Exchange Calendar. This will increase the size of your calendar file.

Note These instructions are specifically for Microsoft Outlook 2010; there may be slight variations when importing into Outlook 2003, 2007, 2013 or 2016.

Watch how to do it

This video shows you how to import a file into Outlook 2010. Note, however, that the website design shown on the video is out-of-date, but once you've downloaded the file the procedure is exactly as shown on the video.

Step-by-step walkthrough

1. Download the .CSV file

Download the comma separated values (.csv) file (or the iCalendar feed file, if you prefer).

You'll find the download links on the homepage or on the right.

You'll find the download links below, or on the homepage.

Screenshot of homepage subscribe and download buttons.

2. Backup your Outlook data Optional

You may wish to back-up your Outlook Data File (.pst) before you import.

You can find out more here:

If you use Microsoft Exchange (which stores your offline data in a .ost file) you may wish to export your Outlook calendar to an Outlook Data File (.pst) as a backup.

Screenshot of Microsoft Support website.

3. File > Open > Import

Open Microsoft Office Outlook 2010 and from the File tab on the ribbon select Open and then Import.

Import files, settings, and RSS Feeds into Outlook.

4. Import and export wizard

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

Import data from other programs or files, including ACT!, Lotus Organizer, Outlook data files (.PST), database files, text files and others.

5. Comma Separated Values (Windows)

Select Comma Separated Values (Windows). Then click Next >.

Import a file dialog.

6. Select a file to import

Browse to the .CSV file that you downloaded in step 1.

Select an option depending on how you want to handle duplicate entries:

  • Replace duplicates with items imported
  • Allow duplicates to be created
  • Do not import duplicate items

I always select "Do not import duplicate items".

Click Next >.

File to import but do not import duplicate items.

7. Select destination folder

Select the destination folder within Outlook.

This is usually "Calendar", but in this example I have created a new calendar sub-folder called "SEC Complete 2010-2011" for testing purposes.

Click Next >.

Select destination folder.

8. Finish

Before Outlook imports the file a final confirmation dialog allows you to make last-minute changes or cancel the action all-together.

There is no need to change the "Map Custom Fields..." options as I have made sure that these are correct (see below).

Click Finish.

Confirmation.

The "Map Custom Fields..." options are already correct:

Map custom fields.

9. Import progress

Outlook will begin the import.

This may take a few seconds or a few minutes, depending on the speed of your computer.

Import progress.

10. Done

Switch to the calendar view...

Calendar view.

...to see the imported data in your Outlook calendar.

Calendar with imported data.

Import into Google Calendar

This option imports all the SEC Calendar and Lectionary dates into either an existing or a new Google Calendar.

1. Download the .CSV file

Download the comma separated values (.csv) file (or the iCalendar feed file, if you prefer).

You'll find the download links on the homepage or on the right.

You'll find the download links below, or on the homepage.

Screenshot of homepage subscribe and download buttons

2. My calendars > Create new calendar Optional

I strongly advise that you create a new calendar for your SEC calendar to keep your data separate (and colour-coded). If you want to import it into an existing calendar jump to step 4.

Log in to your Google Calendar account.

On the left-hand side, beneath the monthly calendar you'll see a list of your calendars.

Click on the down-arrow to the right of "My calendars" and from the fly-out menu select "Create new calendar".

My calendars... create new calendar.

Enter details for your new calendar:

  • Calendar name
  • Description
  • Location
  • Time Zone
  • Make this calendar public (if you want to share it with others)

Click "Create Calendar" when you are done.

Calendar details screen in Google Calendar.

3. Other calendars > Add > Import calendar

Beneath your list of calendars is another list entitled "Other calendars".

Click on the down-arrow to the right of "Other calendars".

From the fly-out menu select "Import calendar".

Other calendars fly-out menu.

4. Import calendar

Choose the file that you downloaded in step 1 above.

Select the calendar you'd like to import this information into.

Click on Import.

Import calendar dialog: select a file, select the calendar, click Import.

5. Successfully imported

It may take a few minutes to import all the data, depending on your internet connection speed and the size of the .CSV file.

A confirmation dialog will inform whether the import was successful or not.

Processed 364 events. Successfully imported 364 events.

6. Calendar

You'll now see your new calendar is populated with the imported data.

View of calendar with new SEC Calendar data.

7. Calendar details

Click on an entry in the calendar to view more details:

  • Scottish Episcopal Church calendar details
  • Liturgical colour
  • Daily Eucharist readings
  • Daily Prayer readings

Calendar event details.

Subscribe with Microsoft Outlook

This option allows you to subscribe to the iCalendar feed of the SEC Calendar and Lectionary using Microsoft Outlook 2010. This allows you to view the calendar data alongside your existing calendar(s).

Note These instructions are specifically for Microsoft Outlook 2010; there may be slight variations when importing into Outlook 2003, 2007 or 2013.

Watch how to do it

This video shows you how to subscribe to an iCalendar feed in Outlook 2010. Note, however, that the website design shown on the video is out-of-date, but once you've downloaded the file the procedure is exactly as shown on the video.

Step-by-step walkthrough

1. Copy iCalendar feed address

Select whichever iCalendar feed you want. There are two on offer:

  1. Perpetual—this contains every calendar I've created and gets updated every year, meaning that you don't need to re-subscribe to a new calendar each year: just refresh this one and the new entries should be updated.
  2. Yearly—for those who share calendars or don't want access to previous years' data, you can subscribe to the yearly feeds.

Right-click the appropriate link and copy the link address.

Screenshot of homepage subscribe and download buttons.

2. Add calendar... from internet

Select the Calendar view in Outlook 2010.

Right-click "Other Calendars" and select Add Calendar > From Internet...

Add calendar fly-out menu showing From Internet option.

3. Paste the link address

Paste the link that you copied in step 1, then click OK.

New Internet Calendar Subscription dialog box.

4. Add this Internet Calendar to Outlook and subscribe to updates

A dialog box will appear asking you to confirm whether you would like to "add this Internet Calendar to Outlook and subscribe to updates".

Click Yes.

The Advanced... option allows you to rename the calendar and its description from the defaults set by me.

Add this Internet Calendar to Outlook and subscribe to updates?

5. Done

Switch to the Calendar view...

You will see that the new calendar is now listed under "Other Calendars".

Hover your mouse pointer over the calendar name to reveal the URL and when it was last updated.

Information about how often the calendar is updated can be found under File > Options > Advanced > Send/Receive... > Edit > Internet Calendars.

Other calendars now shows your new calendar subscription.

Subscribe with Google Calendar

This option allows you to subscribe to the iCalendar feed of the SEC Calendar and Lectionary using Google Calendar. This allows you to view the calendar data alongside your existing calendar(s).

1. Copy iCalendar feed address

Select whichever iCalendar feed you want. There are two on offer:

  1. Perpetual—this contains every calendar I've created and gets updated every year, meaning that you don't need to re-subscribe to a new calendar each year: just refresh this one and the new entries should be updated.
  2. Yearly—for those who share calendars or don't want access to previous years' data, you can subscribe to the yearly feeds.

Right-click the appropriate link and copy the link address.

Screenshot of homepage subscribe and download buttons.

2. Other calendars > Add calendar by URL

On the left-hand side of your calendar you will see a heading "Other calendars".

Click on the down-arrow to the right of this heading.

Select "Add by URL".

Other calendars fly-out menu shows option for Add by URL.

3. Add by URL

In the dialog, paste the link to the iCalendar feed you selected in step 1.

Decide whether to make your calendar publically accessible or not (useful if you are embedding your calendar on a website, for example).

Click "Add Calendar" when finished.

Add by URL dialog. If you know the address to a calendar (in ical format), you can type the address here.

4. Subscribed

You are now subscribed to this calendar.

Newly subscribed calendar is now listed under Other calendars.