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 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 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 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 Convert and downloadClick Convert to Excel. The .xlsx file downloads with columns sized to fit the content.
- 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 type | Result |
|---|---|
| Bank and card statements downloaded from online banking | Excellent — clear columns for date, description, amount, balance |
| Invoices and purchase orders | Very good — line items become rows |
| Price lists and product catalogues | Very good |
| Reports exported from accounting software | Very good |
| Tables with merged cells or multi-line descriptions | Good — some cells may need joining |
| Scanned or photographed tables | Needs 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:
- Choose Everything in one sheet so all months are in one table.
- Delete repeated header and footer rows (page numbers, bank address, "balance brought forward").
- Select the date column and use Data → Text to Columns or the DATEVALUE function if dates were not recognised automatically.
- Insert a pivot table or use SUMIF to total spending by category.
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
- Compare the number of rows with the PDF — every transaction or line item should be there.
- Check that the totals match: add up the amount column with =SUM() and compare with the PDF's total.
- Format date and currency columns so Excel sorts them correctly.
- Freeze the header row (View → Freeze Panes) for easier scrolling.
- Save the file in .xlsx format before sharing.
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.