Skip to content
Outrich Data

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.

  1. 01Go to Setup > Import/Export > Export Tasks > Full CSV Export.
  2. 02Click Submit and wait for the progress bar to finish.
  3. 03In the File Download window, select Save this file to disk and then OK.
  4. 04In the Save As window, enter a file name with the extension ZIP.
  5. 05Click Save.
  6. 06Open the ZIP file to see the generated CSV files.
  7. 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.

  1. 01Create or open a search for one record type, such as contact, customer, vendor or transaction.
  2. 02On the Results subtab, select the fields to export and their order, and add Internal ID as a results column.
  3. 03Click Submit to run the search.
  4. 04On the results page, click Export - CSV, Export - Microsoft Excel for an XLSX file, or Export - PDF.
  5. 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.

  1. 01Assign the connecting user the Data Integrator role or a custom role that can see the records you need.
  2. 02Set up token-based authentication for that user, which the Data Integrator role requires.
  3. 03Connect an external application through the ODBC, JDBC or ADO.NET driver, using the NetSuite2.com data source.
  4. 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 exportWhat it contains
Customers, Contacts, Vendors, Partners, Employees, Other NamesThe entity lists included in the Full CSV Export, written according to the selected list view.
Items, Ship Items, Expense CategoriesProduct, shipping and expense lists.
Accounting Lists, Classes, DepartmentsThe accounting structure and classification lists.
Transaction Detail Report, Memorized TransactionsTransaction lines as the report presents them, plus memorized transactions.
Notes, Tasks, Solutions, TopicsCRM and support content held on records.
Saved ReportsReports that the exporting Administrator owns.
Saved search fileOne 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?
No. Oracle's help page says the Full CSV Export option does not currently export all data as CSV files. It covers a listed set of lists and reports, including customers, contacts, vendors, employees, items, notes, tasks and the Transaction Detail Report.
Who can run the Full CSV Export in NetSuite?
Only users who have the Administrator role. Other users can still export search results if they hold the Export Lists and Perform Search permissions.
How do I keep NetSuite records linked after exporting them?
Add Internal ID as a results column in every search or report you export. Oracle states that all of its extraction approaches can preserve the relational aspects of the data when the Internal ID is exported with each row.
Why do long numbers look wrong when I open a NetSuite CSV in Excel?
Excel reads long numeric sequences as numbers and shows them in scientific notation, losing digits past the sixteenth. Open the file through Excel's Text Import Wizard and set the column format to Text.

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.

esc