How do I get mortality and rate tables out of a PDF into usable data?

Tables published in PDFs (standard mortality tables, regulatory rate tables, study results) often need to be in a spreadsheet or model, so extract them rather than re-keying — a PDF-to-spreadsheet extraction maps the rows and columns into cells. The non-negotiable step is verification: actuarial work is unforgiving of a transposed or misread digit, so check the extracted figures against the source, especially around table edges and any value the extraction (or OCR, for scans) might misread. Reconcile totals or known anchor values. Extraction saves enormous re-typing, but in a domain where a wrong rate propagates through a whole valuation, extract-then-verify is mandatory, not optional.

Can I trust an automated table extraction for actuarial figures?

Treat it as a high-quality draft, never as automatically correct. Clean, well-ruled tables extract reliably; dense, multi-level, or footnoted actuarial tables are exactly where extraction can misalign columns or merge cells, and scanned tables add OCR misreads on top. Because a single wrong figure can invalidate downstream calculations, verify the extracted data against the original — spot-check systematically, confirm anchor values, and reconcile where possible. This is the same discipline as recovering any financial or scientific data from a PDF: the tool does the tedious part, and you own the correctness check. For figures feeding pricing or reserves, that check is part of doing the work properly.

Where does the actual model live — can a PDF hold it?

No. A PDF of a valuation or model output shows the results, not the live model with its formulas, assumptions, and logic — just as a PDF of a spreadsheet contains computed values, not the formulas. So keep your native model files (spreadsheets, actuarial software projects) as the source of truth for analysis, and use PDFs for reporting, sharing, filing, and archiving the outputs. If you need to rebuild a calculation from a PDF of results, you extract the figures and reconstruct the logic, which is reverse-engineering, not recovery. Treat PDFs as the report-and-record layer over the model, never as the model itself.

How do I assemble a clear actuarial report?

Actuarial reports are detailed, technical documents that often must follow professional standards, so assemble them into one navigable PDF: a clear structure, a bookmark outline and table of contents, consistent presentation of tables and results, and the required sections and disclosures. Merge supporting exhibits in a logical order, page-number the whole, and keep the tables legible. The report communicates findings and an opinion that others rely on, so clarity and precision matter, and the format should meet any applicable professional or regulatory presentation requirements. A well-organised, precise, navigable report reflects the rigor of the analysis behind it.

How should regulatory filings be handled?

Regulatory actuarial filings must be exact, complete, and in the required format, since regulators have specific submission requirements, so build the filing to the regulator's spec — required documents in the required order/format, complete, and in an archival-quality PDF where specified (embedded fonts, self-contained). Verify completeness against the requirements before submitting, since an incomplete or misformatted filing causes delays or rejection. Keep an archived copy of exactly what was filed. This is document-handling discipline; the substance and compliance of the filing are governed by actuarial standards and regulation, which your professional judgment and your firm own — this article covers the PDF mechanics.

How do I protect confidential actuarial work?

Actuarial analyses contain commercially sensitive and sometimes personal data (pricing, reserves, possibly individual data behind experience studies), so handle them confidentially: store encrypted with access limited to those who need it, transmit through secure channels, and redact sensitive details when sharing beyond the necessary audience. Where analyses rest on individual-level data, that data carries privacy obligations on top of commercial sensitivity. Treat the work product as the confidential, high-value material it is, and process documents with tools that keep files local rather than uploading. The combination of encryption, access control, and careful sharing protects both the firm's interests and any personal data involved.

Is it safe to handle actuarial documents with an online tool?

Actuarial documents are confidential and the figures must stay exact, so prefer a tool that processes files locally. ScoutMyTool extracts tables, merges and bookmarks reports, and encrypts entirely in your browser tab, so your analyses never leave your machine. For confidential or personal-data-bearing work, confirm the tool does not upload before using it — and always verify extracted figures against the source.

6 min read

PDF for actuaries: mortality tables and reports

By ScoutMyTool Editorial Team · Last updated: 2026-05-22

Actuarial work runs on tables and reports where a single wrong digit can ripple through an entire valuation — mortality and rate tables that feed the model, and detailed reports that others rely on. PDFs are how those tables arrive and how the results are reported, filed, and archived, so the document craft matters: extracting table data accurately (and verifying it), keeping the live model as the source of truth, assembling precise navigable reports, and protecting confidential analyses. This guide is the actuarial PDF workflow with that exactness front of mind. It covers document handling; the actuarial substance, standards, and compliance are your professional judgment and your firm’s.

The documents and where PDF fits

Document	Use	Key trait
Mortality / life table	Core inputs	Extract to data; verify every figure
Rate / assumption tables	Pricing, valuation	Exact; reconciled to source
Actuarial report	Findings + opinion	Navigable, precise, archived
Valuation / model output	Results	Data extractable; verified
Regulatory filing	Submission	Exact format; complete
Source data (the model)	Analysis	Keep native model, NOT the PDF

Step by step — an actuarial document workflow

Extract tables to data. Pull mortality/rate tables with PDF to Excel or PDF to CSV (see extracting complex tables).
Verify every figure. Check against the source, confirm anchor values, reconcile totals — a wrong rate corrupts the valuation.
Keep the model native. A PDF holds results, not the model — keep spreadsheets/software as the source of truth (see why PDFs don’t hold formulas).
Assemble a navigable report. Merge with Merge PDF, bookmark with Add Bookmarks, consistent tables and required sections.
Build filings to spec. Required documents/format, complete, archival PDF where specified; keep an archived copy of exactly what was filed.
Protect confidentiality. Encrypt with Protect PDF, restrict access, redact when sharing — handle individual-level data per privacy obligations (see financial-document security).
Process locally. Keep confidential analyses on your machine; verify extracted figures before relying on them.

Extracting complex tables: getting table data out cleanly.
PDF to Excel: formulas?: why the model isn’t in the PDF.
Extract data from charts: recovering figures from visuals.
PDF for accountants: financial-document security.
PDF to spreadsheet: the extraction workflow.
PDF to Excel tool: extract tables in your browser.
All ScoutMyTool PDF tools: the full toolkit.

FAQ

How do I get mortality and rate tables out of a PDF into usable data?: Tables published in PDFs (standard mortality tables, regulatory rate tables, study results) often need to be in a spreadsheet or model, so extract them rather than re-keying — a PDF-to-spreadsheet extraction maps the rows and columns into cells. The non-negotiable step is verification: actuarial work is unforgiving of a transposed or misread digit, so check the extracted figures against the source, especially around table edges and any value the extraction (or OCR, for scans) might misread. Reconcile totals or known anchor values. Extraction saves enormous re-typing, but in a domain where a wrong rate propagates through a whole valuation, extract-then-verify is mandatory, not optional.
Can I trust an automated table extraction for actuarial figures?: Treat it as a high-quality draft, never as automatically correct. Clean, well-ruled tables extract reliably; dense, multi-level, or footnoted actuarial tables are exactly where extraction can misalign columns or merge cells, and scanned tables add OCR misreads on top. Because a single wrong figure can invalidate downstream calculations, verify the extracted data against the original — spot-check systematically, confirm anchor values, and reconcile where possible. This is the same discipline as recovering any financial or scientific data from a PDF: the tool does the tedious part, and you own the correctness check. For figures feeding pricing or reserves, that check is part of doing the work properly.
Where does the actual model live — can a PDF hold it?: No. A PDF of a valuation or model output shows the results, not the live model with its formulas, assumptions, and logic — just as a PDF of a spreadsheet contains computed values, not the formulas. So keep your native model files (spreadsheets, actuarial software projects) as the source of truth for analysis, and use PDFs for reporting, sharing, filing, and archiving the outputs. If you need to rebuild a calculation from a PDF of results, you extract the figures and reconstruct the logic, which is reverse-engineering, not recovery. Treat PDFs as the report-and-record layer over the model, never as the model itself.
How do I assemble a clear actuarial report?: Actuarial reports are detailed, technical documents that often must follow professional standards, so assemble them into one navigable PDF: a clear structure, a bookmark outline and table of contents, consistent presentation of tables and results, and the required sections and disclosures. Merge supporting exhibits in a logical order, page-number the whole, and keep the tables legible. The report communicates findings and an opinion that others rely on, so clarity and precision matter, and the format should meet any applicable professional or regulatory presentation requirements. A well-organised, precise, navigable report reflects the rigor of the analysis behind it.
How should regulatory filings be handled?: Regulatory actuarial filings must be exact, complete, and in the required format, since regulators have specific submission requirements, so build the filing to the regulator's spec — required documents in the required order/format, complete, and in an archival-quality PDF where specified (embedded fonts, self-contained). Verify completeness against the requirements before submitting, since an incomplete or misformatted filing causes delays or rejection. Keep an archived copy of exactly what was filed. This is document-handling discipline; the substance and compliance of the filing are governed by actuarial standards and regulation, which your professional judgment and your firm own — this article covers the PDF mechanics.
How do I protect confidential actuarial work?: Actuarial analyses contain commercially sensitive and sometimes personal data (pricing, reserves, possibly individual data behind experience studies), so handle them confidentially: store encrypted with access limited to those who need it, transmit through secure channels, and redact sensitive details when sharing beyond the necessary audience. Where analyses rest on individual-level data, that data carries privacy obligations on top of commercial sensitivity. Treat the work product as the confidential, high-value material it is, and process documents with tools that keep files local rather than uploading. The combination of encryption, access control, and careful sharing protects both the firm's interests and any personal data involved.
Is it safe to handle actuarial documents with an online tool?: Actuarial documents are confidential and the figures must stay exact, so prefer a tool that processes files locally. ScoutMyTool extracts tables, merges and bookmarks reports, and encrypts entirely in your browser tab, so your analyses never leave your machine. For confidential or personal-data-bearing work, confirm the tool does not upload before using it — and always verify extracted figures against the source.

Not actuarial or compliance advice. This article covers handling actuarial documents as PDFs. Actuarial standards, methods, and regulatory filing requirements are governed by your profession and regulators — and always verify extracted figures against the source.

Citations

Wikipedia — “Actuary,” the profession and its work. en.wikipedia.org/wiki/Actuary
Wikipedia — “Life table,” the mortality table central to the work. en.wikipedia.org/wiki/Life_table
Wikipedia — “Actuarial science,” the discipline behind the reports. en.wikipedia.org/wiki/Actuarial_science

Exact figures, precise reports

Extract tables, assemble reports, and protect analyses with ScoutMyTool’s in-browser tools — your work never leaves your machine. Always verify extracted figures.

Open PDF to Excel →