Question: how to import data from excel to sap b1?
Answer: From the Main Menu , choose Administration Data Import/Export Data Import Import from Excel .
In the Import from Excel window, from the Data Type to Import dropdown list, select the required business object.
Save the template: Choose the Save As button.