Importing from a Microsoft Excel File

FileMaker Pro has some special capabilities for importing data from Microsoft Excel documents. FileMaker is aware of multiple worksheets within an Excel document and of any named ranges (groups of cells that have been given specific names). When you select an Excel file for import, if it contains multiple worksheets or named ranges, FileMaker prompts you to select either a worksheet or a named range as the source for the data, as shown in Figure 22.8.

Figure 22.8. When you import data into FileMaker from an Excel document, you can import from a specific tab or a named Excel range.