Tips for Using Numbers in CSV Files

Be careful when entering numbers into a CSV file. Many spreadsheet programs do not permit or do not show leading zeros by default, which can be a problem if your data needs those leading zeros. You can work around this problem 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 put 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

General Notices