Copy a PDF Table into Excel: Methods and Limits

Why copy and paste from PDF to Excel breaks

A PDF does not contain a table in the way a spreadsheet does. Microsoft explains that PDF is a fixed format that stores the location of text, pictures and graphics on a page, but not necessarily the relationships among them, and that a PDF stores a table as a set of lines without any relationship to the content inside the cells.

When you copy, the viewer gives Excel a stream of text in reading order. Depending on the viewer and the file, that arrives as one line per row with spaces between values, one value per line, or everything in column A. Excel has no cell boundaries to follow, which is why the import tools, which detect tables from the layout, usually do better than pasting.

If you cannot select any text at all, the PDF is a scanned image. None of the copy methods work on it until the text is recognized with OCR (optical character recognition), for example with Acrobat’s text recognition setting during export.

Which method to use

Use Get Data From PDF first if you have it: it is built into Excel for Microsoft 365 on Windows, finds tables for you, and can combine a table that continues across pages (its MultiPageTables option is on by default). Use Acrobat when Excel finds nothing useful or the PDF is scanned and you have Acrobat with text recognition. Use paste and Text to Columns for a small table you can see is clean. Use Word as a fallback when the table is in a mostly text document.

Microsoft’s table of Power Query data sources by Excel version lists the PDF connector for Microsoft 365 subscriptions on Windows, but not for Office 2016 or Office 2019 bought outright, and its list of Power Query sources in Excel for Mac does not include PDF. If From PDF is not in your Get Data menu, use one of the other methods.

Choose a method by the source, then compare the same records

Text-based table and supported Windows Excel: try the PDF connector and inspect Navigator before loading. Scanned image: use an authorized OCR-capable workflow and compare the recognized characters with the image. Small clean table: paste into a working copy and split only at demonstrated boundaries. Bank statement: use a statement-specific review workflow when wrapped descriptions and debit/credit columns need source-level correction. No method guarantees arbitrary-PDF extraction.

The sample downloads provide a real fictional statement PDF and its corresponding eight-row CSV/XLSX table. Begin with the September 4 Sample office supplies row: the PDF debit is $84.50, CSV signed amount -84.5 and running balance $3,565.50. Decimal display differs, but the value must agree. Check all eight rows, not just this example; credits $3,299.50 less debits $848.50 increase opening cash $1,250 to $3,701.

On November 1, 2026, we imported this fictional PDF through the PDF connector in Microsoft 365 Excel on Windows, build 20326. It detected a balance-summary table and a transaction table. The transaction table included eight transactions plus totals and footer lines, which must not become extra transactions. After isolating the eight rows and taking the year from the statement period, every date, description, signed amount and running balance matched the supplied CSV. The embedded video shows the alternative Fulla review-and-export workflow, not Excel menu clicks. This one-file check does not establish OCR support or compatibility with every Excel edition.

Fixing the common problems

Most cleanup falls into a few patterns. Fix them on a copy of the sheet so you can compare with the original paste.

• Everything in one column: use Data, Text to Columns. Delimited works when a consistent character separates values; Fixed width works when values line up in the same character positions.
• Two values merged in one cell, such as a date and a description: insert empty columns to the right, then split that column with Text to Columns.
• A row split over two lines, such as a long description that wraps: Microsoft suggests cleaning multi line rows in Power Query, for example filling misaligned data down with Table.FillDown or combining adjacent rows with Table.Group. On a small table, join the lines by hand.
• Numbers stored as text, often flagged with a green triangle: select the cells, select the error indicator and choose Convert to Number. Or put =VALUE(A2) in a helper column, fill down, and paste the results back with Paste Special, Values.
• Negatives in parentheses or with a trailing minus, such as (84.50) or 84.50-: use Find and Replace to turn them into a leading minus sign before converting, then check a few rows against the PDF.
• Dates that stay as text or swap day and month: check which order the PDF uses, then rebuild each date from its parts with =DATE(year, month, day) in a helper column, and spot check a day above 12 to confirm the order.
• Page headers, footers and subtotals repeated in the data: filter the column for the header text and delete those rows, and remove subtotal lines so totals are not counted twice.

A worked example

Fictional price-list illustration: the text 1042 Steel bracket 25 4.80 120.00 has a two-word description. Splitting on every space creates six fields instead of the intended five: product, description, quantity, unit price and extended price. The supported line total is 25 × 4.80 = 120.00.

A PDF connector may identify table boundaries more effectively, but its actual Navigator result depends on the file. Preview every page, confirm the description stays in one field and remove only source-confirmed repeated headers. Do not assume that a plausible column layout proves the table is complete.

Bank statements are a special case

Statement tables are harder than most: descriptions wrap onto two lines, money in and money out sit in separate columns, the running balance sits beside them, and every page repeats its headers. A general converter can produce cells that look right while a wrapped line has become its own row or a debit has landed in the credit column.

Whatever method you use, check the result against the statement: opening balance plus credits minus debits should equal the closing balance, and the running balance should follow from each row. A dedicated bank statement converter such as Fulla Ledger scores each draft with automatic checks, links each row to the highlighted area of the page it came from, lets you correct rows and check balances, and exports nothing to Excel until you approve the rows.