# How to import data from excel file with multiple sheets into stata

How to import data from excel file with multiple sheets into stata
import excel "file location", sheet("Sheet1") firstrow
import excel "file location", sheet("Sheet2") firstrow
import excel "file location", sheet("Sheet3") firstrow

[@shahbazh2530]

Walaikum Assalam

[@sherifabdelhameed1613]

this is useless. how do you merge them into one dataset is the question.

[@anikachhillar4615]

this doesn't work when you have 40 sheets to merge