How to get tables out of a PDF and into Excel

A bank statement, a supplier price list or a report arrives as a PDF, and you need the numbers in a spreadsheet. You copy the table, paste it into Excel, and everything lands in one column. Retyping it by hand takes ages and invites mistakes.

There's a better way. This guide explains why copy and paste fails, how to convert PDF tables to Excel properly, what to do with scanned tables, and how to clean the data so your formulas work.

Why copy and paste doesn't work

A spreadsheet stores data in cells. A PDF doesn't. It stores pieces of text at exact positions on a page, and the lines you see around a table are usually just drawn lines. There's nothing in the file that says "this number belongs in column C".

When you copy from a PDF, you get the text in reading order, separated by spaces or line breaks. Excel has no way of knowing where one column ends and the next begins, so it puts everything in one place.

A proper converter does the extra work. It looks at how the text lines up on the page, finds the rows and columns, and rebuilds them as real cells.

Which tables convert well

Not sure if your PDF is a scan? Try to highlight a single number. If you can select it, the PDF contains real text. If the whole page highlights as one block, it's a picture of a page.

How to convert PDF tables to Excel with Pagestro

PDF to Excel finds the tables on each page and rebuilds them in an .xlsx workbook. It runs in your browser, so statements and financial reports are never uploaded.

Step 1. Open PDF to Excel and drop in your PDF. Files up to 100 MB work.

Step 2. Check the preview. Page through it to see which tables were found before you convert.

Step 3. Press Convert & Download and open the workbook in Excel, Google Sheets or Numbers.

Here's what you get:

• One sheet per page, named Page 1, Page 2 and so on, so every row traces back to its page. A one-page PDF gives a single sheet.
• Tables as rows and columns, with the header row styled and any heading just above the table kept as a title.
• Numbers stored as numbers. Amounts like $1,234.50, percentages like 12.5% and bracketed amounts like (42.00) become real values with matching formats. Bracketed amounts become negatives. You can sum a column the moment the file opens.
• Pages without tables list their text blocks, one per row, with a column saying what each block is, such as a heading or a paragraph.

Scanned tables need OCR first

A scanned PDF is a picture. There's no text inside for a converter to read, so PDF to Excel can't find the table.

Use OCR PDF instead. It recognizes the text in your browser and can export detected tables to Excel or CSV with their rows and columns. Our guide on how to make a scanned PDF searchable has tips for getting a clean scan in the first place.

With scans, accuracy depends on the image. A straight, sharp, evenly lit page reads well. A crooked photo or a faint photocopy makes mistakes more likely, and a smudged digit can come out wrong. With money and dates, always compare the totals in Excel against the totals printed on the PDF.

Clean the data once it's in Excel

Even a good conversion usually needs a few minutes of tidying. These steps cover most of it.

Combine pages into one sheet

Each PDF page has its own sheet. To analyze everything together, copy the rows from each sheet into one, one under another. Delete the repeated header rows as you go, so only the first one is left.

Check that numbers are really numbers

Run a quick SUM on each amount column and compare it with the PDF's own total. If the result is too low or zero, some cells are stored as text. Look for stray characters such as currency codes, footnote marks or letters stuck to the number, remove them and try again.

Remove extra spaces

Text from other programs often has extra spaces that stop lookups and filters from matching. Excel's TRIM function removes them. Microsoft notes that TRIM doesn't remove the non-breaking space character, which web pages often use, so a cell can still look padded after TRIM (Microsoft Support). The same page links to Microsoft's guide on cleaning that up.

Split a column that holds two things

Sometimes a name and an account number land in one cell. Excel's Convert Text to Columns wizard splits a column by a separator such as a space or comma (Microsoft Support).

Check the dates

Dates come through as text, so sorting and date formulas won't treat them as dates yet. When you convert them, watch the order. A statement from another country might write 03/04 to mean 3 April, while your copy of Excel might read it as March 4. Compare a few dates against the PDF, especially ones where the day is 12 or lower.

Other ways to get the data

A converter isn't always the best route.

• Ask for the original. PDFs of tables are often made from a spreadsheet. A quick "could you send the CSV?" can save you the whole job.
• Use Excel's Power Query. Microsoft's Power Query includes a PDF connector that works in Excel (Microsoft Learn). It suits people who pull the same report every month and want to refresh it, though Microsoft notes that some capabilities differ between products.
• Download from the source. Check whether the bank or system that produced the PDF also offers a CSV or Excel download.

Wondering whether to use an online converter for financial documents at all? Our post on in-browser vs upload PDF tools explains the difference.

Frequently asked questions

Will numbers from the PDF work in formulas?

Yes. Amounts such as $1,234.50, 12.5% and (42.00) are stored as numbers with matching formats, so SUM and other formulas work straight away.

Can I put all the tables on one sheet?

Each PDF page gets its own sheet, which keeps rows traceable to their page. Copy the rows into one sheet in Excel afterwards.

Does it work with scanned PDFs?

Scanned pages are pictures, not text. Use OCR PDF, which recognizes the text and can export tables to Excel or CSV.

What happens to pages without tables?

Their text is listed on the sheet, one block per row, with a column describing each block.

Is my PDF uploaded?

No. Tables are found and the workbook is built in your browser, so the file stays on your device.