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.

  • Please specify your SharePoint tenants.
    – Hardik
    Jun 14, 2016 at 15:11
  • Sorry, I'm using Sharepoint 2016.
    – Luke K
    Jun 14, 2016 at 15:12
  • Did you get it working?
    – Hardik
    Jun 14, 2016 at 15:37

1 Answer 1


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 K
    Jun 14, 2016 at 15:49
  • You can create it by your own, in new site where you have moved your calendar.
    – Hardik
    Jun 14, 2016 at 15:51
  • Create what on my own?
    – Luke K
    Jun 14, 2016 at 15:56
  • Color coded views of calendar
    – Hardik
    Jun 14, 2016 at 15:58
  • This link is dead. Please, in future, put the relevant info within the answer and not just a link.
    – ian
    May 13, 2020 at 8:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.