AnsweredAssumed Answered

Replacing Excel with FileMaker

Question asked by jsonhdev on Dec 11, 2012
Latest reply on Dec 12, 2012 by DavidJondreau

I just purchased the FileMaker Developer Subscription and am looking to focus my learning curve and would appreciate where I can quickly find the answers to my questions.



  • I have an Excel Document with multiple worksheets that is used to track some inventory.
  • I am thinking of using the pre-built Inventory Template in FileMaker to replace the Excel document to reduce development time.
  • I need to allow multiple users access to the inventory data via mobile access. They need to filter, create reports, and modify the data.



1) How do I map my existing field data in Excel to the fields in the Inventory Template so I can do a quick import?


2) Can I display the Inventory Template on the Web and allow access to users outside the company?


3) Can I make reports on demand or does each report need to be prepared first with a new layout?


4) I was going to setup FileMaker Server Advanced to hold the data. If there will be about 15 users, does each user need FileMaker Pro client versions?