How to Export All NetSuite Data

I dread to think why you would need to do this. Either you are making the terrible decision of moving away from NetSuite or you need to urgently save your data before some awful event takes place that destroys your business. Depending on which of these is true the approach may be different. Luckily I can talk you through both.

The quickest way to export all data from NetSuite

If an awful event is about to take place that is going to destroy your business then speed is of the essence. Assuming you have an administrator role you can navigate to Setup > Import/Export > Full CSV Export. NetSuite will then provide you with all the details of what you are about to do. If you are happy with this then click Submit.

The warning given before exporting all NetSuite data

After submitting, a progress bar will appear. When this progress bar is full your download is complete. This will give you a zipped file of CSVs for all record types and all data from them.

My comments above about destroying your business are of course in jest and there are some real world scenarios in which this is useful. You may be required to take a manual data backup periodically and the data is not going to be used unless in case of emergency. This is the quickest and least cumbersome way to extract that data.

You may also choose to do this complete download after you have migrated away from NetSuite to keep on file in case there is a fear that anything has been forgotten.

For most use cases this is an unnecessarily large dump so think about whether this is what you need.

Here we are discussing a particularly intense data dump so expect it to take it’s time. If you are experiencing long delays for everyday processes however, you may want to look at some ways to speed up NetSuite.

The best way to export all data from NetSuite

If you are exporting for the purpose of analysis or to import elsewhere you are much better off doing more targeted searches. Just run a Saved Search and add all fields if necessary. You can use Add Multiple on the results tab and then select all fields using the Shift key.

Once you have submitted and generated your data you can export either as a CSV or an Excel file using the these two icons.

This is the way I would suggest. If you are migrating to a new system you will be importing data on a record by record basis anyway so there is no need for the no holds barred data dump.

If you are not comfortable creating your own Saved Searches for this purpose you can also just export direct from the record list.

Navigate to your list of customers for example. All roles vary but in an Administrator role you can head to Lists > Relationships > Customers. Click on Customers and you will come to a list of all customers. Check there are no filters set in the filters region at the top of the search. You can check the box for Show Inactives to show all Active and Inactive customers together. If you are happy with the data being displayed you should have those same two icons at the top left of the results for exporting to CSV or Excel. Click the relevant icon and your download will begin.

You can use this approach on all Lists which would include all Entity types and all Transaction types.

Not all data types have their own List page such as the Login Audit Trail or Sent Emails. None of this information is hidden from you though. You just need to find out where it is kept or maybe perform a search.

If you have a really large and complex system there are also companies that specialize in getting your full data off NetSuite in a manageable and useable form. Before choosing this though consider the above two options as you really should have the ability to do this yourself.

Protect against data breaches by using NetSuite’s two factor authentication for roles with access to sensitive data.

As always, if you have anything to add to this or have a more specific question around the export of data from NetSuite then get in touch via the Contact page. We would love to hear from you.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *