User manual

Chapter 5 | Sharing and exchanging data 135
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. In the Create a New File Named dialog box, type a name for the new file, choose a location,
then click Save.
FileMaker Pro converts the data to a FileMaker Pro file and displays the file.
For more information about importing data, see Help.
About the exporting process
You can export FileMaker Pro data to a new file, then open it in another application.
The basic steps for exporting records are:
1. Open the FileMaker Pro file and display a layout that shows the records you want to export.
2. Find and sort the records to export. See “Finding records” on page 31 and “Sorting records” on
page 43.
3. Choose File menu > Export Records.
4. In the Export Records to File dialog box, type a name and choose a location for the exported
file, and choose a file type.
5. In the Specify Field Order for Export dialog box, select how you want FileMaker Pro to export
the data.
6. If necessary, choose the character set you want the exported file to use.
7. Select whether or not to apply the current layout’s formatting to the exported data.
For more information about exporting data, see Help.
To export Choose
A field on the current layout Current Layout (LayoutName) from the table list, then double-click a field in
the list
A field in the current layout’s
table
Current Table (TableName) from the table list, then double-click a field in the list
Select fields
from this list
Select whether or not to
apply formatting
FileMaker Pro exports
these fields
To export related fields, select
the related table from the list