Convert XLS to PDF and Add Page Numbers

A long PDF with no page numbers is hard to reference. When you convert a spreadsheet to PDF, someone always has to say (see page 12), and blank footers make that impossible. Total Excel Converter adds an automatic page counter while it converts your XLS and XLSX tables to PDF, so the numbering is baked in from the first file.

Quick answer: To add page numbers when you convert XLS to PDF, open Total Excel Converter, select your files, choose PDF, and in the header or footer settings insert the page and total-page tags, set the font, alignment and start number, then press Start. The counter is applied automatically across the whole batch, offline and with no upload.

How do I add page numbers when converting XLS to PDF?

The page counter lives in the header or footer settings of the PDF step, and it is fully adjustable. You are not limited to a bare number: you can mix the counter with plain text and macro tags to build a real running header. A footer template like [page] of [pages] Daily Report (internal use only) prints the current page, the total pages, a label and, if you add the date tag, the date, on every page.

• Combine the page counter with other text and macro tags
• Choose the font for the header or footer
• Set the alignment of the counter left, center or right
• Set the page margins for the numbered area
• Specify the start number, not just 1

A custom start number matters when you slice a big report into parts: set part two to begin at 51 and the numbering stays continuous across separate PDFs. The same header can also carry a file name, a secrecy label or a date tag, so each page identifies itself at a glance.

Does the page counter work across a whole batch?

Yes. Total Excel Converter supports batch conversion, and the page counter is applied to every converted copy. You can merge all tables into one PDF and number it end to end, or write each workbook to its own PDF with its own counter. Either way you set the rule once and every file follows it. For a full walkthrough of the PDF settings, see how to convert Excel to PDF offline.

Beyond numbering, the PDF step lets you set page properties, compress the output, and protect files with a password or a digital signature, so the numbered report is also secure.

Total Excel Converter runs on Windows 7, 8, 10 and 11 and also supports the command line, so the same numbered-PDF job can run from a short cmd command or a scheduled task. The 30-day trial is fully functional, with no email or credit card.

Set the header template once, save it, and every future batch inherits the same numbering and labels without extra clicks.

Download the 30-day free trial and see the full range of PDF and page-counter settings for yourself.

Total Excel Converter Customer Reviews 2026

"Our monthly cost reports run to sixty-odd pages and the board kept asking why the PDF had no page numbers. Total Excel Converter let me build a footer with page of pages plus the report name and date, and it stamped every page across the whole batch. The start-number option meant I could keep numbering continuous when I split the appendix into a second file."

Gregory Nash Finance Manager, Wexford Manufacturing

"I export dozens of XLSX status sheets each week and merge them into one client PDF. Being able to number the combined document end to end, with a for internal use only label in the header, made it look properly finished. Set the template once and every weekly batch comes out the same."

Amara Okafor Project Administrator, Lantern Consulting

"Audit packs have to carry page numbers and a file reference on every sheet. Total Excel Converter does exactly that while converting our inspection spreadsheets to PDF, and the password option keeps the packs locked. It took me a couple of tries to get the margins right, but once saved it just repeats."

Thomas Reuter Quality Auditor, Brenner Components

XLS to PDF with Page Numbers — FAQ ▼