PDF Conversion Issues

How to Fix Excel Get Data from PDF Showing No Tables

Adam DavisAdam Davis Oct 29, 2026 870 views

Question details

The user is attempting to import data from a PDF file into Excel, but the import wizard fails to detect any tables or pages.

How to Fix Excel "Get Data from PDF" Showing No Tables
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing tabular data from a PDF document into an Excel spreadsheet using the Power Query Get Data feature.
Observed behavior
Excel's navigator window displays 'No tables found' or fails to list any pages, preventing the user from extracting the required data.
Before you start

Open your PDF in any standard viewer and try to highlight the text with your cursor; if you cannot select individual words, your PDF is an image-based scan and will require OCR processing before Excel can read it.

Solution 1Recommended

Convert Image-Based PDFs to Text Using OCR

If your PDF was created from a scanner, it contains images of text rather than actual text data. You must process it with Optical Character Recognition (OCR) software first.

Excel's native 'Get Data from PDF' feature relies on structured text elements. It cannot read tables trapped inside a flat image.

Using an OCR tool will analyze the image, recognize the characters, and generate a searchable text layer that Excel's Power Query can successfully parse.

1
Open your PDF in an OCR tool

Launch an OCR-enabled PDF editor (such as WPS Office or Adobe Acrobat) and open your problematic PDF file.

2
Run text recognition

Navigate to the Tools or Edit menu and select 'OCR' or 'Recognize Text'. Choose the primary language of your document and initiate the scan.

3
Save the searchable PDF

Once the OCR process completes, verify that you can now highlight text. Click 'File' > 'Save As' to save the newly searchable PDF to your computer.

4
Import into Excel

Open Excel, go to the 'Data' tab, select 'Get Data' > 'From File' > 'From PDF', and choose your newly saved file to import the tables.

Convert Image-Based PDFs to Text Using OCR
High Quality Scans Needed: OCR accuracy depends heavily on the scan quality. Ensure your original document has good contrast and minimal skewing for the best table extraction results.
Convert PDF to Excel Easily

Convert PDF to Excel Directly with WPS Office

Bypass Excel's complex data import errors by using WPS Office's dedicated PDF to Excel converter. It features built-in OCR technology to accurately extract tables from scanned documents and image-based PDFs without the hassle of Power Query.

  1. 1. Open PDF in WPS Office: Launch WPS Office and open the PDF file that contains the tables you want to extract.
  2. 2. Select PDF to Excel: Navigate to the 'Tools' tab on the top ribbon and click the 'PDF to Excel' button.
  3. 3. Configure conversion settings: In the pop-up dialog, ensure the OCR option is checked if your document is a scan, and select the output destination.
  4. 4. Convert and edit: Click 'Convert'. Within seconds, a fully formatted Excel spreadsheet will open, ready for editing and calculation.
Built-in OCR easily extracts tables from scanned and image-based PDFsHigh accuracy in preserving original table structures and cell formattingOutputs directly to fully compatible Microsoft Excel (.xlsx) formatsUser-friendly interface requires no complex data import configurations
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say 'No tables found' when looking at a PDF that clearly has a grid?

This happens when the visual grid in the PDF is either an image (a scanned document) or constructed using complex vector lines rather than semantic table tags. Excel's importer relies on underlying text and structural metadata to identify tables.

Do I need a paid tool to use OCR on my PDF before importing to Excel?

While premium tools offer advanced batch processing, there are many free online OCR converters available. Alternatively, comprehensive office suites like WPS Office include built-in PDF to Excel conversion with OCR capabilities.

Can Excel extract tables from a password-protected PDF?

If the PDF only has an 'Open' password, Excel will prompt you to enter it during the import process. However, if the PDF has a 'Permissions' password that restricts content copying and extraction, Excel will fail to import the data until the restriction is removed.

What should I do if Excel imports the data but the formatting is completely broken?

If the native import fails to retain the layout, use the 'Transform Data' option in Power Query to manually shape and clean the data. For severely broken layouts, using a dedicated third-party PDF to Excel converter often yields much better formatting retention.