ExtendInsights offers three ways to retrieve existing NetSuite records into Excel. Use a Saved Search for established search criteria, a Data Filter for flexible rules, or Internal IDs to retrieve a known set of records.
Choose a retrieval method
Method | Best for | Where you define criteria | What you need |
Saved Search | Complex filters, formulas, summary results, or an existing NetSuite search | NetSuite | Access to the Saved Search and the records |
Data Filter (Rules) | Flexible, ad hoc filtering without a Saved Search | ExtendInsights | Access to the records and fields |
Internal ID | Retrieving a known set of exact records | Column B in a loaded template | A template for the record type, valid IDs, and access to the records |
Retrieve records with a Saved Search
Use a Saved Search when you want to apply criteria managed in NetSuite, use an existing search, or retrieve results that use complex filters or summaries. Your NetSuite role must have permission to access the Saved Search.
Start Search and Download or Search and Download with Template.
Select the NetSuite record type and fields.
Turn on Apply Filters and select Using Saved Search.
Choose the Saved Search and filter you want to apply.
Download the results into Excel.
Retrieve records with a Data Filter
Use a Data Filter when you want to define rules directly in ExtendInsights without using a NetSuite Saved Search.
Start Search and Download or Search and Download with Template.
Select the record type and fields, or choose an existing template.
Turn on Apply Filters and select Using Rules.
Create or select a filter, then download the matching records.
Data Filters are saved by NetSuite account and record type. You can reuse them across workbooks, browsers, and devices when connected to the same NetSuite account. Your NetSuite role must still have access to the records and fields.
Retrieve records by Internal ID
Use Internal ID retrieval when you already know exactly which records you need—for example, for a targeted update, validation, or quick lookup.
Load a template for the record type.
Enter one valid NetSuite Internal ID per row in Column B – Internal ID.
Click Reload Records.
ExtendInsights retrieves only the listed records that your NetSuite role can access. Keep Column B in place.
💡 Tips
For scheduled refreshes or repeat reporting, consider ExtendInsights Analytics.
If an Internal ID record doesn’t load, confirm that the ID is valid and your NetSuite role has access.
Before downloading, confirm that the selected record type, search or filter, and fields match what you need.
Need Help?
If you need help deciding between Internal IDs, Data Filters, and Saved Searches:
🔍 Visit the Help Center: https://www.cloudextend.io/support/
💬 Use the in-app chat
✉️ Email cloudextend-support@celigo.com
📎 Include the record type and filter criteria you’re trying to use.
