Effortlessly Split Excel Workbooks: Power Automate & Excel Office Scripts Solution

Are you tired of manually sorting through large Excel workbooks? In this video, I'll show you how to split an Excel workbook into multiple worksheets based on a key column using Power Automate and Excel Office Scripts. Not only that, but you'll also learn how to split the same workbook into multiple individual workbooks containing the unique data for the distinct key column values.

I'll take you step-by-step through the process using two sample datasets downloaded from Kaggle and show you how to implement the solution via the sample code that is available to download on my blog post. Plus, I'll show you how to bulk load any data into a new Excel file using Office Scripts. This is a great solution for those who want to automate the process of sorting through large Excel workbooks and increase productivity.

Don't miss out on this opportunity to learn how to split an Excel workbook into multiple worksheets using Power Automate and Excel Office Scripts. Make sure to check out my other Office Script demo videos at https://www.youtube.com/playlist?list=PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM, my blog post https://www.damobird365.com/split-a-workbook-into-multiple-worksheets, and my other videos like "Create an Excel File from Compose https://youtu.be/RB_ySjhm9Sg"

Don't forget to hit the like and subscribe button!

00:00 Intro
00:43 Checking out the example Workbooks
01:07 Run an Office Script to Split the Workbook
03:56 Reviewing the Flow Output and Excel Worksheets
07:17 Build a Cloud Flow to Create Individual Workbooks
14:57 Reviewing the Flow Output and Excel Workbooks
17:15 Lets check out the Office Script Code
21:05 Bulk load any data into a new Excel File using Office Scripts
24:40 Outtro, summary and reflection