Importing data into FileMaker should be easier than it often is.
For many FileMaker systems, imports fall into one of two categories. The first option is a pre-mapped import script, which works well when the incoming file always follows the exact same structure. The second option is FileMaker’s built-in import interface, which offers greater flexibility but often exposes too much of the database structure.
Neither option is ideal for everyday users.
Pre-mapped imports are simple but rigid. If a spreadsheet changes slightly, the import can break or require developer intervention. The built-in import interface is flexible, but it often requires users to understand field names, table structure, naming conventions, and the database backend.
The Custom Import Tool Add-On is designed to give FileMaker users a better middle ground.
It allows users to import data using friendly, easy-to-understand column labels instead of exact back-end field names. Users can create, save, modify, and reuse import templates, making recurring imports easier while still allowing flexibility when the incoming file changes.
What Is the Custom Import Tool Add-On?
The Custom Import Tool Add-On is a FileMaker add-on designed to make importing data more user-friendly, flexible, and controlled.
Instead of asking users to map spreadsheet columns directly to FileMaker field names, the tool lets a full-access user define friendly header options in advance. Once those mappings are configured, end users can build import orders using labels that make sense to them.
For example, instead of seeing a back-end field name like Customer::cust_primary_email, a user could simply choose “Customer Email.”
That small change can make imports much easier for non-technical users.
The tool also supports saved import templates. If a vendor, customer, department, or third-party system sends files in a consistent format, users can save that import structure and reuse it later. If the file changes, they can modify the template or make a one-time adjustment during the import.
Out of the box, the tool supports up to 20 columns, with the option to add more columns if needed.
Why FileMaker Imports Can Be Difficult
Imports are one of those tasks that seem simple until real-world data gets involved.
Spreadsheet columns may be renamed. Column order may change. Extra fields may be added. Some rows may need to be skipped. Some columns may not be needed at all. A file may contain multiple pieces of data in one column that need to be split into separate FileMaker fields.
For technical users, those issues are manageable. For everyday users, they can be frustrating quickly.
A user should not need to understand every field name in the database just to import a spreadsheet. They should not have to worry about accidentally mapping data to the wrong field. They should not have to call a developer every time a file has one extra column.
The Custom Import Tool Add-On is designed to reduce that friction.
It gives users a cleaner interface to choose what gets imported, what gets skipped, and how incoming data should be handled before it reaches the final destination table.
How It Works
The Custom Import Tool uses a staging-table approach.
Instead of importing data directly into the final destination table, the tool first imports the incoming file into a staging table. This gives users a chance to preview and review the data before completing the import.
That staging table is intentionally open and editable. Users can make corrections, clean up values, remove unwanted rows, or adjust the imported data before submitting it to the main system.
The basic workflow looks like this:
- A full-access user maps friendly header labels to real FileMaker fields.
- The data is imported into a staging table.
- An end user selects or creates an import template.
- The user selects which columns to import from the incoming file.
- The user can preview, edit, skip, or adjust data as needed.
- The final import script moves the staged data into the appropriate FileMaker table.
This gives users more control without exposing them to unnecessary back-end complexity.
Flexible Import Templates
One of the most useful features of the tool is the ability to create and modify templates.
If a company regularly imports files from the same source, such as a vendor spreadsheet, customer data export, inventory file, or order report, users can create a template once and reuse it.
Templates can also be adjusted on the fly.
If a file arrives with a slightly different column order, users can adjust the import order. If a column should be ignored, they can mark it to skip. If the change is temporary, they can make a one-time adjustment without permanently changing the saved template.
This makes the tool useful for both recurring imports and unpredictable one-off imports.
Preview Before You Commit
A major benefit of the staging-table approach is that users can see what they are about to import before the data reaches the final table.
That matters because import mistakes can be messy.
If data is imported directly into production records, a bad mapping or messy spreadsheet can create duplicate records, overwrite important values, or place information in the wrong fields. By staging the data first, users have a safer place to review what is happening.
Skipped rows and skipped columns are highlighted, making it easier to see what will and will not be included in the final import. Users can also edit the staged data before completing the process.
That creates a more forgiving import experience.
Create and Update Records in One Import
The Custom Import Tool can also support matching fields, allowing imports to create new records and update existing ones in a single process.
For example, a company may import a customer list in which some customers already exist in FileMaker, and others are new. With match fields configured, the import process can identify existing records and update them, and create new records where no match is found.
This can be especially useful for customer lists, inventory files, product catalogs, order updates, membership records, and other recurring data sources.
Ideas for How to Use It
The Custom Import Tool Add-On can be used anywhere FileMaker users need a more flexible import process.
Common use cases include:
- Importing customer or prospect lists
- Updating product catalogs
- Importing inventory counts
- Processing vendor price sheets
- Loading order data from external systems
- Importing membership or registration lists
- Updating contact information
- Cleaning and reviewing data before final import
- Creating controlled imports for non-technical users
- Handling recurring spreadsheet formats from customers, vendors, or departments
It can also be customized further with scripting.
For example, a developer could parse data from one incoming column into multiple FileMaker fields. A single “Full Name” column could be split into first and last name fields. A combined address field could be parsed into street, city, state, and ZIP code. A product description could be analyzed and separated into category, size, or model fields.
The add-on provides the import framework, but FileMaker developers can extend it to fit the needs of the specific system.
The Bottom Line
The Custom Import Tool Add-On is designed to make FileMaker imports easier, safer, and more flexible.
It provides users with a user-friendly interface for selecting import columns, saving templates, skipping rows or columns, previewing data, and making adjustments before the final import. At the same time, it gives developers a controlled structure for mapping fields, defining match logic, and customizing the import process.
For businesses that rely on recurring spreadsheet imports, this can save time, reduce errors, and make FileMaker easier for everyday users to work with.
Importing data will always require some structure. The goal of this tool is to make that structure easier for non-technical users to manage, reuse, and understand.
