Overview
When you load a template, ExtendInsights transforms your worksheet into a workspace for managing data.
This article explains each area of the workspace and what it's used for.
Workspace Layout
The table loads on the left side of the worksheet.
The ExtendInsights panel provides options to download, upload, refresh, and delete records within Excel.
Key Sections
1. Row 1 – Mapping Syntax
Reserved for data source field names (hidden by default).
Should not be edited unless you are a power user.
Click on a cell in Row 1 to reveal field names.
2. Column A – Error Messages
Displays error messages encountered when sending data to your data source.
Helps quickly identify and correct issues.
3. Record ID Field
Represents the unique identifier for an object or record type.
A unique alphanumeric value used to manage specific records.
4. Connections
Establish connections to the data source.
5. Object and Fields
Define objects and fields clearly to establish the foundation of your data.
This serves as a guide on how your data, your data source, and Excel will communicate.
6. Filter
Set criteria rules within the app using filter options.
Filtering is based on object, filter type, operator, and values to refine your dataset.
7. Preview
Previewing your data helps validate the template structure before finalizing.
Download the first 50 records when enabled, and the Proceed button is triggered.
8. Proceed
If preview is turned off, the table will appear blank until data is fetched.
If preview is turned on, download the first 50 records.
9. Save as Template
Save your templates in ExtendInsights to avoid repetitive mapping.
If you frequently update similar data, pre-configured templates improve efficiency.
10. Assign Schedule
Automate data downloads by scheduling filters or SOQL queries.
Click Assign Schedule > Create to set up automatic syncs.
11. ExtendInsights Actions
ExtendInsights enables users to efficiently manage records by performing:
✅ Create, upload, and delete operations.
✅ Filter and download records for streamlined data management.
12. Picklist Cell Operations
ExtendInsights recognizes list-type fields in your template.
You can view and select values directly from your data source.
What Would You Like to Do Next?
I want to... | Learn More |
Build a template | |
Download records | |
Create new records | |
Update existing records | |
Save templates | |
Create a connection |
💬 Need Help?
Before contacting Support, try searching:
If you still need assistance:
💬 Use in-app chat (bottom-right of the support site)
✉️ Email cloudextend-support@celigo.com

