Export guide · Checked against NetSuite documentation 2026-11-17
How to export all your data from NetSuite
Only a user with the Administrator role can run the Full CSV Export at Setup > Import/Export > Export Tasks > Full CSV Export. It downloads a ZIP of CSV files covering a fixed set of lists and reports, not all data. The rest comes out through saved search exports, report exports or SuiteAnalytics Connect.
Who can export from NetSuite
NetSuite states that only users who have the Administrator role can use the CSV Export function. The same help page is direct about its reach: the Full CSV Export option does not currently export all data as CSV files. It covers a named set of lists and reports, so an Administrator should treat it as a starting point.
Exporting search results needs two permissions, Export Lists and Perform Search. A user who lacks them does not see an Export button on the results page. For SuiteAnalytics Connect, Oracle describes the Data Integrator role and custom roles as the preferred option when transferring data to a data warehouse. Connect is also described as an additional service with an associated fee, so check that it is part of your account at the time of checking.
How to export, step by step
Route 1 of 3
Full CSV Export
Administrator role only.
- 01Go to Setup > Import/Export > Export Tasks > Full CSV Export.
- 02Click Submit and wait for the progress bar to finish.
- 03In the File Download window, select Save this file to disk and then OK.
- 04In the Save As window, enter a file name with the extension ZIP.
- 05Click Save.
- 06Open the ZIP file to see the generated CSV files.
- 07Open a CSV file in a spreadsheet or text editor program.
If the export times out, NetSuite says to export smaller sets by opening the page for each list or report and clicking the Export - CSV button. The export runs your saved searches, so a saved search that fails can make the whole export fail.
Route 2 of 3
Saved search export
Any role with the Export Lists and Perform Search permissions.
- 01Create or open a search for one record type, such as contact, customer, vendor or transaction.
- 02On the Results subtab, select the fields to export and their order, and add Internal ID as a results column.
- 03Click Submit to run the search.
- 04On the results page, click Export - CSV, Export - Microsoft Excel for an XLSX file, or Export - PDF.
- 05Save the file.
Oracle advises organizing extracted information by record type. Notes on entity records such as customers and vendors come out through a separate System Note or User Note search. If a search takes a long time to run, NetSuite suggests persisting the search results before exporting to CSV.
Route 3 of 3
SuiteAnalytics Connect
A user on the Data Integrator role or a custom role, in an account with the Connect service.
- 01Assign the connecting user the Data Integrator role or a custom role that can see the records you need.
- 02Set up token-based authentication for that user, which the Data Integrator role requires.
- 03Connect an external application through the ODBC, JDBC or ADO.NET driver, using the NetSuite2.com data source.
- 04Query the record types with SuiteQL and write the results out from your application.
The Connect service enforces role-based access: users can query only the data their roles and permissions allow. Oracle also lists SuiteTalk SOAP web services as a route for programs that query record data, and exporting report results as CSV files for financial data.
What comes out
The Full CSV Export downloads one ZIP file. Inside are CSV files named for the lists they came from; Oracle's example is custjobs.csv. For record lists such as Customer and Item, the export writes the data according to the view you have selected for each list, so the columns you get depend on that view.
Saved search exports produce one file per search in CSV, XLSX or PDF. The columns are the fields chosen on the Results subtab, in the order chosen. Oracle notes that all of these approaches can preserve the relational aspects of the data if you export the Internal ID with each row. That ID is what joins a transaction file to a customer file afterward.
For financial data, Oracle says reports can be more useful than saved searches because totals are simpler to match. Its suggested layout puts purchase transactions in one spreadsheet and sales transactions in another, using the Transaction Detail report customized to filter by transaction type and to include columns such as transaction number and memo.
| In the export | What it contains |
|---|---|
| Customers, Contacts, Vendors, Partners, Employees, Other Names | The entity lists included in the Full CSV Export, written according to the selected list view. |
| Items, Ship Items, Expense Categories | Product, shipping and expense lists. |
| Accounting Lists, Classes, Departments | The accounting structure and classification lists. |
| Transaction Detail Report, Memorized Transactions | Transaction lines as the report presents them, plus memorized transactions. |
| Notes, Tasks, Solutions, Topics | CRM and support content held on records. |
| Saved Reports | Reports that the exporting Administrator owns. |
| Saved search file | One CSV, XLSX or PDF per search, with the columns chosen on the Results subtab. |
Before you rely on it
Limits and gotchas.
- The Full CSV Export does not export all data. Anything outside its listed lists and reports has to come from saved searches, reports, SuiteAnalytics Connect or web services.
- The export can time out, and a failing saved search can cause it to fail.
- Only saved reports that you own are included in the Full CSV Export.
- Excel treats long numeric sequences in a CSV as numbers. Values with more than 16 digits lose precision or are truncated. Oracle's workaround is to open CSV files with the Text Import Wizard and set the column to Text, or to use a suite that always shows an import wizard.
- Popup searches and their results pages have no Export option.
- Reports can run for a long time. Oracle suggests date range filters and running the same report several times for different ranges.
- Credit card information is not accessible through the NetSuite2.com data source, even for the Data Integrator role, and Global Permissions set to None override that role.
Handle with care
Personal data inside a NetSuite export.
- Contact and customer lists, which name individuals and their details.
- The employee list.
- Vendor, partner and other name lists, which include sole traders and named contacts.
- Address fields on the customer record: addressee, address lines, city, state, zip code and country are all exportable from search results.
- Notes and tasks, which are free text written about customers, vendors and staff.
- Transaction detail, which ties named customers and vendors to amounts and dates.
An export is a copy outside the access controls of NetSuite. Store it encrypted, limit who can open it and delete working copies when you are done. The personal data scrubber removes common identifiers in your browser before a file is shared.
What the export can be worth
Outrich Data is a direct buyer of de-identified company data for AI training, from companies with 50 or more employees. We never connect to your NetSuite account: your team runs the export above and removes what is out of scope. Not every export qualifies, and a rights review comes before any offer.
Questions
Exporting from NetSuite: common questions.
Does NetSuite's Full CSV Export export everything?
Who can run the Full CSV Export in NetSuite?
How do I keep NetSuite records linked after exporting them?
Why do long numbers look wrong when I open a NetSuite CSV in Excel?
Sources
- Oracle NetSuite: Exporting Selected Lists and Reports as CSV Files (CSV Export)2026-11-17
- Oracle NetSuite: Extracting Data from NetSuite2026-11-17
- Oracle NetSuite: Exporting Search Results2026-11-17
- Oracle NetSuite: Role and Permission Considerations for NetSuite2.com2026-11-17
- Oracle NetSuite: NetSuite2.com Data Source2026-11-17
Steps were checked against NetSuite documentation on 2026-11-17. Vendors change menus, plans and limits, so confirm against the linked pages. NetSuite is a trademark of its owner. Outrich Data is not affiliated with NetSuite.
Find out if your data qualifies.
Eleven questions, about five minutes, no call required. You get an answer on screen and a written follow-up.