Pagivo PDF

Log in

Welcome back. Your document tools are ready when you are.

Continue with Google
or

No account? Sign up

How-to

How to Get a Table Out of a PDF and Into Excel

· 5 min read

You have a PDF with a table of data - a financial report, a price list, a survey result, an invoice line-items section. You need to work with that data in Excel. You try to select the cells, copy them, and paste into a spreadsheet. What you get is a column of jumbled text, merged cells in all the wrong places, or nothing at all. This is not a bug. It is how PDFs work.

Why PDF tables are hard to extract

A PDF does not store tables as tables. It stores text as a series of positioned glyphs - characters placed at specific X/Y coordinates on the page. A table in a PDF is just rows of text that happen to be visually aligned and separated by drawn lines. There is no data structure representing "this is a cell", "this belongs to column 3", or "this row ends here".

When you copy-paste from a PDF, the reader tries to guess structure from visual position. It often gets the column boundaries wrong, merges cells, and breaks numbers across lines. The wider the table, the messier the result.

Option 1: Direct copy-paste (worth trying first)

For a native PDF - one created by software, not a scanner - try this first:

  1. Open the PDF in Adobe Reader or Chrome.
  2. Click and drag to select the table area.
  3. Copy (Ctrl+C).
  4. Paste into an Excel cell using Paste Special -> Text or paste into a text editor first to see what you actually got.
  5. Use Text to Columns (Data tab in Excel) to split the pasted content by tab, space, or a consistent delimiter.

This works reasonably well for simple two- or three-column tables with clean formatting. It falls apart on complex tables with merged cells, footnotes, or multi-line cell content.

Option 2: A dedicated PDF to Excel converter

A conversion tool analyses the visual structure of the PDF - cell boundaries, column alignment, font properties - and attempts to reconstruct it as spreadsheet data. The output is an XLSX file you can open directly in Excel.

Pagivo is building a dedicated PDF to Excel converter for this. When it launches, the workflow will be: upload the PDF, download the XLSX, review the result for any mis-detected boundaries. For a native PDF with clean table formatting, the converter will handle most of the work.

What to expect: the conversion is accurate on straightforward tables and less accurate on complex layouts (merged header rows, diagonal text, tables with images inside cells, heavily styled borders). Always verify the numeric totals in the output against the source PDF - rounding or column alignment errors in complex tables do happen.

Option 3: Google Sheets import (quick for small tables)

  1. Open Google Sheets and create a new spreadsheet.
  2. Go to File -> Import and upload the PDF.
  3. Google will attempt to parse tables from the PDF and import them as sheet data.

Results are variable and similar to copy-paste, but the import step sometimes detects table structure better than manual selection. Worth trying for simple tables when you do not have a dedicated converter available.

Option 4: Scanned PDFs (different problem, different solution)

If the PDF is a scan - a photograph of a page - there is no text data to extract at all. Copy-paste selects the entire page as one image. A standard PDF-to-Excel converter will produce nothing useful.

For scanned tables, you need OCR that specifically understands table structure. Options:

  • Google Docs - upload the PDF to Drive, open with Docs. Google's OCR will extract text, though table structure is often not preserved.
  • Adobe Acrobat Pro - has OCR with table recognition built in. Higher quality for complex tables, but requires a paid subscription.
  • Specialist OCR tools - ABBYY FineReader and similar are designed specifically for document structure recognition including tables. Overkill for occasional use but the most accurate option for complex scanned tables.

After extraction: cleaning the data in Excel

Regardless of method, plan to spend a few minutes cleaning the output:

  • Remove blank rows and duplicate headers that appear when multi-page tables repeat column headings on each page.
  • Fix number formats - commas and dots may be swapped if the PDF used a different locale's number format.
  • Check that totals match - manually verify one or two calculated values from the source PDF.

Try it on Pagivo

How to Get a Table Out of a PDF and Into Excel

Convert PDF tables to Excel

Frequently asked questions

Why does my copy-pasted PDF table look completely wrong in Excel?

PDF stores text as positioned characters, not as structured table data. When you copy-paste, the application guesses cell boundaries from visual alignment. Complex tables, merged cells, and multi-line content confuse the inference. A dedicated PDF to Excel converter analyses the visual structure more systematically and produces a cleaner result.

What is the difference between a native PDF and a scanned PDF for table extraction?

A native PDF contains actual text characters at known positions. A converter can read those characters and infer table structure. A scanned PDF is an image of a page with no text data - the converter needs to run OCR first to identify any characters at all, and table OCR is significantly harder than plain text OCR.

Can I extract tables from a password-protected PDF?

Not without removing the password first. Use a PDF unlocker tool with the password, then convert the unlocked copy.

The numbers in my extracted Excel file are stored as text, not numbers. How do I fix that?

Select the column, go to Data -> Text to Columns -> Finish. Or use =VALUE(A1) to convert a text cell to a number. This often happens when the PDF used a number format with special characters (currency symbols, non-breaking spaces, or regional decimal separators) that the converter carried over as part of the cell content.

More articles