Consolidate tables into a single spreadsheet

Copper Contributor

How can I create a single excel spreadsheet from 180 tables (all with the same format?



2 Replies

@Ray_Nord -


  • Power query is an ideal option!
  • VSTACK formula also does the job here. Of course you need to adjust the range and sheet name.





  • You can do it with the help of Command Prompt too!