Skip to content
PdfPress.online
Productivity

Extract Tables from PDF to Excel Without Retyping a Number

Retyping numbers from a PDF table is slow and error-prone. Pull the table into a spreadsheet instead, then tidy and check it in a few minutes.

PdfPress EditorialPublished Updated 6 min read
Share:
Illustration for Extract Tables from PDF to Excel Without Retyping a Number
On this page

Someone sends you a 12-page bank statement as a PDF, and you need the transactions in a spreadsheet by this afternoon. Retyping them means hours of squinting and at least one transposed digit you won't notice until the totals refuse to match. Converting the PDF to Excel gets the rows and columns across in minutes, and you spend your time checking the data instead of keying it in.

Below you'll find how to pull tables out with PdfPress, why some PDFs convert cleanly while others fight you, and how to tidy and verify what comes out. Everything runs in your browser, so statements, payroll exports and client figures never leave your device.

Why don't PDF tables copy straight into a spreadsheet?

Excel knows that a value lives in row 4, column C. A PDF has no idea. It stores fragments of text at x and y coordinates on a page, sometimes with a few drawn lines nearby so it looks like a grid to human eyes. There's no table object hiding underneath that you could simply copy.

So an extractor has to rebuild the table from clues. It looks for text that lines up in rows and columns, guesses where each column begins and ends, and decides which fragments belong in the same cell. That last part gets messy when a product description wraps onto a second line, or when a header spans three columns.

PdfPress uses best-effort detection. A clean table exported from accounting software usually comes through almost perfectly. A borderless table in a glossy annual report, with merged headers and footnote markers, will need some hand-tidying afterwards. Knowing that up front saves frustration.

How to convert a PDF to Excel with PdfPress

  1. Open Extract Tables from PDF, or go straight to PDF to Excel if you just want a spreadsheet file.
  2. Drag your PDF onto the page or pick it from your device.
  3. Start the extraction. Each page is scanned for table-like structures.
  4. Look over the detected tables if a preview appears.
  5. Download the spreadsheet and open it in Excel, Google Sheets, Numbers or LibreOffice.
  6. Compare a total and a handful of rows against the original before doing anything else.

Tip: Need one table from a 90-page report? Pull that page out first with Extract PDF Pages. You'll have less to clean up, and the extractor won't grab unrelated text that happens to line up neatly elsewhere in the document.

Which PDFs give the best results?

The source matters more than any setting. Here's roughly what to expect:

PDF type Expected result Notes
Exported from Excel or accounting software Usually very good Clean text, consistent columns
Reports with ruled tables Good Visible lines help define cells
Borderless tables aligned by spacing Fair to good Column edges are inferred from gaps
Multi-line cells and merged headers Fair Expect to fix some rows by hand
Scanned documents Depends on OCR quality Run OCR PDF first
Tables saved as images Nothing until OCR The table is a picture, not text

Try a quick test before you start: click and drag across a single number in the table. If it highlights on its own, there's real text and extraction will work. If the whole page highlights as one block, or nothing highlights at all, you're looking at an image. Our guide on how to OCR a scanned PDF walks you through adding a text layer first.

Note: OCR mistakes in numbers are sneaky. A 3 read as an 8 still looks like a perfectly plausible figure, so scanned tables deserve extra checking.

Cleaning up the spreadsheet after extraction

Even a good result usually needs ten minutes of tidying. Picture a supplier price list: 400 rows, currency symbols on every value, and a few long product names that wrapped in the PDF. Here's what typically needs fixing.

Numbers stored as text are the most common annoyance. Values like "$1,250.00" or "1 250,00" may land as text, so SUM returns zero. Use find-and-replace to strip the symbol and separators, then convert the column to numbers. Accounting-style negatives such as (1,250.00) need the same treatment, turned into -1250.

Wrapped descriptions often split into two rows: the first carries the price and the second carries the end of the product name with empty cells beside it. Sort or filter on a blank price column to find them quickly, then merge them back. The opposite problem happens when two columns sat close together in the PDF and their values ended up in one cell. Text to Columns, split on a space or a fixed width, usually sorts it out.

Long tables that run across several pages often repeat their header row on each page. Filter for the header text and delete the extras. Dates deserve a careful look too: if the PDF used day/month and your spreadsheet expects month/day, 03/04 quietly becomes the wrong date. Finally, watch for footnote markers. A superscript ¹ beside 1,250 can turn into 1,2501, so scan for any value that looks suspiciously large.

Keep the raw extraction on its own tab and do your cleanup on a copy. If a find-and-replace goes wrong, you can start again without re-running the extraction.

How do you check the numbers before trusting them?

Extraction errors in figures are easy to miss and can be expensive. Before the spreadsheet feeds a tax return, an invoice run or a board report, do four quick checks:

  1. Compare totals. Sum each numeric column and match it against the total printed in the PDF. If they agree, you're probably in good shape.
  2. Count rows. A statement listing 87 transactions should give you 87 data rows.
  3. Spot-check values from the top, middle and bottom of every table.
  4. Hunt for blanks. An empty cell where the PDF clearly shows a value usually means it was shifted into a neighbouring column.

Warning: Don't submit tax figures, invoices or financial reports built from extracted data until you've checked them against the source document.

Other ways to get data out of a PDF

Not every job needs a full table. If you only need three figures from a summary page, selecting and copying them by hand is faster. When the layout is so irregular that table detection keeps guessing wrong, PDF to Text pulls everything out in reading order. Paste that into a sheet and split it into columns yourself, which gives you full control at the cost of a bit more manual work.

Going the other direction is just as common. Once the data is cleaned and analysed, you'll often want to send a read-only version back out. Set a print area and sensible column widths, turn wide tables sideways onto a horizontal page, and convert the sheet back to PDF in your browser. Both steps stay on your machine, so sensitive financial data never has to pass through an upload form.

Written by PdfPress Editorial

Our editorial team writes and maintains practical guides on PDF workflows. Articles are reviewed for accuracy and updated when tools or best practices change. Spotted an error? Let us know.

Questions readers ask

Why are my columns merged or split incorrectly?

A PDF does not store tables as rows and columns, only as text placed at positions on the page. The extractor infers the grid from alignment and spacing, so tables without clear lines or with uneven spacing can be split or merged in the wrong places. Fix these in the spreadsheet, or extract a single page at a time.

Can I extract a table from a scanned PDF?

Only after OCR. A scanned table is an image, so run OCR PDF first to add a text layer, then extract the table. Check the numbers carefully, because OCR mistakes in figures are easy to miss.

Will formulas be recreated in Excel?

No. A PDF contains only the printed values, not the formulas that produced them. You get the numbers and text, and you can add formulas yourself afterwards.