Skip to main content

Torah reading spreadsheets

We’re pleased to provide downloadable files that contain the aliyah-by-aliyah breakdown of Torah readings for Shabbat, holidays and weekdays.

Leyning coordinators can download these Comma Separated Value (CSV) files and import into Microsoft Excel or some other spreadsheet program.

Download Leyning spreadsheets

The Full Kriyah CSV files contain Torah & Haftara readings for Shabbat, Rosh Chodesh, holidays and fast days.

The Weekday CSV files contain Torah readings for Mondays & Thursdays (and Shabbat mincha) when those days don’t co-occur with one of the events above. In other words, these files are intended to be mutually exclusive with the Full Kriyah Shabbat/holiday files.

Triennial CSV files are available for the Diaspora only, as the USCJ/RA has not published aliyah-by-aliyah tables that follow the Israeli sedra scheme.

Note that in September 2013, we replaced the large multi-year fullkriyah.csv file with separate files for each Hebrew year.

Example content:

DateParashahAliyahReadingVerses
25-Oct-2003Bereshit1Genesis 1:1 – 2:334
25-Oct-2003Bereshit2Genesis 2:4 – 2:1916
25-Oct-2003Bereshit3Genesis 2:20 – 3:2127
25-Oct-2003Bereshit4Genesis 3:22 – 4:1821
25-Oct-2003Bereshit5Genesis 4:19 – 4:224
25-Oct-2003Bereshit6Genesis 4:23 – 5:2428
25-Oct-2003Bereshit7Genesis 5:25 – 6:816
25-Oct-2003BereshitmafGenesis 6:5 – 6:84
25-Oct-2003BereshitHaftaraIsaiah 42:5 – 43:11
1-Nov-2003Noach1Genesis 6:9 – 6:2214
1-Nov-2003Noach2Genesis 7:1 – 7:1616
1-Nov-2003Noach3Genesis 7:17 – 8:1422
1-Nov-2003Noach4Genesis 8:15 – 9:715
1-Nov-2003Noach5Genesis 9:8 – 9:1710
1-Nov-2003Noach6Genesis 9:18 – 10:3244
1-Nov-2003Noach7Genesis 11:1 – 11:3232
1-Nov-2003NoachmafGenesis 11:29 – 11:324
1-Nov-2003NoachHaftaraIsaiah 54:1 – 55:5

Why are fixed fast days sometimes observed on a different day?

For example, Tzom Tammuz is always on the 17th of Tammuz, but in the year 5772 (2012 C.E.) it is on the 18th of Tammuz. The answer has to do with Shabbat:

“The Hebrew year contains several fast days that, though specified by particular Hebrew calendar dates, are shifted when those days occur on Saturday. The fast days are Tzom Gedaliah (Tishri 3), Tzom Tevet (Tevet 10), and Tishah be-Av (Av 9). When Purim is on Sunday, Ta’anit Esther occurs on the preceding Thursday… Each of the other fast days, as well as Shushan Purim (the day after Purim, celebrated in Jerusalem), is postponed to the following day (Sunday) when it occurs on Saturday.”

Reference: Calendrical Calculations, Edward M. Reingold, Nachum Dershowitz, Cambridge University Press, 2001, page 109.

Displaying Shabbat candle-lighting times on your website

Hebcal.com’s Add Shabbat Times to your Website tool lets you create custom HTML tags to which display weekly candle-lighting times directly on your web page. The result looks something like this:

Shabbat times for Chicago, IL

Candle lighting: 4:08pm on Friday, 02 January 2004
This week’s Torah portion is Parashat Vayigash
Havdalah (72 min): 5:39pm on Saturday, 03 January 2004

1-Click Shabbat Copyright © 2004 Michael J. Radwin. All rights reserved.