I have been trying to import contacts from an excel spreadsheet and they are
not appearing in contacts after going through the process.

I have checked for troubleshooting on line and confirmed that the show this
folder as an email Address Book has been checked in Contacts Properties.

The fields are all mapping fine, the data just isn't filling in.