How to update a sharepoint calendar from an Excel sheet

Question

_{Tuesday, June 28, 2011 12:56 AM}

Hello guys,

We have a Sharepoint calendar that needs to be update regularly.

At the moment everytime that we need to setup a meeting we manually go and add it as an event in the calendar but this is taking us too much time and we need to get this reduced.

Is there any way to get the Sharepoint calendar updated importing an excel file?, I can respect the sharepoint rules and upload the sheet manually if that what it needs to be done, once I get this done I can start thinking about getting the updates automatically from the sheet but first thing first.

Regards,

Leo

All replies (5)

_{Wednesday, June 29, 2011 8:55 AM ✅Answered}

In advanced settings, do you have "Allow items in this list to be edited using the datasheet?" set to "No"? If so, change to Yes and you should see an asterisk (*) in the last cell of the first row and should be able to add new rows (but be careful and use earlier rows as guidance - ex. time format).
AK

_{Tuesday, June 28, 2011 6:55 AM}

If you find it easier to enter items in Excel, you can use the worksheet view of the events list: change the view from Calendar to All Events, click List (from List Tools ribbon tab) and then click Datasheet View. You get an Access table like environment and you can use Excel functionality like auto fill, drag and fill and rows update once you go to next row. That should be a better approach but you still have to figure out conflicts (no access to free/busy).
AK

_{Tuesday, June 28, 2011 7:53 AM}

If you're going to use a spreadsheet, then you need to keep using it - there is no synchronization TO SharePoint from Excel.  Why is it taking too much time to enter events?  How is Excel faster?SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Wednesday, June 29, 2011 7:30 AM}

Ok, we have a spreadsheet that tell us how much quota we have available for 5 different sites, once the quota for each site gets full we manually go into the Sharepoint calendar to block that day for that specific site, setting up a whole day event saying "X SITE FULL"

This means that every day I have to setup up around 70 different events in the Sharepoint calendar to make sure that is updated and no one else try to book that day.

I was wondering if I can upload an excel file to the sharepoint as in some way I can use my existing spreadsheet to populate the available days by itself in another spreadsheet and get that uploaded to the actual Sharepoint Calendar.

Does this make any sense?

Thanks a lot for your help

_{Wednesday, June 29, 2011 7:56 AM}

Hi AK.

I was able to create a View as Datasheet but is only a different view, it does not let me type anything as I still have to go to "NEW" "NEW ITEM" to be able to create a new event.

Cheers,

Leo