Setting up recurring imports
You can set up a FileMaker Pro file to automatically update data imported from another file, such as a Microsoft Excel spreadsheet. Recurring import occurs automatically every time you open the file and the first time you view the layout containing the data from the external file. Later, you can run a script to update data.
When you set up recurring imports, FileMaker Pro creates a new table for the imported data and a new layout to display the data. You can customize the layout in Layout mode later, if you wish.
Each time you update data, FileMaker Pro deletes data in the recurring import layout and replaces it with current data from the external file. Data imported via recurring import cannot be modified or added to in FileMaker Pro.
Note  To set up recurring imports, you must open a file with an account that is assigned the Full Access privilege set. For information about privilege sets, see About accounts, privilege sets, and extended privileges. Users do not need to use an account with Full Access privileges to use recurring import after it has been set up in a file.
To set up recurring imports:
In Browse mode, choose File menu > Import Records > File.
For Files of type (Windows) or Show (OS X), select the type of file you want to import. For example, choose Excel Workbooks (*xlsx).
For a list of supported file types, see Supported import/export file formats.
Select Set up as automatic recurring import, then click Open.
The path of the file you selected appears in the Recurring Import Setup dialog box.
To skip importing column headings, select Don’t import first record (Contains field names).
Note  You can import data from only one worksheet or named range per layout.
Select Display worksheets, select the worksheet you want to import, then click Continue.
Select Display named ranges, select the named range you want to import, then click Continue.
The new layout appears in Browse mode in Table View. For more information about Table View, see Viewing records as a form, list, or table.
Related topics 
Importing data into an existing file