Tips for Using Numbers in CSV Files
Note the numbering format when you enter numbers in a CSV file. By default, many spreadsheet programs do not permit or do not show leading zeros, which can be a problem if your data needs those leading zeros. You can resolve this issue by formatting the cells in the spreadsheet program as text rather than numbers.
If you plan to import a CSV file created in Excel, be aware that Excel uses scientific notation to save long numbers to CSV files. Long numbers will be imported into NetSuite in rounded form, resulting in incorrect values. You can work around this issue by formatting long numbers such as UPC codes as “Text” in Excel before doing a CSV import.
Commas Used as Decimal Marks
If you use commas as decimal marks in your CSV files, you should specify this choice in the Advanced Import Options of the Import Assistant. If appropriate, you can make it the default format for all CSV imports. To learn how to do that, see General Personal Preferences and Setting CSV Import Preferences. If you want to set this format as the default for a subsidiary, see Editing Subsidiary Records.
If the decimal mark is the same character that is used as the CSV column separator, you should add quotation marks around any floating point numbers in the CSV file you import. To learn more, see Avoiding Errors for Commas and Other Delimiter Symbols within CSV File Fields.
Related Topics
- Tips for Successful CSV Imports
- Sublist Data Import
- Importing Subrecord Data
- Supported Subrecord Imports
- Effects of Auto-Generated Numbers during Imports
- General CSV File Conventions
- Boolean Values in CSV Files
- Avoiding Errors for Commas and Other Delimiter Symbols within CSV File Fields
- Delimiters for Hierarchical and Multi-Select Fields
- Name References
- State and Province Names for CSV Import
- Country Names for CSV Import