Microsoft Excel : How to merge multiple excel files

Prerequisite : Please download ASAP Utilities and Install it. 

Steps for installation  

After installing , you will be able to see ASAP Utilities as a add on . Please check the image down below.

Step 1 : Go to ASAP Utilities -> Import ->  10th Option -> Merge and import multiple files

     

     Step 2 :  Select the right options to get the data into one sheet.  

  Step 3 : Please click on 'OK'. Browse to the folder that has all the files to be merged. Select all the files and click on Open.

Voila ! - Now you have all the merged files data in one Excel file. 

Don't forget to like, share and subscribe. Thank you very much.