Introduction

NetSuite's CSV import feature is extremely powerful for creating records in bulk. However, there is a 10,000 line-item limit per CSV. This limitation can be overcome by separating larger CSVs into smaller files and running them individually. While this process can be performed manually, this method is quicker.

Process

1. Download this CSV splitter from CNET. Of the several CSV splitters I have tried, this one is the easiest to use.

2. Upload your original file to the CSV splitter and input the following settings:

The first row will always contain column headers for a NetSuite import file. Additionally, this header must be included in each new package in order for the files to be importable. Finally, note the number of rows per package should be set to 9,999, and not 10,000. If set to 10,000, this program will generate the first package in the series at 10,000 line items including the header, and then generate 10,001 line items for every subsequent package.

3. Click 'Execute.' Once the program has run, you'll find the segmented files stored in the same location as the original file:

While the '.001 File' type appears incompatible with NetSuite, these are CSV files that can be successfully read by and uploaded into NetSuite:

Page Last Updated: 5/29/24