How to export your NetSuite data to CSV

NetSuite is the most common cloud ERP we see people leaving, and it is well-behaved about it: three CSV export routes, all self-serve, no tickets to Oracle. The only real decisions are which route to use and how much of the catalogue is still alive.

1.Pin the cutover before you export anything

On-hand quantities are only true at an instant. Export stock on Monday, go live on Friday, and you have imported a week-old picture — every discrepancy afterwards gets blamed on the new system. Agree a freeze point, pull quantities after it, and either key the gap in by hand or reconcile with a cycle count on day one. Both are fine; drifting silently is not.

Whatever else you take, get these five things:

1. Item master, with the inactive flag included so you can filter rather than lose records.
2. On-hand quantity per item, as of a stated date and time.
3. Average cost per item — not last purchase price, if you can get both.
4. Customer and vendor master, with addresses and terms.
5. Open purchase and sales orders, if the cutover isn't on a quiet day.

2.Full CSV Export — the fastest first look

There are three routes out, and they are worth trying in the order they appear here. This one is the quickest: a single task that hands back Items, Customers and Vendors together.

1. Sign in as a user with the Administrator role. This feature is Administrator-only.
2. Go to Setup → Import/Export → Export Tasks → Full CSV Export.
3. Select Items, Customers and Vendors.
4. The result downloads as a ZIP of CSV files.

That catch is not a NetSuite quirk — it is what every export-what-is-on-screen route does. If Business Central is the other system in your decision, its guide describes the same split: Share → Open in Excel hands back the visible columns, while a Configuration Package exports whole tables with real column headers.

3.Saved search — the CSV export worth building

This is the recommended route, and the one to use when you want exactly the columns in §5 and nothing else.

1. Lists → Search → Saved Searches → New, and choose Item as the record type.
2. On the Results tab, add the fields that map to the columns in §5.
3. On Criteria, filter to the item types you actually stock, and decide explicitly whether inactive items are in or out. Don't accept the default.
4. Save & Run, then Export → CSV from the results page.
5. Repeat with record type Customer, then Vendor.

Can it run automatically, on a schedule?

Yes — a saved search can send itself. Its Email subtab carries a Send Emails According to Schedule option, the Schedule subtab sets the interval, and the results can go out as an attached CSV rather than embedded in the message body. Oracle documents a truncation on that path: results above 5 MB or more than 10,000 rows are cut off before the email is sent.

Which is why it is the wrong tool for the job you are here for. A migration wants one export, taken after the freeze point in §1 — not a file that arrives every morning and disagrees with the one before it. It is worth knowing about for the opposite reason: if what you actually need is a recurring feed into a spreadsheet or a BI tool, that is a reporting problem, and it does not require leaving NetSuite at all.

4.SuiteAnalytics Connect — large accounts only

ODBC, JDBC and ADO.NET access to NetSuite data — the most complete option available. It is also a paid add-on you must already own, and it times out on large tables, so pull in chunks. Only worth arranging when the catalogue is big enough that saved-search exports are genuinely failing. For most SMB migrations that never happens.

If you are weighing NetSuite against an on-premises system in the same decision, the equivalent route there is a direct database connection — the SAP Business One guide covers what that looks like when the tables are yours to query.

5.Field mapping into AegisSwift

6.Gotchas

Excel silently destroys long numbers

Internal IDs and UPCs of 16+ digits open in scientific notation and lose their tail. There is no warning and the damage is permanent in that file. Import the CSV through Excel's Text Import Wizard with those columns set to Text, or open it in LibreOffice. This is the single most common way a NetSuite export arrives broken.

Multi-location changes what "quantity" means

If you run several locations, quantity comes back per location. Decide up front whether AegisSwift launches with one consolidated balance or per-location stock, and sum or split accordingly — it is much cheaper to decide now than to unpick later.

One broken saved search fails the whole Full CSV Export

If the export errors out, look for a failing saved search somewhere in the account before assuming it's a permissions problem. The error rarely points at the real culprit.

Matrix and kit items expand into parent plus child records

Confirm which level you actually stock before importing both. Importing parents and children together is how a 4,000-item catalogue becomes 11,000 items.

7.What happens on our side

You upload two spreadsheets — items, and parties (customers and vendors) — and the importers match on sku and name, so a re-import updates rather than duplicates. Expect to import twice: once to see what breaks, once for real.

A NetSuite extract arrives in better shape than most files we see, because it came out of a schema. What it still needs is a decision about what one row means once matrix items and multi-location quantities are in front of you — the clean-up pass described here is the same work, and worth reading before you import rather than after.

One accounting note. AegisSwift costs inventory on a moving average. Your opening cost column seeds that basis, which is why Average Cost is the better column to bring than Last Purchase Price. If your books use a different method the two won't agree penny-for-penny after the first receipt — worth telling your accountant before go-live, not after.

8.Questions people ask

Can I export my own data out of NetSuite?

Yes, by more than one route, and none of them need Oracle. Full CSV Export needs the Administrator role; saved searches give you precise control over the columns.

Why does my export have the wrong columns?

Because Full CSV Export follows the currently selected list view rather than the full record. Use a saved search and choose the columns explicitly.

Can NetSuite export to CSV automatically, on a schedule?

Yes, though not as a migration tool. A saved search has an Email subtab carrying a Send Emails According to Schedule option, and a Schedule subtab that sets the interval; the results can go out as an attached CSV rather than embedded in the message. Oracle documents a truncation above 5 MB or 10,000 rows, so treat it as a reporting mechanism rather than a way to move a catalogue. For a migration you want one export taken after your freeze point, not a file that arrives every morning disagreeing with the last one.

How long does this take?

The exports are minutes. Building three saved searches and agreeing what counts as active is the real work — budget an afternoon, and expect to run the import twice.