Ramblings of a Luddite Geek: Add Moon Void of Course Dates to Google Calendar

Google calendar can be configured to show the phases of the moon. This view can be enabled in the settings. ^{1, 2} You can find other calendars in Settings, too, such as various religious holidays and sports.

But you can also create your own calendar and upload it as a ICAL file. Or you can import it as a CSV file. I used the import CSV method to add the dates and times that Moon is void of course.

What does it mean that Moon is void of course? In astrology, Moon visits each of the twelve signs of the Zodiac. As well, Her position may form Major Aspects with other celestial bodies. When Moon transitions from one house of the Zodiac to the next, and fails to be in a Major Aspect, She is considered void of course. It is believed to be a time to avoid important business, for example. ³ Thus, believers will want to have this on their calendars. Here's how to add these times to your Google calendar.

Locate a list of dates and times that Moon is Void of Course.
1. I used the list at voidofcoursemoon.com ⁴
Download or copy the data to a CSV text file.
Import the CSV into a new spreadsheet. I copied the data, so for me, the columns were tab-delimited. As well, I defined the first two columns as Date/Time and the last column as Text. Delete any lines that do not contain the desired data; I kept the first line as "Void begins: Void ends: Moon enters after void:."
Create a second sheet that will link to the content in the first sheet. You'll export this sheet as a CSV file in a format that Google calendar can read.
Add these nine column headings in row 1 of the "Export Sheet" ⁵
1. Subject
2. Start Date
3. Start Time
4. End Date
5. End Time
6. All Day Event
7. Description
8. Location
9. Private
Enter the following content into the cells of the second row:
1. Moon Void of Course (or whatever you'd like to see as the title of each event).
2. =$moon_void_of_course_table_2025.A2 (with format code MM/DD/YYYY)
3. =$moon_void_of_course_table_2025.A2 (with format code HH:MM:SS AM/PM)
4. =$moon_void_of_course_table_2025.B2 (with format code MM/DD/YYYY)
5. =$moon_void_of_course_table_2025.B2 (with format code HH:MM:SS AM/PM)
6. FALSE
7. ="Moon will enter " & $moon_void_of_course_table_2025.C2 & " after void" (or whatever you want to see in the event description).
8. Eastern US & Canada (This is the time zone name, but put whatever you want to see for the event location).
9. FALSE
10. Select all nine occupied cells in row 2 (columns A through I) and fill down until all the data of the first sheet is included.
Save the spreadsheet as XLSx (Excel) or ODS (LibreOffice Calc).
Export the new sheet as a CSV file.
Create a new Google calendar and import the CSV file into it. ⁵