Playback starts YouTube’s embedded player (privacy-enhanced mode).
How to import Excel into Google Calendar by Chris Menard
ChannelChris MenardDescription from the creator
You can import events/appointments into Google Calendar from Microsoft Excel. The first step is to save your Excel file as a CSV file. That is an Export.
You can then import the CSV file to Google Calendar.
************
Download the CSV file I used in the video from here:
drive.google.com/open?id=1W2K6WLb4qJW5Y2kO0rCWE…
************
For more specific instructions, see my blog post at
important: The headers must be in English as shown below. If any event details have commas (like the location example below), you can include them by using quotation marks around the text.
Subject
The name of the event, required.
Example: Final exam
Start Date
The first day of the event, required.
Example: 05/30/2020
Start Time
The time the event begins.
Example: 10:00 AM
End Date
The last day of the event.
Example: 05/30/2020
End Time
The time the event ends.
Example: 1:00 PM
All Day Event
Whether the event is an all-day event. Enter True if it is an all-day event, and False if it isn't.
Example: False
Description
Description or notes about the event.
Example: 50 multiple choice questions and two essay questions
Location
The location for the event.
Example: "Columbia, Schermerhorn 614"
Private
Whether the event should be marked private. Enter True if the event is private, and False if it isn't.
Example: True
Chris Menard's Training Website and Blog
chrismenardtraining.com
Excel - Free class on Excel Tables by Chris Menard
chrismenardtraining.teachable.com/p/excel-tables
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
You can then import the CSV file to Google Calendar.
************
Download the CSV file I used in the video from here:
drive.google.com/open?id=1W2K6WLb4qJW5Y2kO0rCWE…
************
For more specific instructions, see my blog post at
important: The headers must be in English as shown below. If any event details have commas (like the location example below), you can include them by using quotation marks around the text.
Subject
The name of the event, required.
Example: Final exam
Start Date
The first day of the event, required.
Example: 05/30/2020
Start Time
The time the event begins.
Example: 10:00 AM
End Date
The last day of the event.
Example: 05/30/2020
End Time
The time the event ends.
Example: 1:00 PM
All Day Event
Whether the event is an all-day event. Enter True if it is an all-day event, and False if it isn't.
Example: False
Description
Description or notes about the event.
Example: 50 multiple choice questions and two essay questions
Location
The location for the event.
Example: "Columbia, Schermerhorn 614"
Private
Whether the event should be marked private. Enter True if the event is private, and False if it isn't.
Example: True
Chris Menard's Training Website and Blog
chrismenardtraining.com
Excel - Free class on Excel Tables by Chris Menard
chrismenardtraining.teachable.com/p/excel-tables
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
About this tutorial
Chris Menard published this 7:15 video tutorial on November 4, 2018. It has been watched 137,143 times on YouTube.
- Channel
- Chris Menard
- Category
- Howto & Style
- Duration
- 7:15
- Published
- November 4, 2018
- Views
- 137,143
- Likes
- 1,011
Tags
Share
This tutorial in other languages
- FRComment importer Excel dans Google Agenda par Chris Menard
- ESCómo importar Excel a Google Calendar por Chris Menard
- PTComo importar Excel no Google Calendar por Chris Menard
- ITCome importare Excel in Google Calendar da Chris Menard
- DEWie Excel in Google Kalender von Chris Menard importieren
- NLHoe kan ik Excel importeren in Google Agenda door Chris Menard
- RUКак импортировать Excel в Календаре Google Крис Менар
- PLJak importować Excel do Kalendarza Google Chris Menard
- JAクリス・メナードでGoogleカレンダーにExcelをインポートする方法
- ARكيفية استيراد Excel إلى تقويم Google من قبل كريس مينار
- HIक्रिस मेनार्ड द्वारा Google कैलेंडर में एक्सेल आयात करने के लिए कैसे
- IDBagaimana mengimpor Excel ke Google Calendar oleh Chris Menard