What you get in the workbook
The converter looks for tables on each page — tables drawn with ruled lines are detected most reliably — and copies every cell into Excel:
- One sheet per page (named Page 1, Page 2 …). If a page has several tables, each gets its own sheet (Page 3 Table 2).
- Header rows are bold and frozen, so they stay visible while you scroll.
- Numbers become numbers. Values like
1,250.00, $99, 12% or (450) are stored as numeric cells with matching formatting, so SUM and charts work immediately.
- IDs stay intact. Values with a leading zero — account numbers, CNIC-style IDs, phone numbers — are kept as text so Excel does not strip the zeros.
- No table found anywhere? The words on each page are arranged into rows and aligned columns instead, which works well for borderless statements and lists.
Which PDFs work best
| PDF | Expect |
| Exported from Excel, accounting or ERP software, online banking e-statements | Clean tables with correct columns |
| Reports with tables between paragraphs | Tables on their own sheets; surrounding text is not included as a table |
| Tables without lines, with very uneven spacing | Columns may merge or split — check and fix |
| Scanned paper statements or photos of tables | Not supported — no OCR, so there is no text to extract |
| Password-protected PDFs | Not accepted — remove the password first with Unlock PDF |
Quick test: open the PDF and try to select one number in the table. If you can, the converter can read it. If the PDF is a scan, a tool with OCR is the honest recommendation; iLovePDF, for example, offers PDF to Excel with OCR on its paid plan (pricing, checked November 2026).
Converting bank statements: step by step
E-statements downloaded from online banking are usually text-based PDFs and convert well. Many banks protect them with a password (often based on your account number, CNIC or date of birth).
- Remove the password on a copy. Open the statement with its password in Chrome or Adobe Reader and use Print → Save as PDF to save an unlocked copy, if your bank allows printing. The converter cannot open encrypted files.
- Keep only the transaction pages. Use Split PDF to drop cover pages, adverts and terms — fewer pages means fewer sheets to clean.
- Convert and open the workbook.
- Combine the sheets. Copy each page's rows under the first sheet, deleting the repeated header rows.
- Check the totals. Add a
SUM of the debit and credit columns and compare it with the totals printed on the statement. The difference should be zero.
- Protect the result. Delete the unlocked PDF copy, and if you need to share the original statement, lock it with Protect PDF.
A fuller walkthrough with formulas is in how to convert a bank statement PDF to Excel.
Clean-up tips in Excel and Google Sheets
- Amounts with a currency word stay as text. Values like
Rs 1,500 or PKR 1,500 are kept as text. Use Find & Replace (Ctrl + H) to remove Rs or PKR, then the cells turn into numbers.
- Dates are copied as they appear (for example
05-11-2026). Use Data → Text to Columns in Excel (choose the date order, such as DMY) or DATEVALUE to turn them into real dates; Google Sheets has Format → Number → Date.
- Descriptions split over two lines sometimes land in two rows. Sort by date to spot rows with no amount, then join them with
=A2&" "&A3.
- Remove repeated headers with a filter: filter the first column for the header text and delete the visible rows.
- Trim spaces with
=TRIM(A2) if lookups fail on text that looks identical.
Privacy: how your PDF is handled
Table extraction runs on our server. The PDF is uploaded over HTTPS, converted in a temporary folder and deleted immediately afterwards together with the workbook. We do not store, read or reuse financial documents. If you would rather not upload a document at all, our browser-only tools — like Edit PDF and Split PDF — never send files anywhere; see which tools use the server on the PDF converter page.
Need the text rather than the numbers? PDF to Word keeps paragraphs and tables together in an editable document.