This article provides an overview to get started with the Microsoft Excel connector in Peliqan. Please contact support if you have any additional questions or remarks.

Contents

Connect

In peliqan, go to Connections, click on Add new. Find “Excel 365” in the list and select it. Click on the Connect button. This will open Microsoft Excel and allow you to authorize access for Peliqan. Once the authorization is done, you will return to Peliqan.

How to find your Site id (Sharepoint)

Using Sharepoint admin

Go to: https://{tenant}-admin.sharepoint.com

Replace {tenant} with your Sharepoint subdomain.

Navigate to: Sites > Active Sites > Select your Site.

The Site ID is in the URL on the right hand side.

Using an _api URL

Open this URL in your browser:

• For the main (default) site: https://{tenant}.sharepoint.com/_api/site/id
• For other sites: https://{tenant}.sharepoint.com/sites/{sitename}/_api/site/id

Make sure to remove spaces from the site name when inserting {sitename}.

The Site ID is in the XML response, see the guid at the end of the XML.