Things You'll Need:
- FileMaker Pro
- Microsoft Excel
-
Step 1
Open the FileMaker Pro application and open the database file you wish to convert to Excel.
-
Step 2
Click the "Show All" button at the top of the FileMaker Pro screen to make sure you are viewing all your database records. Then click the "File" menu and select "Export."
-
Step 3
FileMaker Pro Export Dialog BoxChoose an export format from the drop-down menu at the bottom of the Export dialog box. FileMaker Pro comes with two options for a direct-to-Excel conversion. XLS will work for all versions of Excel. XLSX should only be used if you will be bringing the data into Excel 2007 (Windows) or Excel 2008 (Macintosh).
-
Step 4
Type in a name for the exported data file and click the "Save" button. This will bring up the next dialog box in the export process.
-
Step 5
If you want the first row of your Excel spreadsheet to include the field names of your data, check off the box next to "Use Field Names as Column Names in First Row" in the next dialog box.
-
Step 6
Choose Which Fields to Export to ExcelClick the "Continue" button and select the fields in your FileMaker Pro database you want to convert to Excel. Click "Move All" if you want all the fields to go into the export file. Otherwise, click the individual field names and click the "Move" button for each one.
-
Step 7
Click "Export," and FileMaker Pro will create the export file.
-
Step 8
Quit FileMaker Pro and double-click the exported Excel file to open it. Your converted file will open as a spreadsheet file in Excel.
