HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to import Excel into Google Calendar by Chris Menard

137,143 views November 4, 2018 7:15

Watch on YouTube
ChannelChris Menard

Description 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!

About this tutorial

Chris Menard published this 7:15 video tutorial on November 4, 2018. It has been watched 137,143 times on YouTube.

Duration
7:15
Published
November 4, 2018
Views
137,143
Likes
1,011

Tags

Share

This tutorial in other languages