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.