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.
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.