Question: how to import multiple excel files in stata?
Answer: Beginning in Stata 12 you can read Excel (. xls and . xlsx) files directly using the import excel command. The sheet() option allows us top specify from which sheet of the spreadsheet we want to read, and by appending the data together, we can read data from multiple sheets.