Why does copying from a PDF and pasting into Excel usually not work?

Copying takes only the text characters to the clipboard, not the cell structure, because no such structure exists in the PDF to begin with. What arrives when you paste into Excel is plain text line by line, and all the values end up in a single column. In some cases the gaps between columns turn into tab characters and the paste happens to work correctly, but that's a coincidence depending on how the source document was produced. Running the Text to Columns wizard after pasting can make the result usable with evenly spaced tables.

Can Excel's own Get Data feature read PDFs?

Current Excel versions tied to a Microsoft 365 subscription have a Get Data from PDF option under the Data tab. This feature works through Power Query, listing the tables in the file and letting you choose which to import. It gives quite good results with regular, ruled tables, and the ability to refresh the query when the source file is updated is a major advantage. However, it doesn't work with scanned PDFs, and the feature isn't present in every Excel version; you won't have it in older versions or if you use a different spreadsheet program.

In which cases does manual entry finish faster?

As a general measure, if the table is under twenty or thirty rows and its structure is complex, manual entry usually finishes faster. With small tables of complex structure, fixing cell shifts, repairing number formats, and verifying accuracy after conversion can take longer than typing the data from scratch. Entering it manually also puts the result directly into the column layout you want, with no leftovers to clean up. Above a hundred rows, however, the balance tips decisively in favour of conversion.

If different methods give different results, which one should I trust?

The right approach is to trust none of them blindly, and instead verify the result against an independent measure. The most practical measure is comparing totals: if there's a total row in the original PDF, sum the same column in the exported table and compare the two values. Whichever method matches has worked correctly. If there's no total row, comparing ten randomly chosen rows against the original is also a sufficient check. Differences between methods usually stem from empty cells or merged headings, and only verification will tell you which method interpreted the situation correctly.

Ways to Get a PDF Table into Excel: Copy-Paste, Excel's Own Tool, or a Converter?

One table, four different export routes

Anyone who needs to do calculations with a table locked inside a PDF faces the same question: how do I get this data into Excel with the least effort and the fewest errors? There isn't a single answer; it depends on the size and structure of the table and how often you do this job.

In this article we compare four routes: copy-paste, Excel's own data import feature, dedicated conversion tools, and manual entry. Let's clarify where each genuinely helps and where it wastes your time.

Route 1: Copy and paste

The most obvious and most frequently attempted method is selecting the table in a PDF viewer, copying it, and pasting it into Excel.

What actually happens: Copying takes only the text characters, because cell structure doesn't exist in a PDF in the first place. When you paste into Excel, all the rows generally end up in a single column. Sometimes you get lucky and the gaps between columns turn into tab characters, producing a correct distribution, but that's a coincidence depending on how the source file was produced, not behaviour you can rely on.

The rescue route: After pasting, selecting the column and running the Text to Columns wizard on the Data tab usually distributes the data into proper columns. With fixed-width, neatly aligned tables, this pairing is often enough.

Strength: It requires no tool, the file goes nowhere, and it takes seconds.

Weakness: It becomes unusable with multi-column, irregular tables. With tables spanning pages you have to copy each page separately.

When to use it: Small, simple, single-page tables; situations where you need only a few values.

Route 2: Excel's own PDF data import feature

In current Excel versions, PDF appears among the options for getting data from a file under the Data tab. This feature uses Power Query in the background to scan the file, list the tables it finds, and let you choose which one to import.

Strengths: The file never leaves your computer, which is a significant privacy advantage. Results are quite accurate with well-structured, ruled tables. Its most valuable characteristic is that the query can be saved: when the source PDF is updated, you can refresh the query to update the data, which is a serious gain for anyone working with regular monthly reports. You can also record cleanup steps such as deleting columns, changing types, and filtering rows within Power Query.

Weaknesses: It doesn't work at all with scanned PDFs, because it has no OCR capability. It isn't present in every Excel version; you won't have it in older versions or in alternatives such as LibreOffice Calc. The Power Query interface has a learning curve on first use.

When to use it: If you have a current version of Excel, the document is text-based, and especially if you work with reports that recur regularly in the same format, this is the most efficient route.

Route 3: Dedicated PDF to Excel converters

Online tools that run in your browser, or desktop PDF software, take the whole file and produce XLSX output.

Strengths: They require no installation and no particular Excel version; they work whatever device you're on. They process tables across multi-page documents in one go. Professional desktop software also offers OCR support for scanned documents, something Excel's own feature can't do.

Weaknesses: With online tools, the file is uploaded to a server for processing; with financial data or tables containing personal information, that's something to consider. Checking how long files are retained is a good habit before using a service.

An honest note is warranted here: a significant proportion of online tools, ours included, rely on open-source engines such as LibreOffice for conversion. This works quite well with ruled, regular tables; but with borderless tables, merged cells, or nested headings you shouldn't expect an identical result. Plan on verifying the result and making small corrections as a normal part of the process.

When to use it: If Excel's own feature isn't available or doesn't work; with multi-page documents; when you need an OCR-capable solution for scanned documents; when you need a quick result from a different device. The PDF to Excel tool is a practical starting point for these scenarios.

Route 4: Manual entry

Often underrated, but genuinely the fastest route in some situations, is simply typing the data in.

Strengths: The result is in exactly the column layout you want; no leftover formatting to clean up, no number formats to fix, no merged cells to unmerge. Because you're reading the data as you enter it, you gain command of the content and notice inconsistencies.

Weaknesses: As the row count grows, the time cost multiplies rapidly, and there's a real risk of transcription errors with figures.

When to use it: Tables under twenty or thirty rows; small tables with very complex structure; situations where the data needs to go into your own specific template.

Decision guide

A small five-row table you need only once: Copy and paste, or just type it in.
A report arriving monthly in the same format: Excel's Power Query based data import; set the query up once and refresh it each month.
Scattered tables across a fifty-page document: A dedicated converter processes them all in one pass.
An archive of scanned old financial statements: OCR-capable professional desktop software, followed by mandatory numerical verification.
Financial data that must not leave the organisation: Excel's own feature or a local desktop solution.
A complex fifteen-row table with merged cells: Manual entry will probably be faster and will certainly be cleaner.

The rule that applies whichever method you choose

There's one fact common to all methods: table structure is usually not stored in a PDF at all, so every tool has to guess cell boundaries. A more expensive tool improves the accuracy of that guess but doesn't eliminate the uncertainty.

That's why verifying the result is indispensable regardless of method. The fastest verification is comparing totals: put the total row from the original alongside the total you calculate in Excel. If they match, the export is complete. If they don't, the difference also gives you a clue about the source of the problem.

There's also a limit no method can overcome: formulas. When an Excel file is saved to PDF, the formulas are calculated and their results drawn; the formulas themselves are never written to the file. Consequently no export method can bring formulas back. If you need the formulas, the only route is to request the original file from its source.

In summary

With small, simple tables copy-paste is enough. For regularly recurring reports, Excel's own data import feature is the most efficient route thanks to its refreshable query structure. For multi-page or scanned work, or work accessed from a different device, dedicated converters come to the fore. And with small but complex tables, manual entry still gives the cleanest result. Whichever you choose, verifying the result with a total comparison is the shortest and most valuable step in the whole process.