Generate files in iCalendar format in Excel 1

The file of iCalendar format
(hereinafter referred to as iCal format)
Can be output by schedule application
such as Google Calendar.
It contains the data of the schedule.

With this file type
You can exchange schedules
among schedule applications.

I want to generate iCal format files by Excel.
What is iCal format?
I'm gonna start from the point.

This time I will examine the data contents of iCal format.

Input events in Google Calendar, then
We can export the schedule in iCal format from Google Calendar.
I'll check at the contents of the file I have exported.

With Google Calendar
To export all schedules
Please select in following order.
"Settings" - "Import / Export" - "Export"

When exporting schedules only for a specific calendar
After clicking "Setting"
Select a item of my calendar you want to output
and click "Export Calendar".
For details, please see the following page
"Export your Google calendar"

The output file is in iCal format.
The extension is ".ics".
If you modify this extension to ".txt"
You can see and edit the contents in Windows Notepad.

Compare the Google Calendar input screen
to the output file.
in the image below.
Leave data only for frequently used parts,
others have been deleted.

BEGIN:VCALENDAR
…
END:VCALENDAR

This part is an essential part of iCal format.

BEGIN:VEVENT
…
END:VEVENT

This part is the schedule.
Each item of the schedule
is specified in the form of "item: value".

In case of ①,
the item is SUMMARY and the value is MEETING.
So it is specified as following,

SUMMARY: MEETING

Please compare ① ~ ⑤
for checking items of schedule.
② and ③ are items of start Date-Time
and end Date-Time.

It is written in UTC time.
(The last letter of the alphabet "Z" indicates UTC time.)

For example,
② represents the next Date-Time.
20181127 T 010000 Z = November 27, 2018 01: 00: 00 (UTC)

Japan time is UTC + 9.
When importing to the calendar application
set to Japan Standard Time,
it will be converted to the following Date-Time.
November 27, 2018 10: 00: 00

I would like to introduce
how to specify a Date-Time in another article.