Skip to main content

One post tagged with "Excel"

View All Tags

Split Excel Sheets Into Separate Files in Make: No VBA, Just Dropbox and PDF4me

· 19 min read
SEO and Content Writer

PDF4me Excel - Separate Worksheets is a Make action that splits one .xlsx file into a separate workbook per sheet, without VBA or macros. This four-module scenario reads an Excel file from Dropbox, splits it into per-sheet workbooks, iterates over the returned array, and uploads each new .xlsx back to Dropbox with its own filename.

If you've ever inherited a workbook with twenty tabs and needed each tab as its own file, you've probably reached for VBA, a paid desktop splitter, or a very manual "Move or Copy... to new book" ritual. Every option assumes you're going to sit at a laptop and do it once. This walkthrough replaces all of that with a Make scenario that runs on a schedule, works over Dropbox, and hands you clean per-sheet .xlsx files with zero clicks after the first setup.

The flow at a glance
1. Dropbox - Download a File
Reads the source .xlsx from a fixed Dropbox path.
2. PDF4me Excel - Separate Worksheets
Splits the workbook into one .xlsx per sheet and returns an array.
3. Flow Control - Iterator
Loops over the Splitted Worksheet array so every item runs downstream.
4. Dropbox - Upload a File
Writes each per-sheet .xlsx into your output folder with its worksheet name.