Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 530
2. Make a clone of the file to export.
For information about cloning files, see Saving and copying files.
3. Open the clone, then import the data from the original file.
For information about importing records, see Importing data into FileMaker Pro.
4. When the Import Options dialog box opens, select Splitting them into separate records,
then click Import
.
5. Export from this clone file to DBF format.
For more information see Exporting data from FileMaker Pro.
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.
For information on how to import or export data, see Importing data into FileMaker Pro or Exporting
data from FileMaker Pro.
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.
Supported
format
Filename
extension
Import/convert
or export Notes
Comma-
Separated Text
format
.csv or .txt Both • Works with BASIC programs and applications
like Bento.
• Format is also called Comma-Separated Values
(CSV).
dBASE III and IV
DBF format
.dbf Both • Does not support dBASE II DBF format.
• Format retains field names.
FileMaker Pro
format
.fmp12 Both • Import from the current file format.
• Export to the current FileMaker Pro file format.
• Format retains field names.
HTML Table
format
.htm Export only • Exports data as an HTML table for use as a
static web page.
Merge format .mer Both • Good export format for creating form letters in a
word processor.
• This export format works well for Microsoft Word
Mail Merge.
• Format retains field names.
Microsoft Excel
format
.xlsx Both