What does the Culture and Language Settings field do?

Culture Name controls how dates, times, and numbers are formatted in the output worksheets. The default en-US uses MM/DD/YYYY dates and period as the decimal separator. Set it to match your source data locale: de-DE for German (DD.MM.YYYY, comma decimal), fr-FR for French, or any other BCP 47 culture code.

Can I separate specific worksheets only, or does it always split all sheets?

The Separate Worksheets module splits all worksheets in the workbook into individual files. To work with specific sheets only, use the Extract Worksheets module which supports selection by worksheet name or index, or filter the module outputs by filename in a subsequent Make router.

What Excel file formats are supported for worksheet separation?

The module supports .xlsx and .xls Excel workbooks. Each worksheet is output as a separate Excel file preserving formatting. CSV and ODS formats are not supported; convert them to Excel before using this module.

Separate Worksheets in Make

Q: How do I split an Excel file into multiple files in Make?

Use the PDF4me Excel - Separate Worksheets module in Make. It accepts a single Excel workbook and outputs each worksheet as a separate file. Connect a downstream iterator or router to save, email, or post each separated file to its destination independently.

Separate Worksheets is a PDF4me Excel module for Make that splits every worksheet in an Excel workbook into its own individual file automatically, without any VBA or manual tab copying. Use it to distribute department-specific sheets to separate teams, archive individual worksheets to cloud folders, or route each sheet to a different API in a single Make scenario run.

What this module does

PDF4me Excel, Separate Worksheets takes a single Excel workbook and splits every worksheet into an individual Excel file within your Make scenario. Map your source file from any prior module, set the culture code for locale-aware formatting, and connect downstream modules to save, email, or post each separated worksheet independently. No VBA macros, no manual tab copying, no intermediate conversion steps.

Authenticating Your API Request

Every PDF4me module in Make requires a valid Connection. Create or select one that holds your PDF4me API key so the scenario can authenticate worksheet separation requests securely.

Get your API Key

Important Facts You Should Not Miss

All worksheets are separated in one run

The module splits every worksheet in the workbook into its own file in a single execution. There is no option to select specific sheets at the input level. To work with a subset, use a downstream Make router to filter outputs by filename, or pre-process the workbook with the Extract Worksheets module first.

Culture Name controls date and number output format

The Culture and Language Settings field determines how dates and numbers are formatted in the separated output files. The default en-US produces MM/DD/YYYY dates and period decimal separators. Set it to match your data source locale to avoid misformatted values: de-DE for German format, fr-FR for French, and so on.

File source can be mapped or pulled directly from Dropbox

The File field offers two modes: Map lets you supply the binary from any prior module output such as a Google Drive download, email attachment, or HTTP response. The Dropbox option connects directly to Dropbox and downloads the file within the same module step, reducing the number of modules needed for Dropbox-based workflows.

Make PDF4me Excel Separate Worksheets module showing Connection field, File set to Map with File Name and Document mapped from prior module, and Culture and Language Settings set to en-US — Set **File** to Map, supply **File Name** and **Document** from a prior module, and set **Culture Name** to match your file locale before running.

Parameters

Required: Connection, File Name, and Document must be provided. Culture and Language Settings is optional and defaults to en-US. For Make binary data handling, see the Make data structures documentation. For BCP 47 culture codes, see the Microsoft culture name reference.

Parameter	Required	What it does	Example
Connection	Required	PDF4me Excel API connection. Click Add and paste your API key if connecting for the first time. All requests are authenticated through this connection.	`My PDF4me Excel connection`
File	Required	File source mode. Choose Map to supply binary content from a prior module output. Choose Dropbox - Download a File to pull directly from Dropbox without a separate download module.	`Map`
File Name	Required	Excel filename including the .xlsx or .xls extension. Map from the prior module file name output or enter a static name. Used to identify the workbook and name the separated output files.	`quarterly-report.xlsx`
Document	Required	Binary content of the Excel workbook. Map from a Google Drive download, Dropbox get-file, email attachment, or HTTP response module output. Must be the raw file buffer, not a URL.	`1. Data`
Culture & Language Settings	No	BCP 47 culture code controlling how dates and numbers are formatted in the output worksheets. Defaults to en-US (MM/DD/YYYY, period decimal). Set to match your source data locale to avoid formatting mismatches.	`en-US`

Output

Field	Type	What it contains
document	`Base64 String`	The separated worksheet file encoded as a Base64 string. Decode it with a Make Tools module before saving to cloud storage or sending via email. One output bundle is returned per worksheet in the source workbook.
FileName	`String`	The output filename for this separated worksheet, typically named after the original worksheet tab. Use this as the filename when uploading to Google Drive, Dropbox, SharePoint, or any other destination module.
Success	`Boolean`	True if the worksheet was separated without errors. Add a Make filter on this field before routing outputs to avoid processing incomplete or failed separations.

How to Separate Worksheets in Make

Add PDF4me Excel to your Make scenario and select Excel - Separate Worksheets.
Select Connection (or click Add to authenticate with your PDF4me API key).
Set File to Map if the Excel file comes from a prior module, or choose Dropbox - Download a File for direct Dropbox access.
Map File Name (the .xlsx filename) and Document (the binary file content) from the prior download or trigger module.
Enter Culture & Language Settings matching your file locale: leave as en-US for English US formatting, or change to de-DE, fr-FR, or another BCP 47 code to match your data.
Click Save and run. The module returns one output bundle per worksheet. Connect downstream Google Drive, Dropbox, or HTTP modules to route each separated file to its destination.

When Should I Use Separate Worksheets in Make?

When Should I Use Separate Worksheets in Make?Common Make automation patterns using Separate Worksheets.

Distribute department worksheets to individual team folders

A weekly trigger retrieves the consolidated department report from SharePoint, a single workbook with one tab per department.
Separate Worksheets splits every tab into its own Excel file.
A Make router matches each output FileName to the correct department Google Drive folder.
Each department receives only its own data automatically, with no manual copying required.

Archive month-end worksheets as individual files

A monthly scheduled trigger downloads the period-close workbook from Dropbox using the built-in Dropbox file mode.
Separate Worksheets splits the P&L, Balance Sheet, and Cash Flow tabs into separate files.
Each output file is uploaded to a dated archive folder in SharePoint for compliance retention.
A Slack notification confirms the archive count and folder path to the finance team.

Email separated client worksheets on demand

A webhook trigger fires when a client submits a data request form identifying which workbook to split.
Separate Worksheets splits the requested multi-tab workbook into individual client report files.
A Make iterator loops through each output and emails the corresponding file to the appropriate client contact.
An audit log entry is created in Google Sheets recording the client ID, file names, and timestamp.

Frequently Asked Questions

How do I separate Excel worksheets without VBA in Make?+

Add the PDF4me Excel - Separate Worksheets module to your Make scenario. Map File Name and the Document binary from any prior module, set Culture Name if needed, and run. The module automatically splits every worksheet into a separate Excel file with no VBA, macros, or scripting required.

How do I split an Excel file into multiple files in Make?+

Use the PDF4me Excel - Separate Worksheets module. It accepts a single workbook and outputs each worksheet as its own Excel file. Connect downstream modules such as Google Drive Upload, Dropbox Create File, or Send Email to route each separated file to its destination independently.

What does Culture and Language Settings control?+

Culture Name is a BCP 47 locale code that controls how dates, times, and numbers are formatted in the output worksheets. The default en-US uses MM/DD/YYYY and period as the decimal separator. Change it to de-DE for German format (DD.MM.YYYY, comma decimal), fr-FR for French, or any other locale that matches your source data to ensure values format correctly in the separated files.

Can I separate only specific worksheets instead of all of them?+

The Separate Worksheets module always processes all worksheets in the workbook. To work with a subset, add a Make router after the module and filter outputs by FileName, keeping only the sheets you need. Alternatively, use the PDF4me Extract Worksheets module, which supports worksheet selection by name or index before extraction.

What Excel formats does the module support?+

The module supports .xlsx and .xls Excel workbooks. Each worksheet is output as a separate Excel file preserving the original formatting. CSV and ODS formats are not supported; convert them to Excel before using this module.

Extract Worksheets

Export specific worksheets as structured JSON by name or index, for targeted multi-sheet data extraction rather than full workbook separation.

Merge Excel Files

Combine multiple Excel workbooks into one consolidated file, the reverse operation to worksheet separation.

Secure Excel

Password-protect individual worksheet files after separation before distributing them to external recipients.