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 callouts, showing five ways in turn. In a workbook named Income Statement, Standard Reports › Income Statement › Income Statement is chosen on the Finsyte ribbon. Callout: Standard Reports › Income Statement. The template is added as a new Income Statement sheet, which is opened from its tab. The Subsidiary cell’s list is opened and United States is chosen. Callout: Pick parameters from Finsyte’s dropdowns. FY 2025, 12 and YTD are typed into Fiscal Year, Period Number and Period Range, and the heading reads As of December 31, 2025. Callout: Fiscal year, period and range. Load Accounts is selected. Callout: Load Accounts builds the report. The accounts are listed while the balances load, then the statement fills with live balances, such as Revenue of 4,686,213 and total income of 4,970,512. Callout: Live balances from NetSuite. The Revenue balance is selected, the formula bar shows its =-FSN.GLAccountBalance formula, and the parameter rows are collapsed. Callout: Every number is a Finsyte formula. In a workbook named Open Purchase Orders, =FSN.SavedSearch("Open Purchase Orders Report") is entered in A1. Callout: Run a saved search from a cell. The open purchase orders spill into the sheet. Callout: Results spill in. In a workbook named AR Aging, =FSN.Dataset("SuiteSuccess A/R Aging") is typed into A1. Callout: Load a SuiteAnalytics dataset. Enter is pressed and the dataset spills across the sheet. Callout: The whole dataset, in Excel. On an Invoices sheet, 3/1/2025 is typed into Start and 3/31/2025 into End. Callout: Download records with Bulk Records. Download Invoices is selected, the banner counts the invoices as they arrive, and the sheet fills with invoices, each with a Downloaded Invoice link. Callout: Every record linked to NetSuite. In a workbook named Sales by Month, A1 holds =FSN.Query with a SuiteQL query that totals invoices by month. Callout: Write a SuiteQL query. Enter is pressed and one row per month, January through May 2025, spills into the sheet. Callout: Query results, live.
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.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Standard Reports › Income Statement opens a submenu with Income Statement and Comparative Income Statement. Callout: Standard Reports → Income Statement. Income Statement adds an Income Statement sheet with a parameter block at the top. The Subsidiary list opens and United States is highlighted. Callout: Pick each parameter from Finsyte’s dropdowns. Subsidiary is set to United States, and the column heading follows. Fiscal Year is set to FY 2025 from its list. In Period Number, typing 1 shows Excel’s list of matching values and typing 2 narrows it to 12; Enter sets it, and the title line updates to As of December 31, 2025. The Period Range list opens and YTD is highlighted. Callout: Period and range come from dropdowns too. Period Range is set to YTD, with Book on Primary Accounting Book. Pointing at Load Accounts on the ribbon shows its ScreenTip. Callout: Load Accounts builds the report. After the click, Cancel appears and the account tree under Ordinary Income/Expense is listed with #GETTING_DATA while the status bar reads Queuing requests, then the balances fill the United States column. Callout: Live balances from NetSuite. Under Income, Sales of 246,250, Revenue of 4,686,213 and Shipping Income of 26,361 roll up to Total - Income of 4,970,512. The parameter rows are collapsed with the outline button. Callout: Collapse the parameters to focus on the numbers. Scrolling down through Cost of Sales shows Total - Cost of Sales of 1,464,360 and Gross Profit of 3,506,152.
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 callouts. In a workbook named Open Purchase Orders, A1 is double-clicked and =FSN.Sa is typed; Excel’s AutoComplete lists FSN.SavedSearch and the saved-search functions registered in the account. Callout: Type =FSN.SavedSearch in any cell. As typing continues, the add-in’s argument tip says the search can be given by name or script ID, and the cell reads =FSN.SavedSearch("Open Purchase Orders Report"). Callout: Name the saved search. Enter is pressed and A1 fills with # signs while NetSuite runs the search, then the results spill in: a header row, Date, Location, Document Number, Name, Memo and Amount, then one row per open purchase order. Callout: Results spill in as a dynamic array. A1 is selected and the formula bar shows the formula. Callout: One formula, live from NetSuite. The sheet scrolls down through the purchase orders.
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 callouts. In a workbook named AR Aging, From List on the Finsyte ribbon is opened and Datasets is chosen. Callout: From List › Datasets. A new Datasets sheet lists every SuiteAnalytics dataset in the account by Id and Name. Callout: Every SuiteAnalytics dataset, listed. SuiteSuccess A/R Aging is selected in the list. Callout: Find the one you need. Back on the AR Aging sheet, A1 is double-clicked and =FSN.Da is typed; Excel’s AutoComplete offers FSN.Dataset. Callout: Type =FSN.Dataset. Typing continues with the add-in’s argument tip showing, until A1 reads =FSN.Dataset("SuiteSuccess A/R Aging"). Callout: Name the dataset. Enter is pressed, A1 shows #GETTING_DATA, and the dataset spills across the sheet with a column for each of its fields, such as the transaction type, date, number and amounts, and one row per A/R transaction line, newest first. Callout: The dataset spills in. A1 is selected and the formula bar shows the formula. Callout: One formula, live from NetSuite. The sheet scrolls down through the rows.
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 callouts. On an empty Invoices sheet, with Filter By on tranDate, Start is selected and 3/18/2025 is typed into it; End is left blank. Callout: One date: enter it in Start. Download Invoices is selected on the Finsyte ribbon. Callout: Download Invoices. The banner shows Download complete, and the sheet holds the invoices dated March 18, 2025, each with a Downloaded Invoice link. Callout: That day’s invoices. On another empty Invoices sheet, 3/1/2025 is typed into Start and 3/31/2025 into End. Callout: For a range, add an End date. Download Invoices is selected again. Callout: Download the range. The banner counts the invoices as they arrive, then reads Download complete. Callout: Every invoice in March. The sheet scrolls through March’s invoices, from March 31 down to March 1.
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 callouts. In a workbook named Sales by Month, with the formula bar expanded, A1 is double-clicked and =FSN.Q is typed; Excel’s AutoComplete offers FSN.Query. Callout: Type =FSN.Query. The query is typed into the cell with the add-in’s argument tip showing, and the formula bar shows it in full: it totals invoice amounts by month from January through May 2025. Callout: Write the SuiteQL right in the cell. Enter is pressed, A1 shows #GETTING_DATA, then the results spill in: a header row, period and sales, and one row per month: 2025-01, 824,373.11; 2025-02, 10,889,421.32; 2025-03, 903,913.28; 2025-04, 709,079.02; 2025-05, 1,108,725.08. Callout: Results spill in.
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.