The import data function of Excel needs to import CSV (comma seperated values) files and gets confused by ordinary Excel (.xls) files. To save your spreadsheet as a CSV file click on File>SaveAs, then select the Save as type: CSV as below.

Once saved follow the import data instructions to use the CSV file.
If you have generated an excel file with the right columns you could copy and paste the data into the import data page.