Hmmm, Excel doesn't actually have records. Hopefully you mean that your excel file has 15 columns and 47 rows as that's the arrangement needed to produce 47 records and 15 fields in each record in FileMaker when you import the data.
There are a lot of different options you can select when using FileMaker Import Records tool and we can't tell which ones you selected.
"I also see a layout built by FMK showing the excel table"
Suggests that you used the "new table" option instead of importing into an existing table in the contact manager. Presumably, you should import from Excel into the Contact Management Table (not the notes table). To do this, you should have done the following:
- Open database and select any layout based on the Contact Management Table. The very first layout will work for this.
- Select Import Records
- Select your Excel File type in the Files of Type: drop down.
- Select your file for import and click Open
- Select the worksheet or named range from which you want to import (often you can just click OK here).
- Drag target fields up and down to correctly align them with the columns in your spreadsheet
- Click "don't import first row" if the first row contains the column names
- Click Import
- In the small Import Options dialog that pops up, you must click the Perform auto-enter options checkbox so that each newly imported record is assigned a ContactID number or your imported data won't work correctly when you try to use this database.