Hello everyone

I am working with the US IRS data from a previous year. Each state is its own excel file with information about various information for every zipcode that state contains. I am trying to combine the excel data from all the states into a single file.

I feel the most rudimentary way would be to copy and paste, but would take a very long time with 50 files. To make things more complicated, I would not "copy all" the data; I would only copy the headers and information underneath (excluding the miscellaneous information). So I would have to copy a selected portion to be pasted in a new file.

I am doing this to create a stata data set, but I first need to import the information from excel (as a .csv file) as a single file that has all of the 50 states data.

Any tips or tricks to make this process more efficient are much appreciated, thanks!