Skip to content
SmallEasyTools

PDF to Excel

Pull tables out of PDFs — bank statements, invoices, price lists and reports — into an editable Excel spreadsheet with real numbers you can sum and sort.

  • Free
  • Runs in your browser
  • No sign-up needed

This PDF has no text layer (it is a scan). Use PDF OCR first.

Guest: 10 of 10 free tasks left today · Go unlimited with Pro

Rate this tool:
Share: Facebook X LinkedIn WhatsApp Email

Quick answer

To convert PDF to Excel, drop the PDF into the converter, check the preview of the first page, choose one sheet per page or one combined sheet and click Convert to Excel. An .xlsx file downloads with your rows and columns, and amounts such as "1,250.00" become real numbers. The PDF is processed in your browser and never uploaded.

Output:
Excel .xlsx
Opens in:
Excel, Google Sheets, LibreOffice, Numbers
Sheets:
One per page or one combined sheet
Numbers:
Converted to real numeric cells
Preview:
First page shown before converting
Upload needed:
No – runs in your browser
Scanned PDFs:
Run PDF OCR first
Watermark:
None

Bank statements, supplier invoices, sales reports and price lists often arrive as PDF. They look tidy, but you cannot add up a column, filter transactions by date or build a pivot table from a PDF. Copying a table out of a PDF viewer usually dumps everything into a single column, and retyping hundreds of rows is a recipe for mistakes.

Our PDF to Excel converter reconstructs the table structure for you. It reads the position of every piece of text on the page, detects where the columns are by looking at how values line up from row to row, and places each value in the right cell. Amounts written as "৳1,250.00", "$3,400", "(250.00)" or "12.5%" are converted into real numbers — negatives and percentages included — so Excel formulas work immediately.

Choose one worksheet per PDF page, which keeps multi-page statements easy to check, or put everything into a single sheet for analysis. Everything happens inside your browser. Financial documents never leave your device, which matters when the PDF contains account numbers and balances.

How to convert PDF to Excel – step by step

  1. 1 Add the PDFDrop the file onto the converter or click to browse. A preview of the first page's table appears so you can see how the columns were detected.
  2. 2 Choose how to split sheetsOne sheet per page mirrors the PDF and makes checking easy. Everything in one sheet is better for sorting, filtering and pivot tables.
  3. 3 Keep numbers numericLeave Convert numbers & amounts ticked so totals, currencies and percentages become real numbers. Untick it for codes such as account numbers that must keep leading zeros.
  4. 4 Convert and downloadClick Convert to Excel. The .xlsx file downloads with columns sized to fit the content.
  5. 5 Clean up in ExcelDelete repeated page headers, adjust any merged columns and format dates. Then sum, sort or chart your data.

Why use this PDF to Excel converter?

Smart column detection

Values are placed in columns based on how they line up across rows, not just on spaces.

Real numbers

Amounts with currency symbols, thousands separators, brackets and percent signs become numeric cells.

Flexible sheets

One worksheet per page or one combined sheet — whichever fits your task.

Preview first

See the first page's rows and columns before converting.

Private

Bank and business documents are processed locally and never uploaded.

Works with Google Sheets

The XLSX opens directly in Google Sheets, LibreOffice and Apple Numbers.

What PDFs convert best?

PDF typeResult
Bank and card statements downloaded from online bankingExcellent — clear columns for date, description, amount, balance
Invoices and purchase ordersVery good — line items become rows
Price lists and product cataloguesVery good
Reports exported from accounting softwareVery good
Tables with merged cells or multi-line descriptionsGood — some cells may need joining
Scanned or photographed tablesNeeds PDF OCR first

Converting bank statements to Excel

Bank statements are the most common reason people convert PDF to Excel — for bookkeeping, tax returns, loan applications or simply understanding where money goes. After converting:

  1. Choose Everything in one sheet so all months are in one table.
  2. Delete repeated header and footer rows (page numbers, bank address, "balance brought forward").
  3. Select the date column and use Data → Text to Columns or the DATEVALUE function if dates were not recognised automatically.
  4. Insert a pivot table or use SUMIF to total spending by category.
Always compare the closing balance in Excel with the PDF to confirm nothing was missed.

Why tables in PDFs are hard to extract

A PDF does not actually contain "tables". It contains instructions such as "draw the text 1,250.00 at position x=432, y=618". Lines and boxes are separate drawing instructions with no link to the text. A converter has to infer the table: grouping text into rows by their vertical position, then finding columns by clustering the horizontal starting positions that repeat across many rows. That works very well for regular tables and less well when a description wraps onto a second line or when columns are not aligned. This tool uses exactly that clustering approach, which is why the preview helps you judge the result before converting.

Tips for better results

  • Use the original PDF from your bank or software rather than a printed and scanned copy.
  • If a table spans only part of the page, extract those pages first with Split PDF.
  • Untick number conversion for columns with IDs, phone numbers or account numbers so leading zeros are kept.
  • For a scanned statement, run PDF OCR first, then convert the searchable PDF.
  • For mostly text documents, PDF to Word is the better choice.

Excel vs. Google Sheets after conversion

Both open the XLSX file without problems. Excel offers Power Query for cleaning large statements and powerful pivot tables. Google Sheets is free, works on any device and lets you share the sheet with your accountant. To open in Sheets, upload the file to Google Drive and choose "Open with Google Sheets".

Converting Excel back to PDF

Finished your analysis and need to send it as a document? Use our Excel to PDF converter to turn the spreadsheet into a neat PDF in landscape format.

Privacy for financial documents

Statements contain account numbers, balances, salary payments and shopping history. Many free converters upload these files to their servers. This one reads the PDF with your browser, builds the spreadsheet in your device's memory and saves it straight to your downloads. No copy of your statement exists anywhere else.

Who uses PDF to Excel?

  • Small business owners importing supplier invoices and sales reports into their bookkeeping.
  • Accountants and bookkeepers reconciling clients' bank statements.
  • Freelancers totalling income from payment platform statements for tax time.
  • Shop owners turning a wholesaler's PDF price list into a sheet they can mark up.
  • Students and researchers extracting data tables from reports and papers.
  • Households tracking spending from credit card statements.

A quick checklist after converting

  1. Compare the number of rows with the PDF — every transaction or line item should be there.
  2. Check that the totals match: add up the amount column with =SUM() and compare with the PDF's total.
  3. Format date and currency columns so Excel sorts them correctly.
  4. Freeze the header row (View → Freeze Panes) for easier scrolling.
  5. Save the file in .xlsx format before sharing.
Taking two minutes to verify the result means you can rely on the numbers for invoices, tax returns and reports.

Troubleshooting

  • All data is in one column. The PDF may be a scan, or text is not aligned in columns. Try PDF OCR first.
  • Two columns were merged. They are too close together in the PDF; split them in Excel with Data → Text to Columns.
  • Numbers show as text. Make sure number conversion is ticked; unusual formats may need Excel's VALUE function.
  • Dates look like numbers. Format the column as Date in Excel.

Frequently asked questions

How do I convert a PDF table to Excel for free?

Drop the PDF into the converter, choose your sheet option and click Convert to Excel. The XLSX downloads instantly without an account.

Can I convert a bank statement PDF to Excel?

Yes. Downloaded bank statements convert very well. Use one combined sheet and remove repeated header rows afterwards.

Will numbers be editable and summable?

Yes. Amounts, currencies, negatives in brackets and percentages are converted into real numbers that work with formulas.

Does it work with scanned PDFs?

Scans contain no text, so run them through our PDF OCR tool first and then convert the searchable PDF.

Is my file uploaded?

No. The conversion runs in your browser and the PDF never leaves your device.

Can I open the result in Google Sheets?

Yes. Upload the XLSX to Google Drive and open it with Google Sheets.

What if columns are in the wrong place?

Check the preview first. Small misalignments can be fixed in Excel by moving cells or using Text to Columns.

Is there a page limit?

No fixed limit. Very long PDFs take longer because your device does the work; your plan's file size limit applies.

Can I keep leading zeros in account numbers?

Untick "Convert numbers & amounts" so those values stay as text.

Can I convert Excel to PDF too?

Yes, with our Excel to PDF converter.

Last updated November 21, 2026 · Written and tested by the SmallEasyTools team.