Once your list is exported, here's what it looks like in SharePoint.Click to view larger image.
You'll be returned to the SharePoint window and you'll find your list, directly imported into the SharePoint database. You can then adjust the view and change the order of the columns, their names and more from the List tab in the List Tools group; just click List Settings to the far right of the window.
5. Overlay multiple calendars in SharePoint to create a master calendar. Your team can now have a master calendar that includes calendar rollup information from calendars that are nestled deeper into the SharePoint site hierarchy. You can overlay up to 10 calendars over one another to create this master calendar, and each calendar is displayed in a different color code. (It's kind of like what happens when you link a SharePoint calendar to Outlook and then overlay the two calendars within the Outlook client.)
You can have one 'master' calendar for your entire team.Click to view larger image.
At the main SharePoint site where you want the master calendar to live, either create a new calendar list from the Site Actions menu, or use an existing calendar that already is configured at the level you want. On the Calendar tab in the Ribbon, click Calendars Overlay, and then click the New Calendar link to add a new calendar to the overlay view.
This next part is a bit trickier: You have to give SharePoint some information about the calendar that you are adding, such as a name and its plain-English description, and you need to have the URL of the site that houses the calendar. This is the link to the site itself, not a link directly to the calendar. After you enter in the web URL and click the Resolve button, SharePoint will use that URL to crawl the site and find the calendar lists and views.
You select up to 10 calendars to roll up into one.Click to view larger image.
If the site you provided has many calendar lists or views, SharePoint will ask you to choose the ones you want to overlay; just select the box next to Always Show, and when you're done, click OK. Lather, rinse, repeat for each separate website (again, up to 10 individual calendars) that contains calendars you want to overlay, and then click OK. Now you'll see all of those calendars rolled up into one master calendar.