Save Records As Excel
Purpose 
Saves records to a specified Excel worksheet.
Format 
Save Records As Excel [Restore; No dialog; “<output filename>”; Automatically open; Create email; Records being browsed/Current record]
Note  In order to save records as a Microsoft Excel worksheet, your privilege set must include Allow exporting, or you must select Run script with full access privileges in the Edit Script dialog box.
Options 
 •
Perform without dialog prevents the Excel Options dialog box from displaying as the script step executes if you have already specified a file. If you have not specified a file, the Save Records as Excel dialog box displays as the script step executes, but the Excel Options dialog box is not displayed.
 •
Select Specify output file or click Specify to display a dialog box where you can specify the file path. Choose the folder you want to export to, or type the file path directly into the list. Specify one path per line. FileMaker Pro will use the first path it locates. See Creating file paths. You can choose to Automatically open file or choose to Create email with file as attachment to create a blank email with the Excel file as an attachment.
 •
Select Specify options or click Specify to display the "Save Records as Excel" Options dialog box. From the Save list, choose Records being browsed or Current record. Specify whether the values in the first row should be used as field names or as data. For Worksheet, Title, Subject, and Author, you can enter text directly, or click Specify to enter a field name or values from a calculation.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
No 
FileMaker Go 
No 
Custom Web Publishing 
No 
Instant Web Publishing 
No 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 8.0
Description 
This script step operates in all modes except Find mode. Export to .xls requires Rosetta, which is not available on some versions of Mac OS X.
Examples 
Go to Layout ["Layout #4"]
Save Records As Excel [No dialog; "Contacts.xlsx"]
Related topics 
Saving and sending records as an Excel file
Export Records script step
Import Records script step
Script steps reference (alphabetical list)
Script steps reference (category list)
Was this topic helpful? Send feedback.