Export NetSuite Data to Excel
Bring NetSuite data directly into Excel, without exporting a CSV. Pull account balances into any cell, run a Saved Search or a SuiteAnalytics dataset, download records with Bulk Records, or write a SuiteQL query, then refresh whenever the numbers change.
Screen recording in Excel with on-screen captions. Caption 1: Live account balances in any cell. In a workbook named Income Statement, Standard Reports › Income Statement inserts the template, the subsidiary, fiscal year, period and period range are filled in, Load Accounts fills the statement with live balances, and a balance cell shows its =FSN.GLAccountBalance formula. Caption 2: Run a Saved Search. =FSN.SavedSearch("Open Purchase Orders Report") is entered and the open purchase orders spill into the sheet. Caption 3: Load a SuiteAnalytics dataset. =FSN.Dataset("SuiteSuccess A/R Aging") is entered and the dataset spills across the sheet. Caption 4: Download records with Bulk Records. On an Invoices sheet, Start and End dates are entered, Download Invoices is selected, and the invoices fill the sheet with a Downloaded Invoice link on each row. Caption 5: Write a SuiteQL query. =FSN.Query with a SuiteQL query that totals invoices by month is entered, and one row per month spills into the sheet.
Connect NetSuite to Excel and keep the data live
Finsyte, the Excel add-in for NetSuite, connects your workbook to your NetSuite account. Pick the source that fits the job: Finsyte functions return account balances one cell at a time or whole result sets as dynamic arrays, and Bulk Records downloads whole records you can edit and upload.
- Account balances in any cell, for financial statements in your own layout or from a template
- Saved Searches you already use, run from a cell, with your own filters as arguments
- SuiteAnalytics datasets by name, with no query to write
- Records of 155+ types downloaded by filter, ready to edit and upload
- SuiteQL queries with joins, filters and grouping, written in the formula
- Results that Excel formulas, PivotTables and Power Query can use straight away
- No CSV export and import: data lands in the sheet and refreshes in place
Bring NetSuite data into Excel in four steps
Choose a source
Account balances, a Saved Search you already have, a SuiteAnalytics dataset, a Bulk Records template or a SuiteQL query.
Bring it into Excel
Insert a report template, type
=FSN.GLAccountBalance,=FSN.SavedSearch,=FSN.Datasetor=FSN.Queryin a cell, or download a Bulk Records sheet.Work with it
Sort, filter, chart and model the data with everything Excel offers, or load it into Power Query.
Refresh
Refresh Data reruns the functions with the latest from NetSuite. A Bulk Records sheet refreshes when you download again.
Five ways to export NetSuite data to Excel
Each returns live NetSuite data to Excel. Choose by where the data is defined and whether it needs to go back.
Account balances
Build reports from live account balances
Finsyte functions such as =FSN.GLAccountBalance return a NetSuite account balance in any cell, for the subsidiary, period and segments you choose. Lay them out in your own format, or start from a ready-made balance sheet, income statement, trial balance or cash flow template and adjust it from there. See all report templates.
Silent screen recording in Excel. On the Finsyte ribbon, Standard Reports › Income Statement › Income Statement adds an Income Statement sheet with a parameter block at the top. Subsidiary is set to United States, Fiscal Year to FY 2025, Period Number to 12, and Period Range to YTD, with Book on Primary Accounting Book. The title line updates to As of December 31, 2025. Load Accounts on the ribbon collapses the parameters and fills the United States column with the account tree under Ordinary Income/Expense: Income, where Sales, Revenue and Shipping Income roll up to Total - Income of 4,970,512, followed by Cost of Sales.
Saved Searches
Run a Saved Search from a cell
=FSN.SavedSearch runs a NetSuite Saved Search by its ID and returns the results as a dynamic array. Register a search with filter parameters and it becomes its own function, with an argument for each filter you point at a cell. Saved Searches need the Finsyte SuiteApp. More on Saved Searches in Excel.
Screen recording in Excel with on-screen captions. Caption 1: Run a saved search from a cell. In a workbook named Open Purchase Orders, =FSN.SavedSearch("Open Purchase Orders Report") is typed into A1. Caption 2: The results spill in as a dynamic array. The search returns a header row, Date, Location, Document Number, Name, Memo and Amount, then one row per open purchase order, and the sheet scrolls down through them.
SuiteAnalytics
Load a SuiteAnalytics dataset
=FSN.Dataset loads a SuiteAnalytics dataset by its name, or by its ID when the name isn’t unique. The dataset’s columns and criteria come from NetSuite, so there’s no query to write.
Screen recording in Excel with on-screen captions. Caption 1: Find the dataset in From List. On the Finsyte ribbon, From List › Datasets lists every SuiteAnalytics dataset in the account by ID and name, and SuiteSuccess A/R Aging is selected. Caption 2: Load it by name. On a blank sheet in a workbook named AR Aging, =FSN.Dataset("SuiteSuccess A/R Aging") is typed into A1. Caption 3: Returned as a dynamic array. The dataset spills across the sheet with a column for each of its fields, such as the transaction type, date, number and amounts, one row per open transaction, and the sheet scrolls down through them.
Bulk Records
Download whole records, then edit them
A Bulk Records template turns a record type into a sheet. Choose a filter, such as a range of transaction dates, and download: each record lands on its own row with its Internal ID and a link to it in NetSuite, ready to edit and upload. How to bulk export NetSuite records to Excel.
Screen recording in Excel with on-screen captions. Caption 1: One date: enter it in Start. With Filter By on tranDate, 3/18/2025 is typed into Start and End is left blank. Caption 2: Download that day’s invoices. Download Invoices is selected on the Finsyte ribbon and the sheet fills with the invoices dated that day, each with a Downloaded Invoice link. Caption 3: For a range, add an End date. On an empty Invoices sheet, 3/1/2025 is typed into Start and 3/31/2025 into End. Caption 4: Download every invoice in the range. The banner counts the invoices as they arrive, then reads Download complete with the filter, and the sheet scrolls through March’s invoices.
SuiteQL
Query NetSuite with SuiteQL
=FSN.Query runs a SuiteQL query and returns the rows as a dynamic array. Joins, filters and grouping go in the query itself, and optional arguments leave out the header or return a set number of rows.
Screen recording in Excel with on-screen captions. Caption 1: Write a SuiteQL query in a cell. In a workbook named Sales by Month, cell A1 holds =FSN.Query with a query that totals invoice amounts by month from January through May 2025, shown in full in the formula bar. Caption 2: Press Enter: the results spill in. The cell returns a header row, period and sales, and one row per month with that month’s invoice total.
Choosing how to export NetSuite data
For financial statements, start from a report template or lay out account balances yourself. If a Saved Search or a SuiteAnalytics dataset already returns what you need, run it from Excel. If the data needs to change and go back to NetSuite, download it with Bulk Records. If you think in SQL, write the query.
| Compared on | Account balances | Saved Search | Dataset | Bulk Records | Query |
|---|---|---|---|---|---|
| Starts from | An account, period and segments | A Saved Search in NetSuite | A SuiteAnalytics dataset | A template for a record type | A SuiteQL query |
| In Excel | =FSN.GLAccountBalance in each cell, or a report template | =FSN.SavedSearch in a cell | =FSN.Dataset in a cell | A sheet you download into | =FSN.Query in a cell |
| Filter with | The function’s arguments | The search’s criteria, plus arguments you register | The dataset’s criteria | Filter By, Start and End | The query’s WHERE clause |
| Refresh | Refresh Data | Refresh Data | Refresh Data | Download again | Refresh Data |
| Send changes back | Read only | Read only | Read only | Edit and upload | Read only |
The functions refresh with the rest of the workbook, and right-click › Refresh Selection updates just the cells you pick. To share a copy with someone who doesn’t use Finsyte, save a static snapshot with the values in place of the functions.
Exporting NetSuite data to Excel: FAQ
- QHow do I export NetSuite data to Excel?
- With Finsyte, pick the source that fits: pull account balances into cells with FSN.GLAccountBalance or a report template, run a Saved Search with FSN.SavedSearch or a SuiteAnalytics dataset with FSN.Dataset, download records into a Bulk Records sheet, or write a SuiteQL query with FSN.Query. The data lands in Excel and refreshes in place.
- QHow do I connect NetSuite to Excel?
- Install the Finsyte add-in for Excel, select Login in the Connectivity group of the Finsyte ribbon and sign in to your NetSuite account in the browser window that opens. Finsyte functions and Bulk Records then read from that account.
- QIs there an Excel add-in for NetSuite?
- Yes. Finsyte is an Excel add-in for NetSuite on Windows. It brings account balances, Saved Searches, SuiteAnalytics datasets, records and SuiteQL query results into Excel, and writes budgets, journal entries and records back to NetSuite.
- QDo I still need to export a CSV from NetSuite?
- No. Finsyte brings the data into Excel directly, so there is no file to export, open and import. When the data changes, refresh the sheet instead of exporting again.
- QCan I pull NetSuite account balances into my own Excel report?
- Yes. FSN.GLAccountBalance returns an account’s balance in any cell for the subsidiary, period and segments you choose, so you can build a report in your own layout. To start faster, insert a balance sheet, income statement, trial balance or cash flow template and adjust it.
- QCan I export a NetSuite Saved Search to Excel?
- Yes. FSN.SavedSearch runs it by its ID and returns the results as a dynamic array. Register a search with filter parameters and it becomes its own function, such as FSN.SavedSearch.APAging, with an argument for each filter. Saved Searches need the Finsyte SuiteApp deployed in NetSuite.
- QHow do I get a SuiteAnalytics dataset into Excel?
- Use FSN.Dataset with the dataset’s name, or its ID if the name isn’t unique. The dataset’s columns and criteria come from NetSuite, so there’s no query to write.
- QCan I run SuiteQL from Excel?
- Yes. FSN.Query runs a SuiteQL query and returns the rows as a dynamic array. Joins, filters and grouping go in the query, and optional arguments leave out the header, skip rows or limit how many come back.
- QHow do I refresh NetSuite data in Excel?
- Refresh Data on the Finsyte ribbon reruns the functions in a sheet or the whole workbook, and right-click › Refresh Selection updates just the cells you pick. A Bulk Records sheet updates when you download again.
- QCan I change the data and send it back to NetSuite?
- Records downloaded into a Bulk Records sheet can be edited and uploaded back to NetSuite. Account balances and Saved Search, Dataset and Query results are read only.
- QCan I share an export with someone who doesn’t use Finsyte?
- Yes. Save a static snapshot, which keeps the values and replaces the functions, and share that copy.
- QDo I need extra NetSuite modules?
- No. Account balances, report templates, Dataset and Query need nothing extra. Saved Searches and Bulk Records need the Finsyte SuiteApp, which comes with Finsyte and deploys from Finsyte Preferences.
Try it with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.