In the spreadsheet make sure you have column headers. Then save it as a CSV file. You can then import the CSV into ACT! and map to correct fields.
How to Import Contact Data From a Text Delimited File (*.TXT or *.CSV) into an ACT! Database