MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split Workbook by Worksheets in Excel

July 05, 2017 - by Bill Jelen

Split Workbook by Worksheets in Excel

You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.

First, perhaps you just used the Show Report Filter Pages feature in Excel but need to send each sheet to a different department. To see how to use this, watch this Podcast 2106 starting at 7:58.

Or - you want to use the Power Query Combine Files feature but all of your sheets are in a single workbook. See the Power Query example in Podcast 2077. Or - you have some other business reason.

I recorded this video showing the free MrExcel Workbook Splitter:

Download the zipped workbook from here.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.