How Do You Convert Multiple Excel Sheets to One PDF?
You convert multiple Excel sheets to one PDF by adding your workbooks to QuickCatPDF's Multiple Sheets Excel to PDF tool, ticking the sheets you want under each file, and clicking Convert to PDF. The chosen sheets from every workbook come out as a single PDF, with a bookmark for each file.
It works with one workbook and many sheets, or with up to 10 workbooks at once.
How to Combine Excel Sheets Into One PDF With QuickCatPDF
Combining sheets takes four steps.
- Click Select Excel files or drop one or more workbooks on the page.
- Under each file, tick the sheets to include (all are ticked at first). Put the files in order with the arrows.
- Leave Output on One combined PDF, and keep Add a bookmark for each file ticked if you want bookmarks.
- Click Convert to PDF, then Download PDF.
Why Use QuickCatPDF for Multi-Sheet PDFs?
QuickCatPDF lets you pick sheets and files in one step. Without it, you'd export each sheet or workbook separately and then merge the PDFs. Here the tick lists, the file order and the merge all happen on one page.
The PDF keeps each sheet's formatting and charts, and the bookmarks make long reports easy to move around in. In our test, an XLSX and an ODS workbook, three sheets each, became one PDF with two bookmarks in 2 to 3 seconds.
Workbooks are converted on our own server and deleted automatically: the originals as soon as conversion ends, the PDFs right after your browser downloads them.
In What Order Do the Sheets Appear?
Sheets appear in their workbook order, and workbooks follow the order of the file list. Use the up and down arrows on each file to change which workbook comes first.
To reorder single pages afterwards, for example to move a summary sheet to the front, open the PDF in Organize PDF Pages.
Which Files Show a Sheet List?
XLSX, XLSM and ODS files show their sheet names as soon as you add them, because the list is read in your browser. Sheets that are hidden in the workbook are left out of the list, as they would be when printing.
For XLS and XLSB files the names can't be read before conversion, so the tool says so and converts every visible sheet. If you need to drop a sheet from an XLS file, remove its pages afterwards with Remove Pages from PDF.
Can Each Sheet Fit on Its Own Page?
Yes. Choose Fit each sheet on one page under Page fit, and each sheet becomes exactly one page of the combined PDF. Fit all columns on the page width keeps wide sheets readable instead. For more about these options, see Excel to PDF Fit to Page.
Frequently asked questions
Can I convert multiple Excel files to PDF at once?
Yes, add up to 10 workbooks of up to 50 MB each. Choose One combined PDF for a single file or Separate PDFs for one PDF per workbook, downloaded together as a ZIP.
Can I convert only some sheets?
Yes, untick the sheets you don't want under each workbook. At least one sheet per workbook must stay ticked.
Does the combined PDF have bookmarks?
Yes, one bookmark per workbook, named after the file, pointing to its first page. Untick Add a bookmark for each file to leave them out.
Is it free?
Yes, free with no sign-up and no watermark. A fair-use limit of 60 files an hour applies.
What else can I combine?
The same tool also accepts Word, PowerPoint and OpenDocument files, so a report and its spreadsheet can go into one PDF. For more options, see the Excel to PDF converter.
Last updated: