PDF and Document Tools

PDF to Excel: Import Tables and Verify the Data

By MayreDukaan Editorial TeamPublished 5 min read
Illustration: A printed table flowing into aligned spreadsheet cells with a magnifying glass checking one numeric column.
Illustration created for MayreDukaan (not a photo)

To move PDF tables into Excel, use the PDF connector in a supported Excel Power Query installation, or export an XLSX file through Adobe Acrobat. Treat the result as imported data that needs validation, not as a recovered copy of the original workbook.

To move PDF tables into Excel, use the PDF connector in a supported Excel Power Query installation, or export an XLSX file through Adobe Acrobat. Treat the result as imported data that needs validation, not as a recovered copy of the original workbook.

Decide between table import and document export

Power Query imports tables found in a PDF. It is useful when your goal is a reusable data preparation workflow rather than a visual replica of every page. Microsoft's connector documentation identifies Excel as a supported product, while warning that capabilities can vary by host and deployment. (Microsoft Learn)

Acrobat offers a different route: convert the PDF into an XLSX workbook. Its settings control worksheet grouping, numeric separators, and text recognition. Neither route should be described as restoring the spreadsheet formulas that existed before the PDF was created. (Adobe Help)

Ask for the original spreadsheet first when you need formulas, validation rules, or a dependable ongoing data feed. A printed-looking table is not the same thing as its underlying financial model.

Import with Excel Power Query

On an Excel installation that includes the PDF connector:

  1. Open Excel and select Data > Get Data > From File > From PDF.
  2. Select your PDF and connect to it.
  3. In Navigator, inspect the detected tables rather than selecting everything automatically.
  4. Select the table you actually need.
  5. Choose Transform Data if headings, row breaks, or column types need attention.
  6. Load the reviewed result into the workbook. (Microsoft Support)

If From PDF is missing, check your installed Excel platform and feature availability. Do not assume that a general Power Query menu means every connector is available. Use the documented Acrobat export route instead if it suits your access and requirements.

Export an XLSX workbook with Acrobat

  1. Open the PDF in Acrobat.
  2. Select Convert from the global bar.
  3. Choose Microsoft Excel in the left panel.
  4. Choose XLSX from the format menu.
  5. Open Settings before conversion when you need to control grouping or recognition.
  6. Select Convert to XLSX, choose a destination, and save. (Adobe Help)

Adobe documents options to create worksheets per table, per page, or for the entire document. Choose based on the data structure. A table spanning several pages should not automatically become unrelated analysis tables merely because a page break occurred in the PDF.

Numeric settings let you specify decimal and thousands separators. Text Recognition Settings can recognize text images and set a language. Confirm that the language needed for your document is available; the existence of OCR does not establish support for every script.

Clean the table before analysis

Start with headings and row boundaries. A wrapped product description may occupy two imported rows, while a repeated page header may appear as a transaction. Remove only rows you can identify confidently. Keep an untouched import sheet or original export for comparison.

Then check data types. Codes with leading zeros should not accidentally become ordinary numbers. A date such as 03/04 can mean different days in different regional conventions. A minus sign, parentheses, or a decimal separator can change the meaning of an amount.

Use a short audit checklist:

  • Match the first and last record against the PDF.
  • Count transactions, excluding repeated headers and subtotal lines.
  • Inspect rows crossing page boundaries.
  • Verify negative amounts and decimal places.
  • Reconcile a known total against the source.
  • Confirm blank cells have not shifted neighboring values sideways.

Do not sort a single column independently of its related records. Resolve merged or misaligned rows before performing calculations. A plausible total is useful evidence, but it does not prove every individual record is correct.

Handle scans separately

If the source is a photograph of a table, text recognition must happen before reliable cell analysis is possible. Acrobat documents recognition settings in its Excel export workflow, but recognition still needs proofreading. Low contrast, skewed capture, and tiny print can leave ambiguous characters.

For an important statement, compare every critical amount with the source. If the output needs extensive reconstruction, ask the sender for CSV or XLSX rather than repeatedly converting the same poor scan. Recovering a usable table should not erase the audit trail.

Reduce the source without changing its meaning

The PDF splitter can extract the relevant statement pages as a smaller PDF before import. It does not create Excel data. The page-range guide explains selecting the right positions when printed page labels differ from file order.

Keep supporting notes when they define units, currencies, or exclusions. Removing a footnote can make a clean-looking table misleading. For several source PDFs, the PDF merging guide helps with document bundling, but merging documents is not the same as consolidating their tables.

Save a reviewable workbook

Use separate areas for raw imported data, cleaned records, and calculations. Record which source PDF you used and which transformations you made. This makes it easier to repeat the process without silently mixing new data with old corrections.

MayreDukaan does not convert PDF to Excel. The conversion or import in this guide happens in Microsoft or Adobe software. Check account entitlements and approved storage rules before processing confidential business data.

Frequently asked questions

Will PDF conversion recover Excel formulas?

Do not rely on it. These workflows import or reconstruct tables from PDF content; request the original workbook when formulas matter.

Why is From PDF missing in Excel?

Connector availability varies by Excel host and deployment. Check the documentation for your installation rather than assuming every Power Query connector is included.

What should I check first after importing?

Check headings, row alignment, leading zeros, dates, decimal separators, negative values, and a source total before analyzing the data.

Frequently asked questions

Will PDF conversion recover Excel formulas?

Do not rely on it. These workflows import or reconstruct tables from PDF content; request the original workbook when formulas matter.

Why is From PDF missing in Excel?

Connector availability varies by Excel host and deployment. Check the documentation for your installation rather than assuming every Power Query connector is included.

What should I check first after importing?

Check headings, row alignment, leading zeros, dates, decimal separators, negative values, and a source total before analyzing the data.

Useful on MayreDukaan

Sources

Facts last checked against these sources on 16 Nov 2026, 07:00 Pakistan time.

Images: Illustration created for MayreDukaan (not a photo)

More trending articles