Power Query Problems

How to Import PDF Tables with Hyperlinks into Excel

Maira Mehtab Sep 27, 2026 868 views

Question details

The user needs to extract tabular data including embedded product hyperlinks from a PDF file into Excel, but the hyperlinks are missing after importing.

How to Import PDF Tables with Hyperlinks into Excel

Product: Microsoft Excel (Power Query)
Device & OS: not provided
Scenario: Importing a PDF table containing text, prices, and embedded product URLs into an Excel spreadsheet for analysis or inventory management.
Observed behavior: Excel's Power Query successfully imports the text and pricing data from the PDF table, but completely drops the embedded product hyperlinks.

Before you start

Check your PDF document to see if the product links are plain text (e.g., https://...) or embedded behind text, as plain text URLs can be easily converted back to links in Excel.

Solution 1Recommended

Request the Original Source File

Because Power Query cannot extract underlying PDF metadata, securing the original source file is the most reliable way to retain embedded links.

Microsoft Excel's Power Query PDF connector has a known design limitation: it only parses visible text and table structures. It does not read or import embedded hyperlink metadata.

Attempting to force Power Query to extract these links will not work natively. The most flawless workaround is to bypass the PDF format completely.

Contact the file owner

Reach out to the person or department that generated the PDF document containing the product tables.

Request an Excel or HTML format

Ask them to export and send the original file as an Excel workbook (.xlsx), a CSV, or an HTML web file, which will naturally preserve all embedded hyperlinks when opened.

Power Query Limitation: This is not a bug but a design limitation of how the PDF connector parses documents in Power Query.

Solution 2

Automate Link Generation with Power Automate Desktop

If the hyperlinks follow a predictable pattern based on product names or IDs, you can construct them using automation tools.

Efficient PDF Management

Easily Convert PDFs to Excel with WPS Office

If Excel's native tools are limiting your workflow, WPS Office offers a powerful, built-in PDF toolkit designed to seamlessly convert PDF documents into editable Excel spreadsheets. Simplify your data extraction tasks with a lightweight, user-friendly suite.

1. Launch WPS Office: Open WPS Office and click on the 'PDF' tab located on the left-side navigation panel.
2. Select the Conversion Tool: Click on 'PDF to Excel' from the top toolbar and select the PDF file containing your product tables.
3. Convert and Save: Choose your output directory and click the 'Convert' button. Your table will instantly open as an editable spreadsheet.

Dedicated PDF to Excel conversion tool directly within the appHighly compatible with Microsoft Excel formats (.xlsx and .xls)Preserves original table formatting and structures accuratelyFree, lightweight, and features a familiar tabbed interface

Frequently Asked Questions

Why does Power Query drop hyperlinks when importing from a PDF?

Power Query's PDF connector is specifically designed to extract raw text and recognize tabular structures. It does not currently parse or extract the underlying metadata, such as HTML tags or embedded hyperlink properties.

Can I use VBA to extract hyperlinks from a PDF into Excel?

Yes, advanced users can utilize VBA combined with Adobe Acrobat's API or third-party PDF parsing libraries to extract hyperlinks. However, this requires programming knowledge and having the full version of Adobe Acrobat installed.

How do I make text URLs clickable after importing them to Excel?

If your PDF imported plain text URLs instead of embedded links, you can easily make them clickable. Click on an empty cell next to the URL and type the formula =HYPERLINK(A1) (assuming your text URL is in cell A1), then press Enter.

Excel & Data Problems