Import Excel into a Google Calendar

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 is a Microsoft Office Master Instructor. He trains corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and the University of Georgia. When he's not training, he blogs about technology and creates training videos on YouTube. Currently, there are over 400 technology videos available on his YouTube Channel.

Categories