How to Split Excel XLSX Files into Separate Worksheets in Power Automate
In this video, you will learn how to split an Excel XLSX file into two separate worksheets using the Cloudmersive Document Conversion API Connector in Power Automate. This video demonstrates how to find and configure the Excel file splitting action and then shows how to create individual files with those worksheets using the built-in "Apply to Each" control in Power Automate.
To use this connector for free, you'll need to provide a free-tier Cloudmersive API key during the connector authentication step. To get a free API key, register a free account on the Cloudmersive website (this allows a limit of 800 API calls per month with no additional commitment).