Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 529
You may not need to change the character set selection. FileMaker Pro automatically selects a
suitable character set based on the file format you’re exporting to and the operating system
you’re using.
11. If necessary, select Apply current layout’s data formatting to exported data to format
field data as it appears on the current
layout.
FileMaker Pro allows you to format fields on a layout, which makes the data look different on the
layout than how it is actually stored in the database file. (See
Formatting and setting up field
objects in Layout mode.) Select Apply current layout’s data formatting to exported data
when you want to export number, date, and time data using the field formats specified on the
current layout.
If the current layout formatting can’t be applied when you’re exporting to an Excel file, the Excel
file uses the system format.
If you’re exporting to DBF format, this option is not available.
12. Click Export.
Notes
• To use an exported file, open an application that can read the file format, and then open the
exported file.
• To use FileMaker Pro as a data source to serve FileMaker Pro data via ODBC or JDBC, see
Sharing FileMaker Pro data via ODBC or JDBC.
• If you want to save the records as an Excel file instead of exporting them, choose Save/
Send Records As
> Excel. When you save records as an Excel file, all the fields that you
have access to and can see on the current layout are saved. When you export to Excel, you
must specify which fields to export.
• To append data to exported records, you need to use the Save Records As PDF script step.
• OS X: To export FileMaker Pro data to the Address Book application, export your contacts
as tab-separated text. Import the contacts in Address Book in the text file format.
Related topics
Saving and sending records as a PDF file
Sending one email message
Sending multiple email messages
Exporting repeating field data
Some file formats (such as DBF) can interpret only one value per field and do not support repeating
fields. When you export to these formats, only the first value in a repeating field is exported. An alert
message warns you if you’re exporting repeating fields to a file format that supports only the first
value.
Although you can export repeating fields to XML, if you export related fields that repeat, only the first
value in each related repeating field is exported.
You can work around these limitations by following these steps.
To export repeating field values into formats that don’t support repeating
fields:
1. In the FileMaker Pro file, find the records you want to export.
For information about finding records, see Finding records.