Try using import records instead of drag and drop. This will give you options that drag and drop does not give you and that may, in turn get this to work for you.
You can create a fileMaker file first, then use import records with the New table option to create a new table in the file or you can create a file with a field for every column and then use import records and map each column of data to a specific field. (Sounds like these should be text fields in FileMaker.
OK, thanks. I wasn't sure if this was a "known problem" for some types of spreadsheets. The FMP demo makes it look so easy that I was surprised when a relatively simple spreadsheet with only a hundred or so rows totally broke the drag and drop method.
It should be very easy and I have no idea why it only shows the first letter in the field instead of the entire cell contents. You may want to click in the fields and make sure that the data isn't really there, but not showing due to field size or the presence of some return characters...
I suggested the alternate approaches as ways to see if they will work when the drag and drop conversion process does not. If one of these alternatives work, it may give us a clue as to why drag and drop did not.
Sounds good. I sort of like the manual approach anyway since it lets me align the fields to the spreadsheet myself.