Excel Separate Worksheets in Zapier

Excel - Separate Worksheets is a Zapier action that splits one .xlsx file into a separate workbook per sheet without VBA or macros. The action reads your source workbook, walks every tab, and returns an array where each item is one worksheet packaged as its own file. Pair it with the Looping utility to save one file per sheet to Dropbox, Drive, or OneDrive automatically.

Related Blog Posts

No blog post yet for this feature — coming soon.

In the meantime, browse the PDF4me blog for tutorials and workflows across every platform.

Visit the blog →

Authenticating Your API Request

Every PDF4me module in Zapier requires a valid connection. Create or select one that holds your PDF4me API key.

Get your API Key

Important Facts You Should Not Miss

Output is an array, not a single file

The action returns one file object per worksheet, packaged as an array. A downstream Upload File step needs a Zapier Looping utility between it and this action so it uploads one file at a time.

Each output is named after its source sheet

PDF4me sets each returned file's name to the source worksheet name plus .xlsx. So a workbook with sheets Q1, Q2, Q3 becomes Q1.xlsx, Q2.xlsx, Q3.xlsx in your output folder without any expression work.

Cell contents are preserved byte-for-byte

Formatting, formulas, cell types, merged cells, and named ranges inside each sheet survive intact. Cross-sheet formulas that referenced other tabs will break because those tabs now live in separate files, so add a recalculation pass if you rely on them.

Three fields to configure. File carries the source workbook bytes; File Name is used for logging and downstream naming; Culture & Language Settings controls how numeric and date cells are parsed for internal processing.

What is Excel - Separate Worksheets in Zapier?

Excel - Separate Worksheets is Zapier's PDF4me action for splitting a multi-sheet .xlsx into one workbook per tab. It accepts a single file and returns an array of files, one per source worksheet. Unlike a desktop "Move or Copy Sheet" macro that runs interactively in Excel, this action runs in the cloud on any Zapier trigger, so a workbook dropped into Dropbox at 3am is already split by 3:15am.

Parameters

Parameter	Required	What it does	Example
File	Required	The source .xlsx file. Map from a Dropbox / Drive / OneDrive Get File step (or any step that emits a file).	2. File
File Name	Optional	Filename with extension. Passed through for logging and downstream mapping. Typically built by concatenating File Name and File Ext from the prior step.	Separate.xlsx
Culture & Language Settings	Optional	Locale used to parse date and numeric cells for internal processing. Does not modify stored values in the output workbooks.	en-US

Output

Field	Type	What it contains
Splitted Worksheet[]	Array of files	One populated .xlsx per source worksheet. Each element has both File and File Name properties. Feed the whole array into a Zapier Looping utility to process one at a time.
File Name	String	Property on each array item. Set to the source worksheet name plus .xlsx, e.g. Q1.xlsx, Summary.xlsx. Use it as the destination filename in the Upload File step.
File	Binary	Property on each array item. The .xlsx bytes for that worksheet. Map into a Dropbox / Drive / OneDrive Upload File action.

How does Excel - Separate Worksheets work in Zapier?

Zapier passes the source .xlsx bytes to PDF4me's /api/v2/SplitWorksheet endpoint. PDF4me opens the workbook with Aspose Cells, iterates over every sheet, packages each sheet as a standalone .xlsx (headers preserved, styles preserved, formulas preserved), and returns them Base64-encoded. Zapier surfaces the collection as a Splitted Worksheet[] array output. Per the Zapier documentation on loops, you then pipe that array through the Looping by Zapier utility so subsequent actions run once per element.

Common Questions

What file types can I use with Excel - Separate Worksheets?+

The source file must be an .xlsx (Excel 2007 or later). Legacy .xls files should be re-saved as .xlsx before use. The action returns one .xlsx per worksheet found in the source, regardless of tab colors or sheet visibility.

How do I split an Excel sheet into multiple worksheets without VBA?+

Use PDF4me Excel - Separate Worksheets inside Zapier. The action reads the .xlsx bytes, splits every worksheet into its own workbook, and returns an array. No macros, no VBA, no local Excel install required. The full Zap: trigger, Dropbox Get File, PDF4me Excel - Separate Worksheets, Looping by Zapier, Dropbox Upload File.

How much does Excel - Separate Worksheets cost in credits?+

Excel - Separate Worksheets consumes one PDF4me credit per run, regardless of how many worksheets the source contains. A workbook with 30 tabs costs the same as a workbook with 2. See the pricing page for the current per-tier credit allocation.

Can I filter which sheets get split?+

The action splits every worksheet in the source workbook. To keep only a subset, add a Zapier Filter step after the Looping utility and match on the file's name property (which mirrors the source sheet name). For example, "only continue if File Name starts with Q" keeps Q1.xlsx, Q2.xlsx, Q3.xlsx and drops everything else.

Why does my Upload step complain about invalid file input?+

The File field is mapped to the raw array output instead of the per-iteration file. Add a Looping by Zapier step between Excel - Separate Worksheets and Upload File. Inside the loop, map the Upload's File field to Looping - Splitted Worksheet, which resolves to one .xlsx per iteration.

Get your API KeyContact Support