Keep the following points in mind when you are creating your spreadsheet.
If you are not using attribute fields each variable name must be unique.
If you are using attribute fields to define product groupings within a hierarchy, each variable name within a given group must be unique.
If you use zeroes to pad the data prior to an item's availability, make sure that “Ignore leading zeros” is selected on the Formats tab of the Settings Options dialog box.