The Crisp Data Platform Connector add-in for Excel simplifies the data feed connection process for Crisp users who have purchased a destination connector plan. Reports can be loaded and synced on an individual basis for optimized performance in Excel. The add-in also makes Crisp's Excel connector available for Mac users. 

Note: Before you download and set up the add-in, make sure you have an active Microsoft work or school account that you can log into.

1. In Excel, select Insert and then Get Add-ins.

Insert_-_Get_Add-ins.pngThe Office Add-ins window appears.

 

2. Search for "Crisp", then select the Add button to the right of the Crisp add-in.

Click_Add.png

                                                   Simulated image

3. Accept the permissions, then select the Continue button.
Note: If you're unable to select Continue, you can download the add-in from Microsoft's AppSource.

Excel_Addin_001.png

4. After the add-in downloads, select the Crisp icon in the top right corner of the screen, then select Get started.

Updated_Crisp_Add_In_Selection.gif

5. From the window that appears, select the Allow button.

Excel_Addin_003.png


6. From the Crisp Platform window that appears, log in to your Crisp account.

Crisp_Log_In_Window_Excel.pngNote: If you're using Excel online, be sure to have 3rd-party cookies enabled! If you're using an incognito window, these will be turned off by default.
Once logged in, a field appears where you can enter the feed URL from Crisp.

7. To get the feed URL:

  • From the main menu on the left side of the screen, select Connectors.
  • Select the Destinations tab, then locate the Excel tile you want to connect and select the Copy OData feed link. 

Copy_OData_feed_tile.png

The link is copied to your clipboard and ready to paste into Excel. 

8. Paste the OData feed link into the add-in window, then select the Test & save button.

Odata_Feed.png

9. Select the report(s) you want to sync.
Excel_Addin_004.png

10. If you want to filter the report to include or exclude specific data, select the filter icon to the right of the report, then set your filter conditions. For more: Setting filters with the MacOS Add-in for Excel.

Excel_Addin_005.png
Hint: If you have a large data set, applying filters can help reduce sync time and errors caused by exceeding the row limits in Excel. 

11. Select the Save button.
Excel_Addin_010.png
Each report loads in its own tab. If you added filters, your reports will automatically filter based on the conditions you specified. 

 

12. If you want to start or stop the data from syncing for all reports in the document, you can select the Sync all reports or Stop sync action buttons at the top of the add-in pane. If you want to change which reports are included in the sync, you can select Select reports, then add or remove reports.

            Sync_all_reports_button.pngStop_sync_button.png Select_reports_button.png

Hint: You can adjust your settings to automatically sync your reports when you open a file. Just select Settings > Auto sync on document open. You must have the latest version of the Excel add-in to enable auto sync. If your docs don't sync automatically after turning on this setting, re-install the Excel add-in from the Microsoft store to get the latest version.  

 

13. If you want to stop, sync, or remove an individual report, you can select the buttons (e.g., Stop sync) underneath each report.

Excel_Addin_014.png

14. To update the feed URL, connection settings, or to log out, select Settings at the bottom of the add-in pane.

Excel_Addin_015.png

 

Need help with the add-in? Contact us at support@gocrisp.com