Skip to main content

Admin: ExtendInsights Analytics for NetSuite Setup Guide

ExtendInsights Analytics | Guide to help streamline your setup

Updated today

Welcome to ExtendInsights Analytics for NetSuite. We’re glad to have you on board. This guide helps Enterprise customers complete the required setup so users can run NetSuite Saved Searches and automate analytics directly from Excel.


Who Is Required for the Initial Setup?

To complete the setup, the following roles are required. In some organizations, one person may perform multiple roles. These users do not need to complete their steps at the same time.

  1. Subscription Admin

  2. A user with NetSuite admin rights

  3. (Optional). A user with GLOBAL ADMIN rights to your Microsoft 365 environment


πŸ“’ CloudExtend Admin Notice: New Subscription Portal

CloudExtend is transitioning to a new subscription management portal.


Before You Begin

Make sure the following are true before starting setup:

  • You have an active or trial Enterprise subscription for ExtendInsights Analytics

  • You know which Analytics features your organization is licensed for

  • Users will work in Excel to analyze NetSuite data


Review Excel Add-In Requirements

ExtendInsights works with the following Excel environments:

  • Excel 2019 or later

  • Excel with a Microsoft 365 subscription (recommended)

  • Excel Online

Scheduling Requirements (Analytics Only)

To use scheduling features:

  • Workbook must be saved to OneDrive for Business or SharePoint

  • User must have a Microsoft 365 subscription (required)

πŸ“ Note:
If users cannot install add-ins from Microsoft AppSource, share this guide with your Microsoft 365 Administrator.


Core Setup (Required)

The following steps must be completed before users can begin using ExtendInsights Analytics.

Step

Who Performs It

Description

1. Review Excel add-in requirements

Microsoft 365 Admin

Confirm supported Excel versions and deployment approach

(See section above)

2. Install CloudExtend NetSuite Bundle

NetSuite Admin

Install CloudExtend Excel for NetSuite (Bundle ID: 246132)
​
πŸ“˜ Install Bundle Guide

3. Complete NetSuite prerequisites

NetSuite Admin

Enable required NetSuite features and role permissions

4. Manage licenses

Subscription Admin

Assign user licenses in the CloudExtend portal

5. Install ExtendInsights Excel add-in

End Users or Microsoft Admin

Install the ExtendInsights Excel Data Connector

6. Log in and connect to NetSuite

End Users

Log in and select the correct NetSuite role and environment

πŸ’‘ Note: Central Deployment for ExtendInsights
Microsoft supports central deployment of Excel add-ins, which is ideal for Enterprise environments or organizations that restrict AppSource access.
​


NetSuite Prerequisites

The following steps must be completed by a NetSuite Administrator.

Step 1: Company-Wide Settings

  1. Go to Setup β†’ Company β†’ Enable Features

  2. Open the SuiteCloud tab

  3. Enable the following:

    • SOAP Web Services (SuiteTalk)

    • Token-Based Authentication (Manage Authentication)

  4. Click Save

Step 2: Verify the Role Is Not β€œWeb Services Only”

  • Go to Setup > Users/Roles > Manage Roles.

  • Validate if the Web Service Only Role is OFF.

Step 3: General Permissions to be set per Role

  • Your NetSuite Admin must configure the following permissions for the roles you plan to use when logging in through CloudExtend.

  • In NetSuite, go to Setup β†’ Users/Roles β†’ Manage Roles, then select the role to update.​

Permissions > Setup Tab

Permission

Details / Purpose

SOAP Web Services

Required for API communication between CloudExtend and NetSuite.

User Access Tokens

Required to generate tokens automatically during login.

SAML Single Sign-On

Enable only if your company uses SSO (Okta, OneLogin, Microsoft Entra ID, etc.).
⚠️ Do not enable if SSO is not in use. Users will be unable to log in until removed.

Allow JS/HTML Uploads

Required for users uploading .js or .htm files.

Log in using Access Tokens

Adds additional token authentication capability.

Permissions β†’ Lists

Permission

Level

Persist Search

Create

Perform Search

View(minimum)


⚠️ Important - Column Names (Working with Saved Searches)

If your searches use grouping or summary, please be sure that you use a summary label to name the column in your saved search. The reason for this is that the new feature we are leveraging in NetSuite does not use the same field header as NetSuite's older search technology and this could break your downstream processes.


Set Your Users Up for Success

βœ… Assist with Installation and Login

Help users:

  • Install the Excel add-in

  • Log in with Microsoft 365

  • Select the correct NetSuite role and environment

βœ… Customer Success & Training

Your Customer Success Manager and Training Manager offer free end-user training.
Sessions can be recorded and shared across your organization.

βœ… Train and Empower Your Users

To ensure a smooth rollout and high adoption:


Need Help?

Before contacting Support, try searching:

If you still need assistance:

πŸ“Ž Please include your NetSuite Account ID, role name, and screenshots when possible.

Did this answer your question?