Tips for Using Numbers in CSV Files

Be careful when entering numbers into a CSV file. Many spreadsheet programs do not allow 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, so these 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.