Converting a data file to a new FileMaker Pro file
You can convert a data file from another application into a new FileMaker Pro file. FileMaker Pro imports the data and creates a new FileMaker Pro file. This converted FileMaker Pro file will contain:
 •
 •
 •
Converted field names if they are available in the file or source you convert. Otherwise, field names are generic: f1, f2, f3, and so on. (Field names convert from Bento, Microsoft Excel, FileMaker Pro, DBF, Merge, ODBC, and XML formats.)
 •
Converted field types (text, number, date, and so on) if they are available in the file or source you convert. Otherwise, all fields are text fields. (Field types convert from Bento, FileMaker Pro, Microsoft Excel, ODBC, DBF, and XML formats.)
For information on importing data into an existing file, see Importing data into an existing file.
Note  For information on converting Bento data into a new file, see Importing Bento data (OS X).
To import data into a new file:
1.
For a list of supported file types, see Supported import/export file formats.
2.
 •
In FileMaker Pro, choose File menu > Open.
 •
 •
3.
In the Create a New File Named dialog box or Open dialog box (Windows) or Open File (OS X) dialog box, for Files of type (Windows) or Show (OS X), specify the type of file (if needed), choose the file to convert, then click Open.
4.
5.
If you’re converting a Microsoft Excel spreadsheet and the Specify Excel Data dialog box appears, choose a worksheet or named range from the workbook file, then click OK.
6.
FileMaker Pro converts the data to a FileMaker Pro file and displays the file.
Notes
 •
 •