I want to add all the entries in an excel file on to my SharePoint Calendar through a workflow or any other method. How do I achieve this ?
You can use use Access instead of Excel, then sync the calendar data with Access file.
Here are the detail steps:
Go to your calendar, then click Actions > Open with Access. Click OK on popup window, the Microsoft Access open.
Click Publish to SharePoint Site besides Publish Changes, and then select a document library to store the “.accdb” file, click Publish. Or save it to your local computer.
Edit the Access file we created in step2, save the file, then all changes will update to calendar list automatically.
We can Import data from Excel to the Access file by right clicking the calendar table in Access > select Import from Excel