How to batch-convert a whole folder of Excel files to PDF at once

Short answer: Excel has no built-in “convert this whole folder” button — out of the box you’re opening and exporting files one at a time. The two real options are to script a loop (VBA or PowerShell driving Excel), or to use a tool that takes a folder and renders every workbook in one pass. CrazySmartPDF’s desktop app does the folder in one pass.

Doing it by hand (or by script)

• One at a time: File → Save As / Export → PDF, per workbook. Fine for two files, painful for twenty.
• VBA macro: loop over Dir(), Workbooks.Open each file, call ActiveSheet.ExportAsFixedFormat xlTypePDF, close, repeat.
• PowerShell + Excel COM: New-Object -ComObject Excel.Application, open each file in a folder, ExportAsFixedFormat, quit.

The honest catch: the scripts are real work to write and maintain, and each one still does a dumb per-sheet print — the same cut-off columns and split rows you’d get from Save as PDF, just automated. You’ve batched the export, not fixed the layout.

How CrazySmartPDF handles it

The desktop app is built for volume:

• Point it at a folder; it finds every .xlsx and .xlsm, opens each read-only, runs the full smart layout and the self-check, and writes one PDF per workbook to your output folder.
• A live log tracks progress — “[3 / 12] processing…”, then success or failure per file.
• One bad workbook is logged and skipped, not fatal — the run keeps going and finishes the rest.
• Your originals are never modified — the app opens them read-only.

The honest caveats

The desktop app drives your installed Excel on Windows (2016+) invisibly, so Excel has to be present. Whole-folder batch is a desktop-app feature and covers modern workbooks (.xlsx / .xlsm). The free web converter on the home page runs the same smart engine on our server — your file is converted, then deleted (never stored) — and lays out row-atomic, one file at a time; whole-folder batch is what the Windows desktop app adds.