Supported import/export file formats
FileMaker Pro and many application programs that you want to exchange data with use a proprietary file format. In order to exchange data, you must export the data from one application in a format that the other application can import. If you’re exchanging data with another application program, check the documentation that came with that program to determine a common intermediary file format that both FileMaker Pro and the other program supports.
FileMaker Pro supports the import/export file formats listed in the following table. FileMaker both imports and exports most formats, but a few formats are either import/convert only or export only.
Most file formats support data conversion only and do not import or export formatting such as font, size, style, and color. Some of the formats export or convert field names and field types. For details on a particular format, click its link in the following table.
Does not support dBASE II DBF format.
Export to .xls requires Rosetta, which is not available on some versions of Mac OS X.
Works with most applications. If you aren't sure which format to use, try this one first.
You can also do the following:
Mac OS: Import from Bento data sources. See Importing Bento data (Mac OS).
Import from ODBC data sources and use FileMaker Pro as ODBC data source to serve FileMaker Pro data. See Querying an ODBC data source from FileMaker Pro and Sharing FileMaker Pro data via ODBC or JDBC.
Set up recurring imports so FileMaker Pro updates data automatically the first time you view imported data in a file or lets you use a script to update data on demand. Data imported via recurring import is read-only in FileMaker Pro. See Setting up recurring imports.
Publish FileMaker Pro database files to a web page. See Publishing databases on the web.
Save a layout as a PDF file that can be used later as a blank form. See Saving and sending records as a PDF file.
Topics in this section
Comma-Separated Text format
dBASE III and IV DBF format
FileMaker Pro format
HTML Table format
Merge format
Microsoft Excel format
Tab-Separated Text format
XML format