Counting PDF pages for an Excel log means using a separate page-counter tool that returns the structural page count of each PDF, then entering that number into a cell in your spreadsheet. Excel itself cannot open a PDF page tree or read page-box dimensions, so the count has to come from outside Excel — and the safest place to get it is a tool that reads the file locally in your browser without uploading it. PDF Page Counter is built for exactly that step: it opens one PDF (up to 25 MiB), reports the exact number of pages from the document's page tree, and groups pages that share the same width and height in PDF points. Because nothing is uploaded, the count you paste into Excel is based on a private inspection of the original file rather than a server-side estimate. Visible page-number labels (Roman numerals, repeats, or custom starting numbers) do not change the total, and the tool does not modify, save, or replace the source PDF. The result is a single integer per file that you can paste next to the filename in Excel and use for upload checks, print estimates, or split planning.
Why Excel itself can't give you the page count
Excel is a spreadsheet application, not a PDF parser. When you double-click a .pdf file from Excel, Excel doesn't extract anything from it — the workbook simply hands the file off to your default PDF reader, and the count of pages is never sent back to the spreadsheet. There is no built-in formula, no built-in function, and no built-in add-in in Excel that reads a PDF page tree, page-box dimensions, or PDF object metadata on its own. So if you maintain a column of PDF filenames in column A and want a page count in column B, the value in column B has to be produced by something outside Excel.
That outside source can be one of two broad categories: an upload-based web service that parses your file on a remote server, or a local browser tool that reads the PDF structure inside your current tab. The second category keeps the file on your machine, never sends the bytes across the network, and returns a number that comes directly from the document's structural page array — not from file size, thumbnail counts, or visible page-number labels. For workbooks that contain customer documents, contracts, or internal reports, the local option is usually the safer default.
What PDF Page Counter actually reports
PDF Page Counter opens one PDF at a time — up to 25 MiB, non-empty, not encrypted — and reads the page tree that already exists inside the PDF structure. It then displays two things on the page:
- The total page count, taken from the structural page array exposed by the underlying PDF library.
- A grouped inventory of page-box dimensions, where pages that share the same width and height in PDF points are listed together with their page count.
For example, a file with two 612 × 792 pt pages and one 400 × 500 pt page would show 3 total pages and two groups: "612 × 792 pt — 2 pages" and "400 × 500 pt — 1 page." Dimensions are rounded to at most two decimals for display only; the actual values are taken straight from the page box the library returns. The grouping is in first-seen order, so the size of the first page appears first in the list.
The tool is strictly read-only. It does not rewrite rotation, change document metadata, save a new copy of the file, extract text, render thumbnails, count annotations, detect blank pages, count physical duplex sheets, or infer a printing cost. Rotation metadata in the PDF can change how a viewer presents a page on screen, but the reported width and height are always the page-box values, not the rotated display values. The displayed dimensions use PDF points, where the file defines its geometry — they are not pixel dimensions and they do not reveal scan resolution, image quality, or vector cleanliness.
Count PDF pages for an Excel log: the workflow
- Open the PDF Page Counter tool in your browser tab.
- Choose the PDF you want to count from the file picker — a non-empty file no larger than 25 MiB. Only that one document is loaded.
- Wait for the browser to finish reading the document's page tree. For typical files this completes quickly; very large or complex page trees can take noticeably longer.
- Read the total page count shown at the top of the result panel. This number is the structural page count from the PDF, not the visible page-number label printed on the page.
- Review the grouped page-box dimensions beneath the total. Each distinct width × height pair is listed with the number of pages that share it. If you see more than one group, the PDF has mixed page sizes — for example a different cover page, a scanned insert, a foldout, or an accidental page-size change.
- Return to your Excel sheet and type or paste the total page count into the cell next to the PDF's filename. Repeat the same six steps for the next file.
Logging the counts in Excel cleanly
A consistent layout makes the workflow repeatable and keeps the spreadsheet readable as the file list grows.
Recommended columns
| Column | Content | Notes |
|---|---|---|
| A | Filename | Exact name of the PDF (for example report-2024-q4.pdf) |
| B | Pages | Integer page count from PDF Page Counter |
| C | Page sizes (pt) | Optional: distinct width × height groups, if any |
| D | Source path | Optional: folder location for later reference |
| E | Date checked | Optional: date the count was verified |
Tips for keeping the log accurate
- Enter counts as integers. The structural page count is a whole number; if a cell shows a decimal, you've recorded something other than the page tree (file size in MB, for instance).
- Do not subtract 1 for a title page and do not add 1 for an index — those adjustments are not part of the structural page count and they will drift if the source PDF is later edited.
- If a PDF's visible page-number labels start later, repeat, or use Roman numerals, the structural count is still what the tool reports, so the value in column B is independent of those labels.
- For mixed-size PDFs, paste the page-box groups into column C as a single cell entry (for example "612 × 792 pt × 12; 400 × 500 pt × 1") so the size variation is captured next to the total.
- If your workbook already uses formulas, you can place =SUM(B2:B100) in a footer cell to show the total page count across all listed PDFs without retyping anything.
Errors you may see and what they mean
PDF Page Counter is strict about what it will read. The following situations produce a visible error rather than a count, because the underlying page tree cannot be read reliably:
| Input | Result | What it means |
|---|---|---|
| Empty file (0 bytes) | Error | The picker requires a non-empty PDF. |
| Non-PDF file (e.g. .docx, .zip, .jpg) | Error | The tool only reads PDF document structure. |
| PDF larger than 25 MiB | Error | The size cap protects browser memory. Use a smaller file or split it first. |
| Encrypted / password-protected PDF | Error | Password protection is not bypassed. Remove the password locally first if you have it. |
| Damaged cross-reference data | Error | The internal index of the PDF is corrupt; the page tree cannot be read. |
| Unsupported PDF variant | Error | The library cannot parse the document structure. |
If you need to act on a too-large or encrypted file before counting, run one of the local PDF tools below — for example Split PDF to break a large file into smaller parts, or Remove PDF Password to create an unprotected copy you already have the password for. Both tools run in the browser and never upload your file.
If you have many files to log
The workflow above handles one PDF at a time, which is the safe way to keep individual counts verifiable and your files private. If your Excel log contains dozens or hundreds of files, repeating the same six steps for each row is straightforward but repetitive. The page-count result stays visible on the page until you pick another file, so you can work down a long list without losing your place.
For larger jobs that don't need an Excel sheet at all, the dedicated guide to counting pages in multiple PDFs without uploading walks through the same local-no-upload approach without the spreadsheet layer.
After the count: what the size groups tell you
Beyond the integer you paste into Excel, the grouped page-box dimensions give you extra information you can keep alongside the count. A few patterns are worth recognizing:
- One size group. Every page in the PDF uses the same width and height. The "size" column can stay blank or record the single dimension for reference.
- Two size groups, first page different. The cover page uses a different page box from the rest of the document — common for reports, manuals, and booklets that mix a square cover with standard letter or A4 inner pages.
- Many size groups. The document combines several original sources (for example, a bound PDF that includes scanned inserts at different scan sizes, or a document built from slides exported at one size and a final appendix printed at another).
- Rotation metadata present. The reported width and height stay as the unrotated page-box values. If you need the page to actually display rotated in another tool, use Rotate PDF separately.
None of these patterns affect the structural page count itself — they only affect what appears in the size-inventory column. The integer in column B stays the same as long as the page tree is unchanged.