Importing from Excel to a Calendar

Question

My team needs to bulk upload events from multiple people into a SharePoint calendar. Is there a way to do this from excel?

Answer 1

Hi DeniseKillian,

From your post, I understand that you want to import events from Excel to SharePoint Calendar. For this, please follow the steps below:

1. Open a browser and navigate to your SharePoint site and open the calendar.
2. In calendar, click Calendar tab in Manage views, click the drop-down and select All Events.

     3. Clickedit to open Quick Edit mode.

    4. Open Excel workbook which contains the events you want to import. Select the data in Excel and press Ctrl + C to copy. Note: The cells you want to copy must match the data type in the view of the list in browser.

    5. Go to browser, in Quick Edit mode in the list. Important Tip*: Navigate to the first cell of Title to add items. However, DO NOT click into the cell; pasting at that point will not work properly. If there is already an event in the list, use the keyboard navigation keys to go to the bottom (empty) item.  Press Ctrl + V to paste the events.*

    6. Once done, click Stop to save changes.

Let me know if you need help. Have a nice day and stay safe.

Regards,

Neha

Answer 2

Thank you for providing these instructions. We followed them exactly multiple times and it is not working. All of the information doesn't paste in the cells on SharePoint and we keep getting an error message. Please advise on how we should move forward with this.

Answer 3

Hi Denise,

I created a small GIF for your reference, this might help you. Please check this and try again, see if this works.

If you still get the issue, please confirm the following information:

1. May I know if you are using SharePoint online or on-Premises?
2. Can I please get a screenshot of the error?
3. Which browser you are using?

Thanks,

Neha

Answer 4

1. SharePoint Online
2. See above
3. Chrome, but I've tried it with Edge and that doesn't work either.

Answer 5

Not sure why copy/paste is being recommended  - it's never worked properly. If you don't have access to a migration tool like Sharegate (not made by Msft so actually works as expected), you could connect an Access database to a SP calendar list and import the excel file into the db. The contents will sync up after connecting.