In order to correctly import data using a spreadsheet as your data source, there are some critical format rules that need to be followed in otder for the import to work correctly.
Please see here the sample file which you can use as a guide to assist with formatting the document correctly.