Looking for quick way to merge 188 excel tables into one spreadsheet

Copper Contributor

I have 188 excel tables that I wish to merge into a single spreadsheet. Tables are all formatted the same. I know that I can copy and paste them individually to a spreadsheet but I am looking for an easier method


1 Reply
you can use power query or use a formula like:
=VSTACK(Sheet1!A1:ZZ1, Sheet1:Sheet188!A2:ZZ999)
of course adjust the sheet names and range accordingly and I'm assuming the header is the same on each so I take it from 1 sheet and start on row 2 on the rest.
Once done you can Copy and then Paste as Values if you want to delete the original sheets.