Skip to main content

Excel to PDF

Converts Excel files to PDF format.

Overview

The Excel to PDF node converts .xlsx or .xls files into PDF documents. It offers two conversion modes — table mode for clean data presentation with repeating headers, and styled mode to preserve original spreadsheet formatting.

Use it to:

  • Generate PDF reports from Excel exports
  • Convert uploaded Excel files to PDF for archiving
  • Create printer-friendly versions of spreadsheet data

Parameters

ParameterDescriptionRequired
FileExcel file to convert (supports expressions)Yes
Conversion ModeTable or StyledYes
Sheet NameSpecific worksheet to convert (empty = all worksheets)No
File NameOutput PDF name without extensionNo
One PDF Per TabCreate a separate PDF for each worksheetNo
Include Hidden SheetsInclude hidden worksheets in the conversionNo
File DestinationWhere to save the PDFYes

Conversion Modes

ModeDescriptionBest For
TableRepeating headers on each pageLong data tables, reports with many rows
StyledPreserves original styling, colors, formattingBranded reports, formatted spreadsheets

File

The Excel file to convert. Typically comes from an Export to Excel node or a file trigger:

{{$item.data.file}}

One PDF Per Tab

When enabled, each worksheet is converted into a separate PDF file. The node outputs multiple items — one per tab. This is useful when you need individual PDFs for each sheet in a workbook.

When disabled (default), all worksheets are combined into a single PDF.

Include Hidden Sheets

When enabled, hidden worksheets are included in the conversion. By default, hidden sheets are excluded from both single-PDF and per-tab conversions.

Sheet Name

Optional — specify a worksheet name to convert only that sheet. Leave empty to convert all worksheets. Not available when One PDF Per Tab is enabled.

Settings

SettingDescription
Execution ModeOnce per item (default) or Once
Output ModeHow to output results when running once
Batch SizeItems to process concurrently (default 5)
Stop on ErrorStop workflow on failure

Output

Each output item contains a file and an optional sheetName:

{
"file": {
"type": "fileData",
"name": "report.pdf",
"mimeType": "application/pdf",
"fileInfo": { "type": "..." }
},
"sheetName": "Sheet1"
}

When One PDF Per Tab is enabled, the node outputs one item per worksheet. Otherwise it outputs a single item.

Access in expressions:

  • File object: {{$item.data.file}}
  • File name: {{$item.data.file.name}}
  • Sheet name: {{$item.data.sheetName}}

Examples

Convert Uploaded Excel Files

[Google Drive Trigger] → [Excel to PDF (styled)] → [Copy File (archive folder)]

Generate Table PDF from Export

[Get Table] → [Export to Excel] → [Excel to PDF (table)] → [Send Gmail]

Use Table mode to ensure headers repeat on every page.

Convert Specific Worksheet

[OneDrive Trigger] → [Excel to PDF (sheet: "Summary")] → [Copy File]

Tips

  • Use Table mode for data-heavy spreadsheets — headers repeat on every page
  • Use Styled mode when formatting and branding matter
  • Specify a Sheet Name to convert only one worksheet from a multi-sheet workbook
  • Use One PDF Per Tab to get individual PDFs per worksheet
  • Hidden worksheets are excluded by default — enable Include Hidden Sheets if you need them
  • This is a long-running operation — large files may take time to process
  • Connect error output to handle conversion failures