one way is to export (as .mer) one bogus record from FileMaker. This is .csv with the column headers as the field names in the first row. Rename the document with the .csv extension instead of the .mer extension and open with Excel. Save this as .xslx and you then have a "template-for-import".
keep in mind that some odd naming for fields can be not so fine in Excel!
the "matching names" option in the Import dialog will work if all is well.
Thank you for your post!
beverly made a great suggestion.
I am also going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more feedback on this topic!
If you are going to import the contacts from your spreadsheet into Filemaker, the Import Records dialog lets you see both the column (Excel) and Field (FileMaker) names and you can drag things up and down to align them. You can examine the data about to be imported to double check that you have aligned the columns to fields correctly for import.
1 of 1 people found this helpful
Another suggestion! I've stopped doing that since we have "matching names" on import.
Sent from miPhone
I want to thank you for moving my post to the appropriate forum. In another comment, I misapplied the moving to Beverly, who has posted in her own helpful way.
Nevertheless, I wanted to give credit where it's due.