Question: how to import excel file in servicenow?
Answer: Login as an administrator.
Left Navigator Bar > System Import Sets > Load Data. Create Table. Import Set Table: CMDB Data Upload [u_cmdb_data_load] Source of the import: File. File: Select your spreadsheet. Sheet number: 1. ... 
Click Submit.
After Import Set Table is created, Click Create Transform Map link.