skip to Main Content

SharePoint doesn’t offer a command or a tool that allows user to bulk add events into a calendar.
But, by using Office apps (Excel and Access) we can do that very easily.

What are the steps ?

  • create a real or a dummy event;

How to add events into Calendar using Microsoft Excel and Access ?

  •  now we will export a Excel Web Query, because we don’t know what columns to add to our workbook, or how the values must be entered – click on the Export to Excel command;

How to add events into Calendar using Microsoft Excel and Access ?

  •  now we have to fill the desired fields – Start Time, End Time, Title and Location.

How to add events into Calendar using Microsoft Excel and Access ?

  • after we create the events in Excel, we must open the calendar with Access.

Why ?

  • because Microsoft Excel works in one way: it doesn’t sync the data back to SharePoint. It only retrieves it.

How to add events into Calendar using Microsoft Excel and Access ?

  •  choose a location and a name for the database;

How to add events into Calendar using Microsoft Excel and Access ?

  • because we will use Copy-Paste, we must change the fields order in Microsoft Excel so that it matches the field order in Microsoft Access;
  • just select a column and drag & drop it in the right location – in Excel;

How to add events into Calendar using Microsoft Excel and Access ?

  •  select the first 4 columns and copy them;

How to add events into Calendar using Microsoft Excel and Access ?

  • in Access select the same 4 columns and then hit Paste;

How to add events into Calendar using Microsoft Excel and Access ?

  •  confirm the Paste operation;

How to add events into Calendar using Microsoft Excel and Access ?

 Now, we have the same data in Access.

How to add events into Calendar using Microsoft Excel and Access ?

 To sync the database with the calendar, hit the Save button.

How to add events into Calendar using Microsoft Excel and Access ?

In SharePoint, we have to refresh the page.
Now, when the calendar loads, the events are shown.

How to add events into Calendar using Microsoft Excel and Access ?

Note:

  • if you don’t add a value to a field, the default one is added.

Example: 0 for no workspace, FALSE for no recurrences, etc.

(Visited 21 times, 2 visits today)

Cosmin Tătaru

Pasionat de blogging și tehnologie încă din 2009, Cosmin este aici să vă ajute să vă creșteți vânzările și productivitatea punând tehnologia la treabă pentru dumneavoastră.

Suport-Clienti
Mergeți sus