A table looks like a tidy grid on the page, but a PDF does not store it that way. Under the hood a PDF only records where each character sits, not which cell it belongs to, so when you copy a table and paste it into Excel the structure falls apart: everything lands in a single column, numbers turn into text, and the headers drift out of line. This guide covers every reliable way to convert a PDF table to Excel and keep the rows, columns, and amounts intact, whether the file is a clean native PDF or a scan.
The quickest route is the converter at the top of this page. Upload the PDF, and it detects the table grid, rebuilds each column, and returns a clean .xlsx where the numbers come back as real numbers you can sum. Below are the manual methods too, so you can match the approach to your document and to how often you do this.
How do I convert a PDF table to Excel?
The most reliable way to convert a PDF table to Excel is to use a converter that detects the table grid and maps each value to its own cell, rather than copying and pasting. Upload the PDF, let the tool reconstruct the columns and rows, and download a .xlsx with the amounts kept numeric. Copy and paste works only for short, simple native tables and almost always needs a text-to-columns cleanup afterward. For multi-page reports, scans, or anything with merged headers, a real converter saves the manual repair.
Why does a PDF table collapse into one column in Excel?
It collapses because a PDF has no actual table, only text placed at coordinates, so Excel has nothing telling it where one cell ends and the next begins. When you paste, Excel treats each line as a single string and drops it into one column. The visual gaps between columns on the page are just spacing, not delimiters Excel can read. A table-aware converter solves this by analyzing the spacing and lines to infer the grid, which is why its output lands in separate columns while a paste does not.
How do I convert a PDF table to Excel using Microsoft 365?
On Excel for Windows with Microsoft 365, use Data > Get Data > From File > From PDF, pick the file, and choose the detected table in the Navigator before clicking Load. Power Query reads the native text and brings the table in as columns, which beats copy and paste for clean PDFs. Two limits to know: this connector exists only on Windows (Excel for Mac does not have it), and it cannot read scanned or image-only PDFs because there is no live text to pull. For those, see the OCR method below.
If you have it, the full sequence is:
- Open a blank workbook and go to the Data tab.
- Click Get Data > From File > From PDF and select your file.
- In the Navigator, pick the table or page that holds your data.
- Use Transform Data if you need to remove blank rows or promote headers, then Load.
- Check that amounts and dates came in as numbers, not text, before you build formulas.
No Microsoft 365? The browser converter on this page does the same job without it. See how to import a PDF into Excel without Microsoft 365 for that path.
How do I copy a table from a PDF to Excel and keep the columns?
To keep the columns when copying, paste the table into a single Excel column first, then use Data > Text to Columns and split on spaces or a fixed width to break it back into cells. This is the manual fix when a converter is not available, but it is fiddle-prone: amounts with thousands separators, negative values in parentheses, and ragged spacing all confuse the split. For anything beyond a small, evenly spaced table, a converter that detects the grid is faster and cleaner. Our guide on copying a table without losing columns walks through the Text to Columns steps in detail.
How do I convert a scanned PDF table to Excel?
A scanned PDF is an image, so neither copy and paste nor the Get Data connector can read it; you need a converter with OCR. Optical character recognition reads the printed characters off the image, then a table-detection step rebuilds them into rows and columns. Upload the scan to a tool with OCR built in, and it reconstructs the grid the same way it would for a native PDF. The converter on this page runs OCR automatically, which is the one thing the free Excel and copy-paste tricks cannot do. For the full walkthrough, see converting a scanned PDF to an editable Excel file.
How do I convert a PDF with multiple tables to Excel?
When a PDF holds several tables, a good converter detects each one separately and keeps them as distinct blocks, so you do not get two grids merged into a jumble. Some tools place each table on its own worksheet; others stack them with a gap between. Decide upfront whether you want them combined for one continuous dataset or split apart for separate analysis. We cover both directions in extracting multiple tables from a PDF and converting a PDF to Excel with multiple sheets.
Why do numbers from a PDF table come in as text in Excel?
Numbers arrive as text when the converter or paste captures them as character strings rather than numeric values, usually because of a currency symbol, a thousands comma, a trailing space, or a negative shown in parentheses. Text-formatted numbers will not sum and sort alphabetically instead of by value. A table-aware converter keeps amounts numeric from the start, including parenthesized negatives. If you still hit it, our fix for numbers stored as text and for dates stored as text shows how to convert them in a few clicks.
What is the most accurate way to convert a PDF table to Excel?
The most accurate way is a converter built specifically to detect table structure, because it reconstructs the grid from the PDF's spacing and lines instead of guessing from a paste. Accuracy depends on the source: a clean, native PDF converts almost perfectly, while a low-quality scan leans on OCR and benefits from a quick review of any unusual characters. For finance work where a single misread digit matters, always reconcile the converted total against the figure printed on the original. Accountants and bookkeepers who do this monthly should see our PDF to Excel for accountants workflow.
A quick checklist for converting PDF tables
- Clean native PDF, one table: the converter on this page, or Get Data > From PDF on Windows.
- Pasted data stuck in one column: Data > Text to Columns, or re-do it with a real converter.
- Scanned or photographed table: you need OCR, so use the converter, not copy and paste.
- Many tables or many files: use batch conversion and decide combined versus separate sheets.
- Always reconcile the converted total against the printed figure before you rely on it.
A PDF table is only stubborn because the format hides the grid the eye sees so clearly. Match the method to the document, lean on a table-aware converter for scans and volume, and check the numbers came in numeric, and you will have a clean spreadsheet in minutes instead of retyping rows by hand. If your tables are scanned invoices rather than statements, invoice OCR software reads them straight into Excel, and teams pulling tables out of thousands of documents at once can lean on document data extraction software built for that scale.