Import a PDF table with Excel's “Get Data from PDF”

Steps

1. Data › Get Data › From File › From PDF, choose the file.
2. The Navigator lists detected Table items and whole Page items. Click each to preview.
3. Pick the table(s) and Load, or Transform Data to clean in Power Query (promote headers, change types, remove summary rows).

Combine a table that spans many pages

Statements usually produce one table per page. In Power Query: select all page tables, use Append Queries as New, then remove repeated header rows with a filter. Make sure each page's columns line up – if one page is detected with an extra column, the append misaligns.

“From PDF” is missing

• Excel for Mac doesn't have the PDF connector. Microsoft lists it for Windows only.
• On Windows, it needs Microsoft 365 or a recent version with .NET Framework 4.5 or later; older Office 2016/2019 builds may not show it.
• Organisation policies can hide connectors.

Table is empty or columns are merged

• Scanned PDF: there is no text to read. See scanned statements.
• Statements without ruling lines: Power Query guesses columns from spacing and often merges description and amount, or splits a date across two columns.
• Wrapped descriptions: a two-line description becomes two rows – the second with no date or amount.

When a statement reader is easier

Columnry is built for statements: it finds the date/description/debit/credit/balance columns across all pages, joins wrapped lines, infers missing years, and checks every row against the running balance, so you see at a glance whether something was missed. It runs in any browser, including on a Mac.