Question: how to import data from excel in business central?
Answer: Open the Config. ... 
Select the table for which you want to import data, and then, on the Tables tab, choose the Import from Excel action.
Locate and open the file that you want to import data from.