I have a new calendar that currently has no events on it. There is a calendar on one of my other sharepoint sites that I'd like to copy all the events in it over to this new one. I've exported all the calendar data to an excel file (saved as a .iqy), but I don't see any way to import the data. I read you have to simply click the 'import' button, but I can't seem to find it anywhere.
1 Answer
SharePoint doesn’t offer a command or a tool that allows users to bulk add events into a calendar; but by using Office apps (Excel and Access) we can do that very easily.
Kindly check the below mentioned article for your reference. It will work same in SharePoint 2016.
SharePoint: How to Add Events into a Calendar Using Microsoft Excel and Access
-
This worked. Thank you! But I tried to color code them by adding new "calendars in view", but it couldn't resolve the web URL...– Luke KCommented Jun 14, 2016 at 15:49
-
You can create it by your own, in new site where you have moved your calendar.– HardikCommented Jun 14, 2016 at 15:51
-
-
-
This link is dead. Please, in future, put the relevant info within the answer and not just a link.– ianCommented May 13, 2020 at 8:08