When I attempt to do any excel based import into Nexternal (Products, Inventory, Customers, etc.), I keep receiving error message, "Line X: Y is blank" when in fact there is data in that field and not blank. How do I successfully import the file and avoid this false error message?
All data needs to be in the proper format (text, integer, etc.) before importing. Prefixing numeric values with a ' (single quote) forces Excel to read them as text.