Create Google Calendar™ events in bulk from sheet rows, and import or export a calendar to a sheet. Rerun it: events update, no duplicates. All-day or timed, guests, colors. 50 events a day free.
EventFill is an add-on for Google Sheets™ that turns the rows of a sheet into Google Calendar™
events, and a calendar’s events into a sheet.
Sheet to Calendar: pick the title and date columns (and, if you have them, start and end
times, end dates, description, location, guests and color), pick one of your calendars, click
once. A date alone makes an all-day event; a date and a time, a timed one.
No duplicates: each row gets a linked Calendar event cell. Edit the sheet and run again:
the changed rows update their events, the unchanged ones are left alone.
Calendar to Sheet: any calendar you can see, between two days, into a new sheet with each
event’s times and hours, ready to edit and send back.
The right time: times are read in the spreadsheet’s time zone (File > Settings), across
daylight-saving changes.
Narrow access: EventFill only reaches the spreadsheet you use it in and the events of your
calendars; it can list your calendars but not change their settings or sharing.
Plans
Free: 50 events a day, either way, every day.
EventFill Pro: as many as you like. $4.99 a month or $39 a year, with a 7-day free trial.
Cancel any time from the sidebar.