Question: how to import excel file in hive?
Answer: On the Tools menu, point to Import and then click the command for the source file format (for example, from Excel).
If you want to import an Excel file, browse to and select the file and then select the worksheet in the Excel file.