Connect to Office 365 SharePoint Online

How to Connect to Office 365 SharePoint Online and Import and Export Data

Step 1: Set up the Connection URL

To connect to a List/Document Library with Data Synchronisation Studio on SharePoint Online you need to get the URL to your site. For example in the screenshot below our Team Site URL would be


Step 2: Connect SharePoint to the Source or destination

You then enter this URL into the SharePointUrl Property of the 'Microsoft Office 365 SharePoint Online' Data Provider in Data Sync.


Step 3: Enter your Office 365 credentials

You then need to enter the credentials for your SharePoint Online environment. Note that we do not currently support environments where you have federated authentication enabled to your own AD, standard 365 Authentication is fine.


Step 4: Select the SharePoint List

Next select the List that you wish to connect to from the ListName drop down.

List Name

And click OK to connect and there you have it!



If you get an error message when you try to connect that the system cannot load the Microsoft.IdentityModel assembly then you need to install the Windows Identity Framework (WIF) then re-start Data Sync for the changes to take affect.

Error Message

Can't find the answers you're looking for? Contact our support team and we'll personally get back to you as quickly as we can.