Special character CSV import

For CSV import, it is mandatory that there should not be any special characters in the file. When we try to import csv files with special characters, the import page will show an error message like in the below screenshot: 

For importing data with special characters, first prepare the text file for import. For preparing the text file, follow the below steps: 

1. Install “Notepad++” in your system. 

2. Prepare CSV file which includes the data to import. 

3. Open the CSV file in “Notepad++”. 

4. In “Encoding”, select the “Convert to UTF-8″ option. 

5. Make sure that the data displayed is separated with coma. 

6. Save as “.txt” file. 

Once the text file is prepared, then import the file into NetSuite. To import the file, 

1. Go to, Set up> Import/Export> Import CSV Record. 

2. Select the import type and record type. 

3. Select the character encoding as “Unicode UTF-8″. 

4. Select the prepared text file and click next. 

5. Select the appropriate data handling option and click next. 

6. Mapp the CSV file fields with the NetSuite field. Click next. 

7. Provide a name for the CSV import and click “Save & Run”. 

8. Check the job status.