Import and Update NetSuite Customers and Vendors from Excel
Create and update NetSuite customers, vendors, contacts, employees and CRM records from Excel, in bulk.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Record Edit opens a menu with Budget, Journal Entry, Intercompany Journal Entry and Bulk Records, and the Bulk Records submenu lists the saved templates by record type. Callout: Record Edit › Bulk Records › Opportunities. Opportunities is clicked. Callout: A Bulk Records sheet for Opportunities. An Opportunities sheet is inserted, with body field columns (Date Created, Opportunity #, Company, status, Probability), item line columns (Line ID, Item, Quantity, Rate, Price Level) and a Status column. Start is set to 6/1/2026. Callout: Set the date range to download. End is set to 7/31/2026, filtering on Date Created. Download Opportunities is pointed at. Callout: Download pulls the records in. The banner reads Download in progress, then Download complete, 7 records. Callout: Every matching record, ready to edit. The sheet holds 7 opportunities, OPP68 to OPP74, with their 10 item lines. The quantity of Welding Regulator Gauge on OPP70 changes from 5 to 3. Callout: Edit them like any Excel data. The quantity of 25 HP Rotary Vacuum Pump on OPP73 changes from 2 to 1, and SAF200 on OPP68 from 20 to 15. Add/Edit Opportunities is pointed at. Callout: Add/Edit uploads the changes. The banner counts processing 0 of 3 to 3 of 3, then reads Upload complete, 3 updated. Callout: Each row reports what happened. The Status column reads Updated Opportunity OPP70 on both of its lines, Updated Opportunity OPP73 and Updated Opportunity OPP68, where NetSuite set the SAF200 rate to 460; the other rows read Skipped (no changes). Pointing at Updated Opportunity OPP68 shows its link to the record in NetSuite. Callout: Each row links to its record.
Customers, vendors and CRM in bulk, from Excel
Master data drifts. Terms change, sales reps move, contact details go stale, and a new subsidiary arrives with a list of vendors to load. Bulk Records puts these records in an Excel sheet, one row per record with the fields your template includes, so you can review and change them in bulk and upload the result to NetSuite. Templates can include your custom fields, and if NetSuite rejects a row, a note on the cell that caused it explains why.
Update terms, reps and categories
Download the customers you need, change payment terms, sales rep or category with a fill-down or a lookup table, and upload. Only the records you changed are sent.
Load vendors for a new subsidiary
Paste the vendor list into the sheet as new rows. Rows without an Internal ID are created as new vendors, and anything NetSuite rejects is noted on the cell that caused it.
Keep addresses and contacts current
Customer addresses come down as address book lines, one row per address, so you can correct or add them in place. Contacts and their details update the same way.
Log CRM activity in bulk
Create or update tasks, phone calls, events, campaign responses and support cases from a sheet, for example after a trade show or a calling campaign.
Customers, vendors and CRM: every supported record type
22 record types that Bulk Records supports. Records with a line sublist are tagged with it.
Entities
- Contact
- CustomerLines: Address book
- Customer Subsidiary Relationship
- Employee
- Job
- Other Name
- Partner
- Resource Group
- Vendor
- Vendor Subsidiary Relationship
CRM
- Calendar Event
- Campaign
- Campaign Response
- Competitor
- Email Template
- Issue
- Message
- Phone Call
- Project Task
- Support Case
- Task
- Topic
Instead of a CSV import
Update customer, vendor and contact records without exporting, editing and re-importing a CSV: download them, change them in Excel and upload. Once a record is uploaded, its row links straight to that record in NetSuite, so checking it takes one click.
Bulk Records: a simpler alternative to CSV importsCustomers, vendors and CRM in Bulk Records: FAQ
- QCan I import customers into NetSuite from Excel?
- Yes. Add a row for each new customer, leaving Internal ID blank, and upload. Bulk Records creates the customers in NetSuite and flags any value NetSuite rejects on its cell.
- QCan I update existing vendors in bulk?
- Yes. Download the vendors you want to change, edit them in the sheet and upload. A row with an Internal ID updates that vendor, and only changed records are sent.
- QAre custom fields included?
- Yes. Templates can include your custom fields as columns, so they download and upload with the rest of the record.
- QCan I update customer addresses?
- Yes. Customer addresses download as address book lines, one row per address. Edit a row to change that address, or add a row to add one.
- QWhich CRM records are supported?
- Tasks, phone calls, calendar events, campaigns, campaign responses, support cases, issues, topics, email templates, messages, competitors and project tasks.
Try Bulk Records with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.