SuiteAnalytics Connect is the official ODBC route but is separately licensed and Windows-only, blocking Mac and web Excel users from using it entirely.
NetSuite offers three routes to get data into Excel: the saved search and report export built into every account, scheduled email delivery of saved search results (the classic workaround for recurring reports), and SuiteAnalytics Connect, which is the official ODBC and JDBC driver for SQL-level access. The first two work on any platform because they produce files you open in Excel. SuiteAnalytics Connect requires a separate license, a Windows driver installation, and does not work on Mac or Excel on the web. Here is what each method does and where it falls short.
Method 1: Saved search and report export from the UI
Every saved search in NetSuite has an export button at the top of the results. Open the search from Lists, then Search, then Saved Searches, run it, then click Export and choose Excel or CSV. For reports, the same export option appears in the report header. The export captures the current results with whatever filters and date ranges are applied.
The catch: each export is a manual step and produces a static snapshot. If the same report lands in the same workbook every week, someone has to re-export, open the file, and update the workbook. That process is the main reason teams set up scheduled email delivery or invest in a connector.
Method 2: Scheduled email delivery of saved searches
NetSuite can run a saved search on a schedule and email the results automatically. Open a saved search, scroll to the Email subtab, enable Send Emails According to Schedule, then go to the Schedule subtab to set the frequency (daily, weekly, monthly), the time, and the recipients. Under Send As, choose CSV (lightweight, opens cleanly in Excel), Excel (delivers a formatted XLS), or embed results in the email body. You can also have NetSuite save the file to the File Cabinet for archival.
The catch: NetSuite caps scheduled email exports at around 1,000 rows. If your search returns more records, use the File Cabinet export option or add filters to reduce the row count. The file still arrives in an inbox as an attachment and requires someone to open and use it in Excel. It is not a live connection; it is a recurring snapshot delivered by email.
Method 3: SuiteAnalytics Connect (ODBC, Windows only, separately licensed)
SuiteAnalytics Connect is Oracle NetSuite's official driver for querying NetSuite data using SQL. Once licensed and installed, you connect from Excel via Data, Get Data, From Other Sources, From ODBC, enter DSN=NetSuite; as the connection string, and write SQL queries against NetSuite's exposed tables. Power Query then loads the results into the worksheet, and you can refresh the query on demand.
The catch: SuiteAnalytics Connect is not included in the base NetSuite subscription; it requires a separate license purchase. The driver installation is Windows-only, so the method does not work in Excel on Mac or Excel on the web. Setup involves downloading and configuring the ODBC driver, setting up the DSN, and in some configurations managing Token-Based Authentication. Teams who are already licensed and on Windows will find it the most powerful option for complex cross-table SQL queries, but the setup overhead is meaningful for new users.
Method 4: Brooked for Excel (no ODBC setup, Mac and web Excel supported)
Brooked for Excel connects to NetSuite without requiring you to install an ODBC driver or go through Token-Based Authentication setup manually. It runs inside Excel's ribbon and works in Windows desktop, Mac, and Excel on the web. Pull saved searches, transaction data, or custom records into the worksheet and keep the data current on a schedule.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the connector is fully live, so the NetSuite connection itself is mature.
Setting up the NetSuite connection
Open Brooked in the Excel ribbon, choose NetSuite as the source, and follow the guided authentication flow. Pick the saved search, report, or record type you want (transactions, customers, items, or custom records), configure date ranges and filters, and import into the active worksheet. No driver download and no Token-Based Authentication configuration on your side.
Brooked AI, NetSuiteMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| Saved search / report export (UI) | Free, included with NetSuite | Any Excel | Manual re-export | One-off saved search or report snapshots |
| Scheduled email delivery of saved searches | Free, included with NetSuite | Any Excel (file arrives by email) | Scheduled email, manual open in Excel | Recurring reports without logging in each time |
| SuiteAnalytics Connect (ODBC/JDBC) | Separately licensed add-on | Windows Excel only | On demand via Power Query or ODBC | SQL queries against NetSuite tables, large data |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | No ODBC setup, works on Mac and web Excel |
What finance and ops teams build with this
- Monthly close packet: P&L, balance sheet, and cash flow from NetSuite into one Excel workbook
- AR aging report: open invoices bucketed by 30, 60, and 90 days overdue
- Budget vs actuals: live transaction data feeding the Excel model used in board presentations
- Inventory valuation: item quantities and costs by location, refreshed weekly
- Vendor payment schedule: open bills with due dates sorted for cash flow planning
Troubleshooting common issues
Related Articles
- How to Connect Salesforce to Excel
- How to Connect HubSpot to Excel
- How to Connect NetSuite to Google Sheets
Frequently asked questions
How do I export a NetSuite saved search to Excel?
Open the saved search in NetSuite (go to Lists, then Search, then Saved Searches, and open the search you want). Click the Export button at the top of the results and choose Excel. NetSuite downloads an XLS file with the search results. For reports, open the report and look for a similar export icon. The export respects the current filters and date range set on the search or report.
Can NetSuite automatically send reports to Excel on a schedule?
Yes, via scheduled email delivery of saved searches. Open a saved search, go to the Email subtab at the bottom of the saved search form, and enable Send Emails According to Schedule. Set the frequency, recipients, and file format. NetSuite can attach the results as a CSV, an XLS file, or embed them in the email body. This is the most common workaround for teams that want regular data without logging in, though the file still lands in an inbox and requires someone to open it in Excel manually.
What is SuiteAnalytics Connect and do I need it?
SuiteAnalytics Connect is NetSuite's official ODBC and JDBC driver that lets you connect to NetSuite's data as if it were a SQL database. You can use it with Power Query in Excel via Data, Get Data, From Other Sources, From ODBC. It exposes NetSuite data as tables you can query with SQL. The limitation is that it is a separately purchased license, requires installing the ODBC driver on Windows, and does not work with Excel on Mac or Excel on the web. If your team is already licensed for it and works on Windows, it is a powerful option for complex queries.
Does SuiteAnalytics Connect work on Mac or Excel on the web?
No. SuiteAnalytics Connect uses an ODBC driver that requires a Windows installation. Excel on Mac does not support ODBC data sources, and Excel on the web does not support local driver-based connections at all. If your team uses Macs or works in Excel on the web, you need a different approach: either the UI export workflow or a connector that runs server-side and delivers data without a local driver.
How do I set up Token-Based Authentication for NetSuite API access?
Token-Based Authentication (TBA) in NetSuite requires creating an integration record, generating a consumer key and secret, then creating an access token tied to a specific role and user. The setup involves several steps in NetSuite's admin interface and requires the correct role permissions. Some third-party connectors handle this setup for you; others require you to go through the TBA flow manually before the connector can authenticate.
What is the row limit for NetSuite saved search email exports?
NetSuite caps the number of rows in scheduled email exports. Third-party documentation and community reports suggest the limit is typically around 1,000 rows for email delivery. If your saved search returns more rows than the limit, consider using the File Cabinet export option (which saves the file to NetSuite's internal file storage) or narrowing your search criteria. The SuiteAnalytics Connect ODBC route does not have the same row cap for SQL queries.
Are there third-party Excel add-ins for NetSuite?
Yes, several exist. CloudExtend (now part of Celigo) is a well-known option that lets you pull saved searches and transaction data into Excel and write changes back to NetSuite. Devart and CData each offer an Excel add-in with an ODBC-style connection to NetSuite data. Coefficient is a connector that works in both Excel and Google Sheets. These products carry their own licensing costs and most still require Windows for the full feature set. The tradeoffs worth checking before purchasing: whether Mac is supported, whether write-back is included, and how Token-Based Authentication is handled.
Get live NetSuite data in Excel, without installing an ODBC driver.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
