EXCEL PLANNER / CALENDAR - iCal or Google Calendar integration.

Wobzy

Board Regular
Joined
Mar 25, 2017
Messages
54
Hey Guys,

I've been working on a schedule / calendar.

I did some reading on integration with iCal and Google calendar.

Unfortunately everything I've come across is beyond my skillset and probably a few steps ahead of where I'm currently at.

Anyone have any input or resources as to a good starting point?

Thanks.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I've been working on a schedule / calendar...

Anyone have any input or resources as to a good starting point?

Wobzy,
I helped my daughter with a Google Calendar schedule update using Excel a few years ago.
It involved creating a list in Excel with the headings:

Subject_ Start Date_ Start Time_End Time_End Date

Then saving that list in a CSV (comma separated values) format in Excel. It turns out that you can import that CSV file directly into the specific Google Calendar or Calendars that you choose. You just need to write down/save the complete filepath and filename of the CSV file so you can enter it in the window that opens in Google Calendar when you select 'Other Calendars>Import Calendar'. There is a note on that window:

"Choose the file that contains your events. Google Calendar can import event information in iCal or CSV (MS Outlook) format. LEARN MORE"

Just enter the complete path and filename you saved/jotted down, then hit 'IMPORT'....that's it.

The following Google note is very important:

" Choose the calendar where these events should be saved."

If you don't deselect some calendars the events will be entered into ALL of your Google calendars...so just be aware.

This method saves a lot of time over manually entering each event separately into Google Calendar.
I hope this information is helpful.
Perpa
 
Upvote 0

Forum statistics

Threads
1,223,793
Messages
6,174,635
Members
452,575
Latest member
Fstick546

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top