A statement or invoice PDF downloaded from a bank or accounting system contains real text, so PDF to Excel can read it. The result needs a little cleanup before you can sum or filter it, because amounts and dates arrive as text.
This guide gives the workflow and a checklist for it.
On this page
Key takeaways
- Use the PDF you downloaded from the bank. A scan or a photo contains no text to read.
- Each page is a separate sheet. Combine them before sorting.
- Amounts with currency symbols or thousands separators stay as text until you clean them.
- Check totals against the PDF to make sure nothing was lost.
Step 1: Use the original PDF
Download the statement or invoice as a PDF from the bank or the billing system. These files carry real text. If you only have a photo or a scan, the tool will say no text was found. In that case, read it with Image to Text, but note that it sends the file to an OCR service, which you may not want for financial documents.
Step 2: Keep only the useful pages
Remove pages with terms, adverts or summaries using Remove Pages. Every page becomes a sheet, so a trimmed PDF gives a cleaner workbook.
Step 3: Convert
Open PDF to Excel, add the file and convert. Open the workbook and compare the first sheet with the PDF. Transaction tables normally split into date, description and amount columns.
Step 4: Clean amounts and dates
| Problem | Fix in Excel |
|---|---|
| 1,250.00 stays text | Find and Replace the comma with nothing, then format as Number |
| $ or currency code in the cell | Find and Replace the symbol with nothing |
| Negative amounts in brackets (125.00) | Replace the brackets with a minus sign |
| Dates stay as text | Select the column, Data, Text to Columns, choose Date |
| Description split over two rows | Join the rows manually |
Step 5: Combine pages and check totals
- Copy the transaction rows from each page sheet into one sheet.
- Sum the amount column and compare it with the closing balance or invoice total printed on the PDF.
- If the totals differ, look for rows that were split or skipped on page breaks.
Moving the data on
Accounting software often imports CSV. Export the clean sheet with Excel to CSV. For the first conversion steps, see how to convert PDF to Excel, and for layout problems, PDF to Excel columns misaligned.
A note on privacy
PDF to Excel runs in your browser, so statements are not uploaded. Delete the files you no longer need from your downloads folder.
Statements and invoices to Excel: FAQ
Can I convert a bank statement PDF to Excel?
Yes, if it is a text-based PDF from the bank. Scans and photos contain no text.
Why can't I sum the amounts?
They are text because of currency symbols or separators. Clean them in Excel first.
Is my statement uploaded?
No. PDF to Excel runs in your browser.
Why are there many sheets?
Each PDF page becomes one sheet. Copy the rows into one sheet.
How do I check that nothing is missing?
Compare the sum of the amounts with the total printed in the PDF.
Can I convert an invoice with line items?
Yes. Line items usually become columns for description, quantity and price.
What if dates look wrong?
Use Text to Columns and choose the date format that matches the statement.
Can I import the result into accounting software?
Export it as CSV with Excel to CSV after cleaning.
Convert once, clean in a few steps
Trim the PDF, convert, fix amounts and dates, then compare totals. It beats retyping every line.
