Working with Microsoft Excel

You can use Microsoft Excel and FileMaker Pro together in a variety of ways.


Do this

Use FileMaker Pro to import data stored in an Excel file on a regular basis

Set up recurring imports in FileMaker Pro to make it easy to import data stored in Excel files. See Setting up recurring imports.

Note  Data imported via recurring import cannot be modified or added to in FileMaker Pro. Any changes to the data must be made in the Excel file and reimported into FileMaker Pro.

Bring data stored in an Excel file into an existing FileMaker Pro file

Import data from the Excel file. See Importing data into an existing file.

Create a new FileMaker Pro file using data from an Excel file

Convert data from Excel format to FileMaker Pro format. See Converting a data file to a new FileMaker Pro file.

Create a new Excel file using data from a FileMaker Pro file

Use scripts to import data to and from FileMaker Pro and Excel

See Import Records, Save Records as Excel, or Export Records.

Learn more about how FileMaker Pro interprets Excel data

See Microsoft Excel format.