When you import excel files into filemaker, filemaker expects each row to be a different record and each column to be mapped to a different field. You have control over which field in filemaker will recieve the imported data from a given column. You can also tell filemaker to ignore the first row as it often contains column headings.
If your spreadsheet doesn't conform to that format, then you have two basic choices:
- Manipulate the spreadsheet prior to import--you can swap columns for rows or specify a sub-range to isolate a specific block of cells--to name just 2 examples. There are options for an xml import using an "XLST grammer" I believe that enable even more sophistication here if I understand some posts that I have read here.
- Import into an intermediary table and use a script to move the data from this table to it's final destination.
Chose the method of importing everything in to a new table and then using a script to extract the data.