You have a report, a statement, or a price list locked inside a PDF, and you need that table living in Excel so you can sort it, total it, and work with it. The catch most people hit on the first try: a straight copy and paste dumps the whole table into a single column, or scatters the figures so nothing lines up. That is not your mistake. A PDF stores each piece of text at fixed coordinates on the page, not in real rows and columns, so the page only looks like a grid. Move it the wrong way and the structure falls apart.
Below are the methods that actually transfer a PDF table into Excel with the rows and columns intact, from the fastest to the most manual, plus the one accuracy check that catches the silent errors before they reach a spreadsheet someone relies on.
How do I transfer a PDF table to Excel?
The fastest way to transfer a PDF table to Excel is to run the PDF through a table-aware converter that reads the layout and rebuilds the rows and columns automatically, then download the result as an XLSX file. Upload the PDF using the tool at the top of this page, let it map the table, and open the file in Excel. This avoids the one-column collapse you get from copy and paste, and it handles multi-page tables in a single pass.
For a one-off table from a clean, digital PDF you can also paste it manually, and on Excel for Windows you can pull it in with a built-in connector. Each method has a place, so match the method to the file.
Why does my PDF table paste into one column?
A PDF table pastes into one column because the file has no underlying grid for Excel to read. When you copy from a PDF, you copy a stream of text in the order it was stored, and Excel drops that whole stream into the first cell or down a single column. The visual gaps between columns on the page are just spacing, not cell boundaries, so Excel has nothing telling it where one column ends and the next begins. To keep the columns, you need a method that interprets the layout instead of copying raw text.
How do I use Excel's Get Data from PDF feature?
On Excel for Windows (Microsoft 365 or Office 2021) go to Data, then Get Data, From File, From PDF, and pick your file. Excel opens a Navigator that lists each table it found; click one to preview it, then click Load to drop it onto a worksheet with the columns and rows in place. It works well on digital, text-based PDFs and can import several tables at once. Two limits matter: it is not available in Excel for Mac, and it cannot read scanned or image-only PDFs because there is no text layer to parse.
How do I transfer a PDF table using Microsoft Word?
Word is a useful bridge when a PDF is stubborn or your Excel version has no PDF connector. Right-click the PDF, choose Open with, and select Word; Word converts the file and usually rebuilds the table as a real, editable Word table. Scroll to the table, select it, copy it with Ctrl+C, then paste it into Excel with Ctrl+V. Because the data is already in table cells in Word, it lands in Excel with the column and row structure preserved, leaving only light cleanup. If Word brings the data in as plain text instead of a table, select it and use Insert, Table, Convert Text to Table.
How do I copy and paste a PDF table and keep the columns?
Direct copy and paste is the quickest route for a single small table from a digital PDF. Select the table in your PDF reader, copy it, and paste it into Excel. When it lands in one column, select that column and use Data, Text to Columns; choose Delimited, tick Space (and turn on "Treat consecutive delimiters as one") or Fixed Width, and Excel splits the run of text back into separate columns. Preview the split before you finish so a description field with spaces in it does not get chopped into pieces. This works on clean text PDFs but struggles with wrapped cells and merged headers.
How do I transfer a table from a scanned PDF?
A scanned PDF is a picture of a page, so there is no text to copy and no connector will read it. You need OCR (optical character recognition) to recognize the characters first, then rebuild the table. Use a converter with built-in OCR, like the OCR PDF to Excel tool, which reads the image, identifies the rows and columns, and outputs a real spreadsheet. Scan quality drives accuracy: a crisp 300 DPI scan transfers cleanly, while a faxed or skewed copy needs a closer review. If you only have a phone photo, scan it to a PDF first rather than expecting a direct image upload.
Why do my numbers come in as text?
Numbers often transfer as text because a currency symbol, a comma, a trailing space, or parentheses around a negative came across attached to the value, so Excel treats the cell as a label. The giveaway is that the figures sit on the left of the cell and SUM returns zero. Fix them with Data, Text to Columns and Finish on the affected column, or strip the stray characters and multiply by 1 to coerce real numbers. For the full set of repairs see numbers stored as text, and for accounting-format negatives see negative numbers in parentheses.
What is the most accurate way to transfer a PDF table to Excel?
The most accurate way is to use a table-aware converter for digital PDFs, OCR for scans, and then verify the result before you trust it. Verification takes under a minute and catches the errors a quick glance misses: compare the number of rows in Excel against the PDF so nothing was dropped, spot-check the first and last lines, and SUM a numeric column to tie it back to the printed total on the document. If the total ties, the structure transferred cleanly. If it does not, you have either missing rows or values stuck as text, both fixable before the file goes anywhere.
A quick checklist
Run a transfer through these steps and the table arrives clean:
- Is the PDF digital or scanned? Digital takes a converter or the Get Data connector; scanned needs OCR first.
- Did every row come across? Compare the Excel row count to the PDF.
- Do the columns line up? If text collapsed into one column, use Text to Columns or the Word bridge.
- Do the numbers calculate? Select a numeric column and confirm SUM ties to the PDF total; fix any text-formatted values.
- Reapply formatting last, after the values are real numbers, so currency and date display do not mask a broken value.
If the tables you are transferring are invoices, sending the line items straight to a spreadsheet is faster with a dedicated extractor like invoicexlsx.com, and teams moving tables out of hundreds of documents a month should look at volume extraction with docuocr.com. For everything else, the converter at the top of this page handles the transfer in one upload. If you want to keep your table in pages instead of a sheet, see convert a PDF to Google Sheets, and if accuracy across many files is the priority, read how to convert a PDF to Excel accurately.