You'll need to tell us more. You can certainly import records from an excel document, but how does doing so help you?
How is your database designed? What Tables? How is your layout designed?
Are you using a starter solution? which one and with what version of Filemaker?
One method that should work is to open the Excel file with Filemaker and let it do the work.
With Filemaker open select File:Open and adjust the popup to show excel files and select it and open it. Filemaker will do the work for you.
See what happens the first time and try again. You can delete the old Filemaker file or save a new one on top of it.
If your fields come in F1, F2, etc. you can manually rename them inside Filemaker.
I uploaded everything I could from Excel, but I was not able to upload my quantity or my stock value. For some reason it will not let me upload anything with a formula in it. I called filemaker support and they said I could not do it. So, I need to manually enter in my quantities and my stock value, but I cannot figure out how to do this. Any suggestions?
Also, I am using the inventory starter solution.
You could export the Excel file as csv or tab delimited which I assume would convert all of the cells that are using calculations into the result you see on screen. Then open that text file with Filemaker or import it. I would use a new fresh file so you can verify and update the data. This file can then be imported into your working file.
There may be a way to replace the cells with calculations with the value of that calculation using an Excel function or menu item, be sure to do this on a copy and not the original.
For cells with a calculation, you can import the value of the calculation returned, but not the actual formula used to produce it.