ANS-1701 · CSV IMPORT & DATA MIGRATION
How to Resolve Special Character Display Issues in NetSuite CSV Imports
Ensure proper character encoding and delimiter settings are configured in NetSuite's Import Assistant to correctly display special characters from CSV files.
Short answer
To resolve special character display issues during CSV imports in NetSuite, utilize the Import Assistant. Crucially, set the 'Choose Import Character Encoding' to 'Unicode (UTF-8)' and select 'Comma' as the 'Choose CSV Column Delimiter'. This configuration ensures that all characters, including French accents, are correctly processed and displayed.
Scenario
Users importing CSV files into NetSuite may encounter issues where special characters, such as French accents or other non-ASCII characters, do not display correctly after the import. Instead, these characters might appear as garbled text or question marks within NetSuite records. This problem commonly arises from a mismatch in character encoding settings between the source CSV file and the NetSuite import process.
Solution
To ensure special characters are correctly imported and displayed in NetSuite, follow these steps using the NetSuite Import Assistant:
Access the NetSuite Import Assistant by navigating to
Setup > Import/Export > Import CSV Records.During the import process, when prompted to 'Choose Import Character Encoding', select
Unicode (UTF-8). This is a critical step for ensuring special characters are correctly interpreted.When prompted to 'Choose CSV Column Delimiter', select
Comma.Proceed with the remaining steps of the Import Assistant to complete the CSV import.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support