Import Excel into a Google Calendar

Posted on:  11/04/2018
Import Excel into a Google Calendar

Import events to Google Calendar

You can transfer your events in Microsoft Excel to a Google Calendar. This will save you the time of retyping all the events.

Steps to save Excel as a CSV (Export)

Prior to saving an Excel file as a CSV, make certain you only have one worksheet in the Excel file. 

  1. In Excel, go to File > Save As.
  2. The Save As dialog box appears.
  3. Make the Save as type CSV.
  4. Browse to the location where you want to save the CSV file.
  5. Click OK. 
  6. Click Yes.

Export Excel to CSV

Steps to Import CSV into a Google Calendar

  1. Open Google Calendar.
  2. Point to the calendar you want to import data. 
  3. Click the three vertical dots.
  4. Click Setting and sharing.
  5. Click Import & export.
  6. Click Import.
     
  7. Select the CSV file from your computer.
  8. Choose which calendar you will add the imported fields.
  9. Click Import.

YouTube Video

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories