Convert / tutorial
How to copy a table from PDF to Excel without losing the columns
The cleanest way to copy a table from a PDF to Excel is Excel’s own import, available in Excel for Microsoft 365 on Windows: select Data, Get Data, From File, From PDF, pick the table in the Navigator and select Load, and Excel loads it as rows and columns. Plain copy and paste often lands everything in one column because a PDF stores text by position, not in cells. This guide gives exact steps for four methods, explains why pasting breaks, and shows how to fix merged columns, numbers stored as text, negatives in parentheses and dates.
A worked example
Four ways to get a PDF table into Excel
Compared from Microsoft’s and Adobe’s own documentation, checked October 22, 2026. “Not documented” means the vendor page does not say.
| Method | Cost | Scanned PDFs | Keeps columns | Best for | Source |
|---|---|---|---|---|---|
| Excel: Get Data, From PDF | Included with Excel for Microsoft 365 on Windows; not listed for Office 2016 or 2019 bought outright or for Excel for Mac; needs .NET Framework 4.5 or higher | OCR not documented | Yes, detects tables; can combine tables across pages; multi-line rows may need cleanup | Text PDFs with clear tables | Microsoft, Microsoft: versions, Microsoft Learn |
| Adobe Acrobat: export to XLSX | Paid Acrobat desktop, with a 7-day Acrobat Pro free trial; Adobe also offers a free online converter | Desktop: text recognition setting during export | Yes, a worksheet per table, page or document | Scanned or complex PDFs when you have Acrobat | Adobe Help, Adobe online |
| Copy, paste, Text to Columns | Free | No: there is no text to select | Only after you split the column yourself | Small, clean tables | Microsoft |
| Open in Word, then copy | Part of Word | Not documented; Microsoft says a page that is mostly graphics may come in as an image whose text cannot be edited | If Word recognizes the table; tables with cell spacing convert poorly | Tables inside mostly text documents | Microsoft |
Step by step.
Import the table with Get Data From PDF
In Excel, select Data, Get Data, From File, From PDF. Select the PDF and Open. The Navigator displays the tables Excel found; select one to preview it. Select Load to load it into the workbook, or Transform Data to clean it in Power Query first. If Excel says the connector requires additional components, Microsoft notes the PDF connector needs .NET Framework 4.5 or higher.
Or export the PDF to Excel from Adobe Acrobat
In Acrobat on the desktop, select Convert from the global bar, choose Microsoft Excel in the left pane and XLSX in the dropdown, then Convert to XLSX and save. Under Settings you can create a worksheet for each table, each page or the whole document, set decimal and thousands separators, and turn on text recognition for scanned pages. Adobe also offers a free online PDF to Excel converter; it asks you to unlock a password protected PDF with its password first.
Or paste the text and split it with Text to Columns
Select the table text in your PDF viewer, copy it, and paste it into column A of a blank sheet. Select the column, then Data, Text to Columns. Choose Delimited, select the delimiters that separate your values (often Space or Tab) and check the Data preview, then choose a destination and Finish. If descriptions contain spaces, choose Fixed width instead and set the column breaks by hand.
Or open the PDF in Word and copy the table from there
In Word, go to File, Open and choose the PDF. Word makes a converted copy and leaves the original PDF unchanged. If Word recognizes the table, select it, copy it, paste it into Excel and check that each value landed in its own cell. Microsoft says this works best with PDFs that are mostly text and lists tables with cell spacing among the elements that do not convert well.
Clean and check the result
Convert any numbers stored as text, fix parenthesized negatives and dates, and remove repeated header and footer rows. Then compare the totals with the PDF. For a bank statement, opening balance plus the sum of the amounts should equal the printed closing balance.
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.
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
This example is fictional. A two page supplier price list pasted into Excel lands in column A as lines such as “1042 Steel bracket 25 4.80 120.00”. Text to Columns with Space as the delimiter splits “Steel bracket” into two columns, so the quantities shift right on every row with a two word description.
Running Get Data From PDF on the same file instead finds one table per page; because similar tables on consecutive pages are combined by default, the Navigator offers a single table with 38 rows and five columns. The only cleanup is a header row repeated from page 2, which a filter removes. The extended prices sum to the PDF’s printed total of 2,316.40, so the import 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.
Sources and documentation
- Microsoft: import data from data sources (Power Query), including From PDF(opens in a new tab)
- Microsoft: Power Query data sources in Excel versions(opens in a new tab)
- Microsoft Learn: Power Query PDF connector options and multi-line rows(opens in a new tab)
- Microsoft: Convert Text to Columns Wizard(opens in a new tab)
- Microsoft: convert numbers stored as text to numbers(opens in a new tab)
- Microsoft: opening PDFs in Word and how conversion works(opens in a new tab)
- Adobe: convert PDFs to Microsoft Excel formats in Acrobat(opens in a new tab)
- Adobe: online PDF to Excel converter(opens in a new tab)
Follow the source links for original definitions and current product requirements.
Questions about this guide
Why can’t I copy and paste from PDF to Excel?
Because the PDF stores text by position on the page, not in cells. Microsoft explains that a PDF stores a table as a set of lines without any relationship to the content in its cells, so Excel receives plain text and often puts it all in one column. If you cannot select the text at all, the PDF is a scanned image and needs OCR first.
How do I copy a table from PDF to Excel without losing formatting?
Import it instead of pasting: Data, Get Data, From File, From PDF, then select the table and Load, or export the PDF to XLSX from Adobe Acrobat. Both detect the table and create rows and columns. Fonts and colors are not the goal; keeping each value in its own cell is.
Can Excel extract a table from a scanned PDF?
Microsoft does not document OCR for the From PDF connector; it returns the tables it finds in the file. For a scanned PDF, use a tool that recognizes text, such as Acrobat’s text recognition setting when exporting to Excel, then check the numbers against the page.
Is there a free way to convert a PDF table to Excel?
Yes. Get Data From PDF is included in Excel for Microsoft 365 on Windows at no extra cost, copy and paste with Text to Columns costs nothing, and Adobe offers a free online PDF to Excel converter.
How do I import a table that spans several PDF pages?
Use Get Data From PDF. Microsoft documents a MultiPageTables option, on by default, that combines similar tables on consecutive pages into one table. Check the row count and remove repeated header rows afterward.
Can I extract data from a password protected PDF?
You need the password. Adobe says to unlock the PDF with its password before converting it to Excel online. Do not use tools that claim to remove passwords from files you are not entitled to open.