How to Convert PDF Tables to Excel and Check the Spreadsheet

2026-09-11SanPDF Editorial Team27 min read

Import PDF tables with Excel Power Query on Windows, or rebuild a small table manually, then check rows, leading zeros, dates and totals before using the XLSX.

How to Convert PDF Tables to Excel and Check the Spreadsheet

To move a PDF table into Excel, use Data > Get Data > From File > From PDF in a supported Windows edition of Excel, select the table in Navigator, and choose Transform Data before loading it. Check the imported rows, identifiers and totals against the PDF, then save the workbook as XLSX. For a small table, copying or rebuilding the rows manually may be simpler.

This guide covers importing a local PDF in Excel or rebuilding a small table by hand. It does not require an online PDF converter.

What PDF-to-Excel conversion actually preserves

A PDF table is a visual arrangement of text and lines on a page. An Excel table stores values in rows and columns with data types that affect sorting and calculations. Importing a PDF means interpreting that page layout; it does not recover the original workbook, formulas or cell rules.

The goal is a usable dataset, not an exact visual copy of the PDF. A spreadsheet can look tidy while placing an amount in the wrong column or turning an invoice ID such as 000184 into 184.

Illustrative PDF and spreadsheet tables showing a lost leading zero and a description shifted into the invoice ID column

This is an original illustrative diagram, not an Excel screenshot or the result of a product test. The highlighted examples show why structure and data types need separate checks.

Check your Excel version and the PDF first

The main method below is for Excel for Microsoft 365 on Windows with the PDF connector available. Microsoft's Power Query data sources by Excel version lists PDF support in the Windows Microsoft 365 columns. Having Power Query alone does not mean every connector is included.

Do not assume the same local From PDF workflow exists in Excel for Mac, Excel for the web, mobile Excel or every perpetual-license edition. Microsoft's Mac connector list does not list PDF import; its web support has a different set of data-source and authentication conditions. If From PDF is absent, check your exact edition and update channel against the official list, or use the small-table method below. This guide does not require you to buy or upgrade Excel.

Microsoft's PDF import instructions also note that the Windows PDF connector requires .NET Framework 4.5 or later. If Excel reports missing components, follow that official guidance or ask your IT administrator rather than installing an unofficial converter.

Before importing, open the PDF and note the table headings, page range, record count if known, and any subtotal or continuation pages. Try selecting a word or number. Selectable text is a useful first check, but it does not guarantee that the importer will recognize the table correctly.

If the page is only an image, it may need a separate OCR-capable workflow or manual transcription. OCR can recover text, but searchable text is not the same as reliable rows and columns. Check recognized values against the scan; do not assume that running OCR makes the next import successful.

Method 1: Import the table with Excel Power Query

1. Open the PDF connection

In a new or existing workbook, select Data > Get Data > From File > From PDF. Choose the local PDF and select Open. Excel opens Navigator with the information it can identify in the document.

These controls are documented in Microsoft's import guide, File: PDF section. The Power Query PDF connector reference describes the Navigator and transformation workflow in more detail.

2. Select the right table, not just the first result

Select a candidate table in Navigator and compare the preview with the PDF. Check its headings, first record and last record. A document can contain several detected tables, and a table spanning pages may need more than one selection or cleanup step.

Choose Transform Data to inspect the selection in Power Query Editor. Load is an alternative when the data is already suitable, but reviewing it first gives you a chance to correct types and structure before it reaches worksheet cells.

3. Preserve identifiers before changing types

Inspect the column types and the Applied Steps list. If an automatic Changed Type step has converted identifiers to numbers, edit or remove the affected conversion before applying a Text type to those columns. Check the earlier step's values: changing the type later cannot recover zeros or digits that are already gone.

Use Text for identifiers such as invoice numbers, postal codes, SKUs and account numbers when their exact characters matter. Use an appropriate numeric type for amounts you intend to calculate. Keep ambiguous dates as text until you know the source's day/month convention.

This distinction is more important than formatting. An identifier describes a record; an amount measures something. Treating both as numbers can damage the identifier without making the spreadsheet look obviously wrong.

4. Clean the structure and load the result

Compare each column with the PDF before splitting combined fields, removing repeated headings or filling blank cells. A blank may mean missing data, a grouped heading or part of a multiline record. Do not fill every blank automatically.

For a wrapped description, establish which lines belong to one record before combining rows. Microsoft's PDF connector documentation specifically notes that multiline rows can require cleanup. Repeated page headings should not become ordinary data rows or be counted in totals.

When the preview is ready, use Home > Close & Load in Power Query Editor to load the result into Excel. Save the workbook as an Excel Workbook (.xlsx), keeping the original PDF separately.

5. Keep corrections safe from refresh

A query is a repeatable import, not just a one-time paste. Refreshing it can replace values in its output table. Make repeatable cleanup changes in the query, or copy the loaded values to a separate working sheet before making manual corrections. Keep an untouched import and a short correction log so that later changes are traceable.

Method 2: Copy or rebuild a small table manually

For a short price list or a few invoice rows, manual entry can be easier to audit than a complicated import. It is also an option when your Excel edition lacks the PDF connector.

  1. Create headings in Excel that match the PDF, with one column for each field and one row for each record.
  2. Format identifier columns as Text before pasting or typing. Leave amounts separate from codes and descriptions.
  3. Copy a small selection from the PDF if its text can be selected. If everything lands in one cell or fields become jumbled, undo it and work one row or column at a time.
  4. For a scan, transcribe the values from the image. Mark anything unclear instead of guessing a character or a decimal point.
  5. Compare every entered record with the source, including blank fields, leading zeros, negative signs and the final row.
  6. Save the XLSX and retain the PDF and a note of any unresolved values.

Avoid splitting text on every space: descriptions often contain spaces, so that rule can break one field into several unrelated columns. Choose a delimiter or boundary only when the source structure supports it.

Five checks before you use the spreadsheet

Check 1: Headers, record counts and page boundaries

Read across a PDF row and find the corresponding cells in Excel. The amount must remain under Amount, not Notes or Balance. Compare records near the top, middle and bottom as an initial diagnostic, then inspect all records that matter to the intended use. A spot-check is not proof that every value is correct.

At each page boundary, check the last record on one page and the first record on the next. Look for missing or duplicated rows, repeated headings, and descriptions that continue across pages. If the source supplies a record count, compare that count after excluding titles and subtotals.

Check 2: Leading zeros and long identifiers

Microsoft explains in Keeping leading zeros and large numbers that Excel can remove leading zeros when numerical text becomes a number. Excel worksheet numbers have a maximum precision of 15 significant digits; identifiers containing 16 or more digits should be preserved as text.

For an illustrative invoice ID, 000184 and 184 are different strings even though their numerical values are equal. If the zeros disappeared, return to an earlier query step that still has the original text, or format destination cells as Text and re-enter the complete ID from the PDF. Formatting an already damaged value does not restore its lost characters. A custom display format may show zeros without preserving the original text for another system.

Scientific notation alone does not prove a value was corrupted, but it is a reason to inspect the full identifier and its stored type. Compare long codes character by character rather than trusting the shortened display.

Check 3: Dates, decimals and negative values

The date 03/04/2026 can mean March 4 or 3 April. Confirm the source convention before assigning a date type or sorting. If the convention is unknown, keep the original text and record the uncertainty.

Check whether commas and periods mark decimals or thousands in the source. For example, 1,250.00 and 1.250,00 may represent the same amount under different locale conventions. Include at least one decimal amount, a large amount and a negative amount in the comparison. Parentheses, minus signs and credit labels can carry meaning that is easy to lose.

Check 4: Totals and formulas

A PDF generally shows a calculation's result, not the original Excel formula. Rebuild the calculations you need after checking the detail rows.

For a simple subtotal with amounts in cells D2 through D20, =SUM(D2:D20) is a useful cross-check. Do not include both detail rows and their subtotal in the same sum. Tax and closing balances may require a rate, adjustments or an opening balance rather than a sum of every visible number.

If the result differs from the PDF, inspect missing rows, duplicates, negatives, rounding and numbers stored as text before changing the total. A formula can calculate correctly while using the wrong input range.

Check 5: Save a reviewed copy with known limitations

Keep the original import separate from the cleaned data. For corrections, record the PDF page, workbook sheet and cell, original value, corrected value and reason. If a figure remains unreadable or a row cannot be reconciled, flag it before the workbook is used for payments, reporting or another import.

Illustrative spreadsheet review checklist covering headers, page-break rows, totals, leading zeros, dates and negative values

This original checklist is a review aid, not a product screenshot or an accuracy guarantee.

If the import is empty or the layout is messy

If Navigator offers no usable table, check whether the PDF is a scan and whether its text is selectable. Try a different detected table when one exists; do not load an empty or unrelated preview just because it is listed first.

For very large documents, Microsoft's PDF connector reference describes advanced Pdf.Tables options such as StartPage and EndPage for smaller page ranges. These require query editing and are optional, not a prerequisite for the basic method. Keep track of every range so that splitting the work does not omit pages.

If the issuer can provide the original XLSX or a CSV export, ask for it before spending hours rebuilding a complicated table. A structured source usually avoids the need to infer columns from a page layout, though its values still deserve validation.

The useful result is not merely an XLSX that opens. It is a table whose structure, identifiers and calculations have been checked to the level your next task requires.

SanPDF

Batch conversion · No size limit · Fast processing

Download now

186,400+ downloads

Frequently Asked Questions

How do I import a PDF table into Excel?
In Excel for Microsoft 365 on Windows with the PDF connector available, select Data > Get Data > From File > From PDF. Choose the file and table, select Transform Data to review it, then Close & Load. Check the worksheet against the PDF and save it as XLSX.
Is From PDF available in every version of Excel?
No. This guide covers the Windows Microsoft 365 PDF connector. Power Query availability does not guarantee every connector. Check the official data-source list for your edition; do not assume the same local PDF import steps work on Mac, the web or mobile Excel.
Can I use this method with a scanned PDF?
A scanned page may need a separate OCR-capable workflow or manual transcription. OCR can recover text but does not guarantee correct table structure or a successful subsequent import. Compare the recognized values with the scan.
How do I preserve leading zeros and long numbers?
Keep identifiers as Text before numeric conversion or entry. Excel worksheet numbers have a maximum precision of 15 significant digits. Formatting a value afterward cannot recover lost zeros or digits; use the original source or an earlier query step that still contains the complete text.
Will PDF totals become live Excel formulas?
Do not assume they will. PDF totals usually represent displayed results. Verify the imported detail rows, rebuild the calculations you need, and compare them with the source without double-counting subtotal rows.
Do I need an online PDF converter for this tutorial?
No. This guide covers importing a local PDF in Excel with Power Query or rebuilding a small table by hand. Neither method requires an online PDF converter.

Share This Article

SanPDF

SanPDF

186,400+ downloads

Download now