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 app drives your installed Excel on Windows (2016+) invisibly, so Excel has to be present. The batch path covers modern workbooks (.xlsx / .xlsm); it isn’t a Mac or online tool (the browser upload surface is a separate beta). There’s no public installer to grab yet — this is what the desktop app does; you can watch the flow on the homepage demo.