Saturday 23 December 2017

CSV format for Google Calendar

CSV format for Google Calendar contains the following elements:

-- Subject: title of your event or activity.
-- Start Date: the starting date of the event or activity.
-- Start Time: the starting time of the event or activity.
-- End Date: the ending date of the event or activity.
-- End Time: the ending time of the event or activity.
-- All Day Event: TRUE if an all-day event, else FALSE.
-- Description: the description of the event or activity.
-- Location: the location of the event or activity.
-- Private: TRUE if it is not seen in shared calendars, else FALSE.
Here is an example:

Subject Start Date Start Time End Date End Time All Day Event Description Location Private
JCI Shatin AGM 8/25/18 14:00:00 8/25/18 22:00 FALSE N/A Starry Terrace, 21/F, 8 Observatory Road FALSE
JCI Tsuen Wan AGM 8/25/18 17:30:00 8/25/18 22:00 FALSE N/A Hilton Garden Inn, 2 Soy St, Mong Kok FALSE
JCI Island AGM 8/26/18 11:00:00 8/26/18 22:00 FALSE N/A 3/F, Regal Kowloon Hotel, 71 Mody Rd, Tsim Sha Tsui East FALSE
JCI Ocean AGM 8/26/18 14:30:00 8/26/18 22:00 FALSE N/A Lafayette, 2/F, Jade Mansion, 40 Waterloo Rd, Yau Ma Tei FALSE
JCI City Lady AGM 8/26/18 17:00:00 8/26/18 22:00 FALSE N/A Hilton Garden Inn, 2 Soy St, Mong Kok FALSE

No comments:

Post a Comment