Easy PDFs
Windows 10 & 11 Buy license · $59.95
Convert

How to Convert a PDF to Excel With the Tables Intact

Convert a PDF to Excel with rows, columns and numbers intact. Excel's own PDF import, a converter, and fixes for merged cells and numbers stored as text.

Updated 5 minute read The Easy PDFs team

To convert a PDF to Excel with the tables intact, use a PDF to Excel converter that detects rows and columns, or, if you have Excel for Microsoft 365, import the table with Data > Get Data > From File > From PDF. Both turn the table into real cells you can sort and calculate with. Copying and pasting from a PDF usually dumps everything into one column, and scanned statements need OCR before any of these methods will work.

Below are the methods compared, step-by-step instructions, and fixes for the cleanup problems that come up most, such as numbers stored as text and merged cells.

Why copy and paste doesn't work

A PDF table isn't really a table. It's text placed at positions on the page, with lines drawn around it. When you copy it, the PDF viewer gives Excel a stream of words and spaces, so a five-column table often arrives as one long column, or with every row squashed into a single cell. Fixing that by hand is slow and error prone, especially with hundreds of rows.

A converter or import tool works differently: it looks at where each piece of text sits and rebuilds the grid.

Method 1: Use a PDF to Excel converter

This is the quickest route for most PDFs, and the only one that handles scans. In Easy PDFs:

  1. Open the PDF.
  2. Choose convert and select Excel (.xlsx) as the output.
  3. If the PDF is scanned, OCR runs first so the figures become real numbers.
  4. Choose where to save and convert.
  5. Open the workbook in Excel and check the first and last rows of each table, plus the column totals.

Easy PDFs converts PDFs to Excel spreadsheets with the tables intact, and runs offline, which matters for bank statements, payroll reports and client accounts.

Tip: if you only need one table from a long report, extract that page into its own PDF first. The spreadsheet will be cleaner, with no stray text from other pages.

Method 2: Import from PDF in Excel

Excel for Microsoft 365 on Windows includes a PDF connector in Power Query.

  1. In Excel, go to Data > Get Data > From File > From PDF.
  2. Pick the PDF and click Import.
  3. The Navigator lists the tables and pages Excel found. Click each one to preview it.
  4. Select the table you want and click Load, or Transform Data to clean it up in Power Query first.

This works well for clean, digitally produced PDFs with clearly structured tables. It doesn't run OCR, so scanned PDFs won't show any tables, and complex layouts can produce tables split across several entries in the Navigator. It also isn't available in older standalone versions of Excel.

Which method to choose

SituationBest method
Digital PDF, simple table, Microsoft 365Excel's From PDF import or a converter
Scanned statement or photo of a tableConverter with OCR
Many tables across a long reportConverter, then delete what you don't need
Same report every monthPower Query (refreshable) or batch conversion
A handful of numbersType them in, honestly

Fixing common problems after conversion

Numbers stored as text

You'll see small green triangles in the corner of cells, numbers aligned to the left, and SUM formulas returning zero. Causes include spaces, currency symbols, thousand separators in an unexpected format, or trailing minus signs. Fixes:

  • Select the column and use the warning icon's Convert to Number option.
  • Use Find and Replace (Ctrl+H) to remove currency symbols and stray spaces.
  • Use Data > Text to Columns, click Finish, which forces Excel to re-read the values.
  • For trailing minus signs, such as 125.00-, Text to Columns has an Advanced option for "Trailing minus for negative numbers".

Merged cells

Headings that spanned several columns in the PDF can become merged cells, which stop you sorting and filtering. Select the range and choose Home > Merge & Center to unmerge, then fill the headings where you need them.

Dates in the wrong format

A UK-style statement with dates like 03/07/2026 may be read as March 7 on a US system. Use Text to Columns and set the column data format to Date with the right order, such as DMY.

Rows split across two lines

Descriptions that wrapped in the PDF can become two rows. Sort carefully, or filter for rows with an empty amount column and merge their text into the row above.

Page headers repeated in the data

Multi-page tables often bring their column headings with them on every page. Filter the first column for the heading text and delete those rows.

Values shifted into the wrong column

When a description is unusually long or a cell is empty in the PDF, the values on that row can slide one column left or right. Sort by a column that should always contain a number, such as the amount, and blanks or text in it will jump to the top or bottom, where you can fix them quickly.

Empty columns and rows

Wide gaps in the PDF layout sometimes become empty columns. Select a blank column, press Ctrl+minus to delete it, and repeat. For blank rows, use Home > Find & Select > Go To Special > Blanks on a key column, then delete the selected rows.

Converting scanned bank statements and receipts

Scanned financial documents are where OCR accuracy matters most. A misread digit changes a total. To reduce errors:

  • Scan at 300 dpi, straight on the glass, in grayscale.
  • Convert, then compare the statement's printed closing balance with a SUM in Excel.
  • Check common OCR confusions: 0 and O, 1 and l, 5 and S, 8 and B.
  • If your bank offers CSV or Excel downloads, use those instead. They avoid conversion entirely.

For more on preparing scans, see how to make a scanned PDF searchable.

PDF to Excel vs PDF to Word

If your PDF is mostly text with the occasional table, convert it to Word and copy the table into Excel. If it's mostly tables, such as price lists, statements, timesheets or inventory reports, convert straight to Excel. Our guide to converting PDF to Word without losing formatting covers the text-heavy case.

Converting lots of PDFs

If you receive the same report as a PDF every week or month, convert the whole folder in one batch. Easy PDFs can run the conversion across every file in a folder, giving you one workbook per PDF ready to combine or analyze. Keep the originals, and spot-check totals in a few of the converted files before relying on them.

Frequently asked questions

Can Excel open a PDF directly?

Excel for Microsoft 365 can import tables from a PDF with Data > Get Data > From File > From PDF. It works well on clean tables and less well on complex layouts.

Why are my numbers stored as text after converting?

Stray spaces, currency symbols or thousand separators stop Excel recognizing numbers. Use Find and Replace to remove them, or the Text to Columns tool to reformat the column.

Can I convert a scanned bank statement to Excel?

Yes, as long as the converter runs OCR first. Check totals afterwards, because OCR can misread characters such as 0 and O or 1 and l.

Get three guides like this every month, plus software update notices.Subscribe →