How to Export Data From NetSuite: 5 Methods Compared

You can export data from NetSuite five main ways: the Full CSV Export task, saved search and report exports, web services or RESTlets, SuiteAnalytics Connect, and a scheduled script that writes a file and sends it by SFTP. Manual exports suit one-off needs. Anything recurring, or anything that feeds another system, needs a script, an API, or a read-only reporting connection.

Part of NetSuite Notes. NetSuite in Practice: Straight answers to real NetSuite questions.

Most people start with the Export button, and for a one-time pull it is the right tool. The trouble starts when the export becomes a weekly chore, or when another system needs the data and nobody wants to be the person who clicks Export every Monday.

Oracle's documentation lists several routes out of NetSuite. They differ in more than technique. They differ in who starts them, which way the data moves, and who has to maintain them.

What are the ways to export data from NetSuite?

There are five main ones. Oracle's page on extracting data from NetSuite covers the first four, and the N/sftp module covers the fifth.

How do you export a saved search to CSV?

Run the search and click the CSV export option on the results page. Oracle says you need the Export Lists and Perform Search permissions to see the export button, and that you can also export to PDF or to an Excel file. Add the Internal ID as a results column if you want the exported rows to keep their relationships to NetSuite records. If a search takes a long time to run, Oracle suggests persisting its results, and every export is recorded in the saved search's execution log. Oracle's page on exporting search results has the details.

For financial data, Oracle says reports can be more useful than saved searches because they make it easier to match totals. It suggests customizing the Transaction Detail report to filter by transaction type and adding columns such as transaction number and memo, and setting date ranges so a report does not run too long.

When should you use web services or a RESTlet instead?

When another application needs to ask NetSuite for data, or send data back, without a person in the middle. Oracle describes SOAP web services as a way to query record data from a program you write, and its REST web services expose NetSuite records over HTTP. A RESTlet is a SuiteScript that answers requests, including requests for file data, which is Oracle's suggested route when an outside system has to start a transfer and cannot use SFTP.

All of these need a developer, authentication setup, and someone to maintain them. They fit best when the other system can call an API and you want the data to move whenever something happens, not on a nightly timer.

What is SuiteAnalytics Connect, and when is it the right choice?

SuiteAnalytics Connect lets reporting tools read NetSuite data through ODBC, JDBC, or ADO.NET drivers. Oracle's overview of SuiteAnalytics Connect describes it as a read-only way to get NetSuite data, which means you cannot update NetSuite through it, and Oracle's extraction page notes that ODBC access is an additional service with an associated fee.

It is the right choice when a BI tool or a data warehouse needs to query NetSuite directly and you are comfortable with the cost. It is the wrong choice when the data has to flow back in.

How do you send NetSuite data to another system automatically?

With a scheduled script. The script runs a saved search, builds a file with the N/file module, and uses the N/sftp module to deliver it to an SFTP server. Oracle states that NetSuite provides no SFTP server functionality and that all SFTP transfers to or from NetSuite must originate from SuiteScript, so the script is not optional. Oracle's N/sftp module page lists what the module can do: upload, download, list, move, and remove files.

How do you choose between them?

Four questions settle it for most cases.

• Who starts the transfer? If a person is fine, use an export. If a schedule or another application has to, you need a script or an API.
• Which way does data move? Out only, use a script, an export, or Connect. Both ways, use web services or a RESTlet.
• How often, and how much? A one-time pull and a nightly feed are different projects, even when the data is the same.
• Who maintains it? Every script and API connection is code your team owns. A growing pile of custom code is a cost of its own.

How do you keep exported data usable?

Include the Internal ID on every row. Oracle says each of these approaches can preserve the relational aspects of your data if you export the Internal ID with each row, which is what lets you tie a spreadsheet row back to a customer, vendor, or transaction later. Organize CRM extracts by record type, since saved searches are organized that way, and pull notes through a System Note or User Note search when you need them.

If exports have turned into a standing spreadsheet routine, the real cost of spreadsheet workarounds is worth a read.

Frequently Asked Questions

How do you export data from NetSuite to Excel?

Run a saved search or report and use the export option on the results page. Oracle lists CSV, PDF, and Microsoft Excel (XLSX) as export formats for most search results. You need the Export Lists and Perform Search permissions to see the export button. Add the Internal ID as a column if you want to keep record relationships.

Can NetSuite export data automatically on a schedule?

Yes, with a scheduled script. The script runs a saved search, creates a file with the N/file module, and can deliver it with the N/sftp module. Exporting from the results page is a manual step, so anything recurring that must run unattended needs a script or an outside system calling NetSuite.

What is the difference between a CSV export and SuiteAnalytics Connect?

A CSV export produces a file that a person downloads. SuiteAnalytics Connect lets reporting tools query NetSuite data directly through ODBC, JDBC, or ADO.NET drivers. Oracle describes Connect as read only, and notes that ODBC access is an additional service with an associated fee.

Does NetSuite have an API?

Yes. NetSuite offers SOAP web services and REST web services for querying and working with records from an outside application. RESTlets, which are SuiteScripts that respond to requests, are another route. Which one fits depends on what the other system supports and who will maintain the connection.

How do you export saved search results with record IDs?

Add the Internal ID as a column on the search's Results subtab before you export. Oracle says all of its extraction approaches can preserve the relational aspects of your data when the Internal ID is exported with each row. That lets you match exported rows back to NetSuite records later.

Is SuiteAnalytics Connect free?

Oracle's documentation says ODBC access is an additional service with an associated fee, so it should be priced before you plan around it. Connect is also read only, which means it can read NetSuite data for reporting but cannot be used to update it.

Can an outside system pull files from NetSuite by SFTP?

No. Oracle states that NetSuite does not provide SFTP server functionality, and that all SFTP transfers to or from NetSuite must originate from SuiteScript. If an outside system has to start the transfer, Oracle points to RESTlets or SOAP web services instead.

Need data to leave NetSuite on a schedule?

The right export method is usually the lightest one that still runs without a person remembering to do it. Start there, and move to scripts or APIs only when a schedule or another system forces the issue.

TVG's NetSuite Development team builds scheduled exports, integrations, and custom searches, and NetSuite Support keeps them running after go-live. If you have data that needs to leave NetSuite on a schedule, we can help you pick the route.