How to Import Multiple Values into a Single NetSuite Field via CSV

The key to successfully importing multiple values into a NetSuite multi-select field via CSV is to use pipe-delimited internal IDs or values. This method ensures that NetSuite correctly parses and assigns all specified selections to the target record.

Consider the following examples for a contact record's multi-select field:

1. Using Pipe-Delimited Internal IDs (without spaces):

   When importing internal IDs, ensure no spaces are present between the ID and the pipe delimiter.

internal id,Category (mutli-select standard field)
    10150,3|53

1. Using Pipe-Delimited Values (without spaces):

   When importing actual values, ensure no spaces are present between the value and the pipe delimiter.

internal id,Categories
    10150,BOR|CGA

While official NetSuite documentation suggests including a space between each value and its delimiter for multi-select fields in CSV imports, successful imports often depend on precise formatting to avoid issues caused by unintended extra spaces. It is generally recommended to test both formats if encountering issues, prioritizing the no-space approach for consistency unless specific field configurations require otherwise.