Turn NetSuite Saved Searches Into Live Excel Dashboards
Bring your existing NetSuite Saved Searches into Excel as live, dynamic data — then use Power Query and the Excel tools your team already knows to shape them into the outputs your stakeholders need.
Your NetSuite data, your Excel workflow
NetSuite Saved Searches are a powerful way to define exactly the data you need. Finsyte brings those results into Excel as a live dynamic array, so the next time your team needs to combine searches, transform columns, or shape data into a stakeholder-ready view, you can do it where your team already works.
Pair that with Power Query — built into Excel — and you have everything you need to merge multiple Saved Searches, build calculated fields, and produce a refreshable dashboard, all without leaving the spreadsheet.
From Saved Search to dashboard, in four steps
A real-world example: combining a Work Order Production Activity search with a Manufacturing Cost & COGS search to produce a single performance dashboard.
Start with the Saved Searches you already trust
Saved Searches are the foundation. In this example, one search returns operational activity — Work Orders, items, and quantities. The other returns the financials — cost and COGS by item. Familiar territory for any NetSuite user.
- Use any record type — transactions, items, vendors, custom records
- Reuse the criteria, formulas, and joins you’ve already built
- Permissions follow NetSuite’s native role-based rules
- FSN — Work Order Production ActivityOperational
- FSN — Manufacturing Cost and COGSFinancial
Pull the results into Excel with one function
Drop FSN.SavedSearch into a cell and pass the name or id of your search. The results return as a dynamic array — auto-expanding, refreshable, and ready for the rest of your formulas to reference.
- Live data — refresh any time, no CSV exports
- Connects through NetSuite’s native REST API — no extra modules required
- IntelliSense guides you as you type the formula
Reshape the data in Power Query
Power Query is built into Excel and pairs naturally with Finsyte. Point it at the dynamic arrays your Saved Searches return, merge them on a shared key, and produce a single combined dataset — no scripting, no SQL.
- Merge multiple Saved Searches on any shared field
- Transform columns, filter rows, build calculated fields
- Refresh the source data and Power Query updates downstream automatically
Joined on a shared key — no scripting, no SQL.
Build the dashboard your stakeholders need
On top of the merged dataset, layer KPI tiles, charts, and a formatted summary table — using the same Excel tools your team already knows. The result is a presentation-ready report that updates with a click.
- KPI metric callouts surface the numbers that matter most
- Side-by-side charts for comparison views
- Trend lines for production volume and other time-series data
- A formatted summary table for the detail your audience expects
What teams build with this workflow
Anywhere your team is already combining Saved Searches by hand, Finsyte and Power Query can do it live.
Operational + financial dashboards
Combine activity data with cost data to see performance the way the business actually runs — not in two separate reports.
Custom KPI views
Build the metric your team cares about — not just what fits in a portlet. Calculated fields, conditional formatting, and Excel charts give you full control.
Presentation-ready reports
Polished output that goes straight to leadership, the board, or a department review — no post-export cleanup, no manual refresh dance.
When NetSuite changes, your dashboard catches up
The Finsyte ribbon's Refresh dropdown lets you update a single cell, the active sheet, or the entire workbook. Saved Search results pull again, Power Query re-runs the merge, and your dashboard reflects the latest data — all from one button.
Ready to take your Saved Searches further?
30-day free trial. Full access to Saved Search, Power Query support, and every other Finsyte feature. No credit card required.