Use PowerShell to Export/Import calendar Items from Office 365

Aftab Alam | Updated On - December 13, 2022 |

Read time 5 minutes

When a manager creates a new meeting in the calendar, it is meant for sharing with others. The Office 365 account present in Outlook can share a calendar with other users like an email. But, sometimes, the manager needs to backup these items. Office 365 provides an inbuilt process to export calendar items in an offline file.

So, you need to export the calendar items from Office 365 and you can do it using the PowerShell cmdlets easily.

1. Create a network-shared folder to save the PST file.
2. The users account should have the read/write permissions to the Exchange Trusted Subsystem group on the folder.

Now start the process

1. Run the following command that will let you any kind of script whether it is signed or not. It will ask you to confirm your selection related to the change in execution policy. Click Y
   Set-ExecutionPolicy Unrestricted

   

2. Run the second command to input the credentials of Office 365 account.
   $livecred=Get-Credential

   

3. A pop-up will open and ask you to input the credentials of office 365 account.
   
4. you need to create a session with the Office 365. run the below command –
   $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri
   https://outlook.office365.csom/powershell-liveid/ -Credential $UserCredential –
   Authentication Basic –AllowRedirection

   

5. It will again ask you to input the credentials of your Office 365 account.
   
6. When the Powershell is connected with the Office 365 completely, then you can import the whole session by running the following command;
   Import-PSSession $Session –DisableNameChecking

   

7. In last, you can run the cmdlet to export the entire calendar folder to export the data within the range.
   New-MailboxExportRequest –Mailbox -IncludeFolders ‘Calendars’ –FilePath ‘D:\Meeting Room\Adam.pst’

   
   Or

   Export-Mailbox-Identity –StartDate ‘22/06/2016’ –EndDate ‘16/09/2017’ –IncludeFolders ‘\Calendar’ –FilePath \\PSTFile\FolderName\FileName.pst

Import calendar into the Office 365 mailbox

If you have a CSV file with the important calendar events, then you can import the CSV file into the Office 365 mailbox by following the steps;

1. Install the EWS Managed API from the below URL –
   https://www.microsoft.com/en-us/download/details.aspx?id=35371
2. Assign Impersonation Rights to the account.
3. Create the CSV file having all the fields like Date, Subject, Start Date, End Date, Start Time, and End Time.
4. Now, run the command;
   Import-CalendarCSV -CSVFileName D:\Monthly Meetings\calendar.csv -EmailAddress
   jacob@domain.com -Impersonate $true
5. If the account does not have the impersonation rights, then you can run another command;
   Import-CalendarCSV -CSVFileName D:\Monthly Meetings\calendar.csv -EmailAddress
   jacob@domain.com -username jacob@domain.com -password 1234!@#$

• The manual methods do not let you apply filters easily in the calendar items.
• You need to create a CSV file for importing the calendar items, which may be time-consuming.
• You can export or import the calendar items of the single mailbox only that maybe not enough for a large project.
• If any field in the CSV file is missing, then there is no way to skip it.
• The account should have impersonation rights while importing the data.
• If the session is stopped abruptly during the export, then you will have to start the export process again. It may also corrupt the PST file.
• There can be some errors in the Mailbox Export Request Access path is denied.

Conclusion

To overcome the limitations of the manual import/export method, you should use the Kernel Office 365 Backup & Restore tool. This software lets you take the selective backup of unlimited mailboxes and restore multiple PST files to multiple Office 365 mailboxes. The tool gives you the flexibility of choosing any folder from the mailbox, apply filters to it, and save it in the PST file. There is no limitation on the number of mailboxes for taking the backup and the tool will save a separate PST file for each mailbox.

Similarly, you can import the entire PST file or its chosen folders into the Office 365 mailbox. After the completion of import/export, you will get a complete migration report with the status of each migrated item. You can also save the migration report in a CSV file.