Take your excel spreadsheet, and copy only the contact rows into a new csv file. Or delete all of the empty rows at the bottom. The CRM fails on import as it thinks it's trying to import contacts on blank rows.
Hit import contacts
Select contacts and hit next. Add the csv. Hit next and map the columns in the excel sheet to the fields in the crm.
4. Consent and start the import
5. Go to bulk actions and hit show stats. This will tell you how many contacts were imported. If you have problems with your sheet, you'll see the errors here. Here you can see an error on line 124, as the email is invalid.
6. Now we want to delete, and re-import until there are no errors remaining. Go to the three dots next to the import, and click show imported.
7. Select all contacts from this import, and delete them.
8. Repeat the process until there are no errors.