Populate Data
Data may be entered directly in the template spreadsheet, or the template can be used as a guide for creating a supplier import spreadsheet of a different type.
Formatting Issues
The user import spreadsheet has these formatting requirements:
The values in the spreadsheet header row must not be deleted
All cells in the spreadsheet must have a Number Format of Text before being uploaded.
If you use the Replace feature in Excel, be aware that it may not maintain the required cell formatting. Testing has shown that cells formatted as text become general format after using Replace. If the cells are not formatted as text, the import will fail.
If you use this feature, always verify the cell formatting when done. If necessary, select the appropriate cells and change the formatting.
