export exchange public folder contacts to excel

Click the Date Range drop-down menu, and then click the Whole Calendar option to export your entire calendar, or click Specify dates to select a specific range.

Click the Office button, then click Save As.

Open Outlook, Click Calendar in the lower-left corner of the Outlook window.

Outlook can export your calendar data as an iCalendar file, which Apple iCal can then open. If you also use a Mac in addition to a PC, you may need to transfer your Microsoft Outlook contacts and calendar from the PC to your Mac.

Click Close, and then click Back to calendar to return to the Google Calendar.

Next to Calendar, select the Google Calendar in which you want to import the Outlook calendar data.

Next to File click Browse, choose the file that you created, and then click Open.

Under Calendar Settings, click Calendars.

At the top of the page, click Settings > Settings.

If your calendar is empty, you’ll see a message giving you the option to cancel saving the iCalendar file.

Click the Detail arrow and choose the amount of detail you want to show.

TIP: If you choose a large date range or select Whole calendar, you might create a large iCalendar file, which can take a while to generate.

Click the Date Range arrow, and choose the amount of calendar data you want to include in the iCalendar file, or click Specify dates to enter a custom date range.

If you’re satisfied with the summary, jump to step 7, otherwise continue with the next step. You’ll see a summary showing the calendar name, date range, and detail level next to More Options.

Use the default name or type a name for the iCalendar file in the File name box.

Open Outlook and in Calendar, select the calendar you want to export.

In the Set Date Range dialog box, specify the date range you will export calendar within, and clickĮxport Outlook Calendar to Google Export the calendar from Outlook.

Now another Export to a File dialog displays, click Finish to export your Outlook calendar.

When the Export to a File dialog displays again, click Next to continue.

Name the file and click OK to close the dialog.

Browse and choose the destination where the file can be saved.

When the Export to a File dialog displays, click the Browse button to select the destination of the file.

Now, under Select folder to export from, select Calendar from Outlook Data File, and then click Next.

Note: If you are using Outlook 2010 or earlier versions, select the Microsoft Excel 97-2003 option directly.

In the Export to a File dialog, select Comma Separated Values, and then click Next.

When Import and Export Wizard opens, under Choose an action to perform, select Export to a file.

Go to File> Open & Export > Import/Export.

If you’re looking for a way to share your Outlook calendar with others, you can export your Outlook calendar to Excel, and then import it into others’ Outlook calendar folder by following these steps:

Export exchange public folder contacts to excel