Skip to main content

CSV Jewish holiday download for older versions of Microsoft Outlook

Follow these instructions to add a Hebcal Jewish holiday calendar to older versions of Microsoft Outlook. This article applies to Outlook 97, 98, 2000, 2002, 2003 for Windows.

First, you’ll need to download an Outlook CSV (Comma-separated values) file from hebcal.com:

1. Open a web browser on your Microsoft Windows computer.

2. Fill out the form with your preferences and click the Create Calendar button

3. Click the Download… button

4. Select the CSV option from the Download dialog box

5. In the dialog box, select one of the two Download buttons – either Outlook CSV – USA date format (month/day/year) or Outlook CSV – European date format (day/month/year) (depending on whether you want USA or European date formats).

6. When prompted, specify a convenient name and location for the hebcal_DATE_LOCATION.csv file in the “Save As” dialogue box. We recommend saving the file on the Desktop

Next, import that file into Outlook:

  1. Open Microsoft Outlook
  2. Select the File -> Import and Export… menu option
  3. Select “Import from another program or file” and click Next
  4. Select “Comma Separated Values (Windows)” and click Next
  5. Find the hebcal_DATE_LOCATION.csv file you downloaded and select “Do not import duplicate items” and click Next
  6. Select Calendar and click Next. This will import your chosen file

Included in the Hebcal Jewish holiday downloads are options to select major holidays (Rosh Hashana, Yom Kippur, Pesach, etc.), minor holidays (Purim, Chanukah, etc.), special Shabbatot, public fasts (Tish’a B’Av, etc.), Rosh Chodesh, and modern holidays (Yom HaAtzma’ut, etc.).

Outlook for Mac 2011 Jewish holidays download

This page includes instructions on how to subscribe to a Hebcal Jewish holiday calendar 5-year feed in Microsoft Outlook for Mac 2011. This version of Outlook on macOS did not support iCalendar subscriptions and cloud sync, so it requires downloading a copy of events from Hebcal.com and manually managing them on your desktop.

Update: these are no longer the recommended instructions for modern versions of Microsoft Outlook on Mac. If you use Outlook 2016 for Mac or later, Microsoft now recommends that you sync your account to the Microsoft Cloud. “Available for Google accounts in Mail and Calendar, and Google, Yahoo, iCloud, and IMAP accounts in Outlook for Mac, this allows you to enjoy many of the best features of Mail and Calendar and Outlook for Mac.”

Follow these instructions for Outlook 2011 Mac:

  1. Open a web browser on your macOS computer.
  2. Fill out the form with your preferences and click the Create Calendar button
  3. Click the Download… button
  4. Select the Outlook Mac option from the Download dialog box
  5. Click on the Jewish Calendar YYYY.ics download button
Jewish_Calendar_2017_Providence___Hebcal_Jewish_Calendar 478px

Next, find the downloaded .ics file (typically in your Downloads or Desktop folder). To get the Jewish holidays to show up with a color-coded category, be sure to drag and drop the .ics file you downloaded onto one of the category labels on the left pane as follows:

Screen shot of adding a hebcal.ics file to Outlook 2011 for macOS

If you simply drag the .ics file to Outlook 2011 icon in your dock or double-click on it, it will get categorized and color-coded as “No Category” which is probably not what you want.

Outlook.com & Windows 10 Jewish Calendar download

Follow these instructions to add a Hebcal Jewish holiday calendar 5-year feed to Outlook.com (also called outlook.live.com Calendar). This technique will also work with Windows 10 devices (desktops, laptops, tablets and phones) that have a built-in calendar application that connects to Outlook.com or MSN.

  1. Go to https://www.hebcal.com/hebcal if you’re downloading a holiday calendar, or https://www.hebcal.com/yahrzeit if you’re downloading a Yahrzeit + Anniversary calendar.
  2. Fill out the form with your preferences and click the Create Calendar button
  3. Click the Download… button
  4. Select the iCalendar option from the Download dialog box, and then click on the Copy button
    iCalendar feed dialog box
  5. Sign in to Outlook.com
  6. At the bottom of the page, select Calendar
  7. In the navigation pane, select Add calendar
  8. Select Subscribe from web.
    Subscribe to a calendar
  9. Enter the URL for the calendar
  10. Select Import

Included in the Hebcal Jewish holiday downloads are options to select major holidays (Rosh Hashana, Yom Kippur, Pesach, etc.), minor holidays (Purim, Chanukah, etc.), special Shabbatot, public fasts (Tish’a B’Av, etc.), Rosh Chodesh, and modern holidays (Yom HaAtzma’ut, etc.).

Outlook for Mac 2011 – remove Hebcal Jewish calendar

To delete Hebcal events from Microsoft Outlook for Mac 2011, follow these steps.

1. First, open your Calendar within Outlook

2. Next, search for “hebcal” in the search box on the upper right

Searching_Events__Selected_Categories_

3. Click on one of the search results, then select all of the entries in the list via EditSelect All

Searching_Events__Selected_Categories__1

4. Delete the entries via EditDelete

Microsoft Outlook CSV – delete Hebcal Jewish calendar from Outlook 97, 98, 2000, 2002, 2003

When hebcal exports to CSV format, it puts the text “Jewish Holidays” in the Location field. That is there to make it easy to remove entries from your calendar if you got the wrong settings. For example, if you were using candle-lighting times but entered the wrong zip code, you could follow these instructions to remove all of the incorrect entries:

  1. Open your Calendar and on the View menu point to Current View and click Events
  2. Click the Location column heading to sort the list of holidays by Location (you should see “Jewish Holidays” in the location field for the holidays that you imported from CSV)
  3. Click to select the first holiday you want to delete
  4. Hold down SHIFT and click the last holiday you want to delete
  5. Press DELETE to remove all the selected holidays from your Calendar

To delete candle-lighting times, use these instructions:

  1. Open your Calendar and on the View menu point to Current View and click Active Appointments
  2. Do steps 2-5 above