Bank statement PDF to Excel
Excel is where most statement analysis actually happens: pivot tables for spend by category, SUMIFS for a client's monthly income, filters for anything above a threshold. None of that works while the data is trapped in a PDF, and none of it works if the amount column is text instead of numbers.
Drop a PDF statement to get Excel
Drop your PDF statement here
or click to browse · 10MB max · nothing is stored
Numbers that behave like numbers
The reason a pasted statement will not total is that currency symbols, thousands separators and trailing minus signs make Excel treat every amount as text. Amounts are exported as plain signed decimals, so SUM, SUMIFS and pivot tables work the moment the file opens.
Dates that do not flip
A UK or Australian statement dated 03/04 means the third of April. Opened in a US-configured Excel, it silently becomes the fourth of March, and every monthly total after that is wrong. Dates are normalised on export so the day and month cannot swap.
What to build once it is in Excel
With a clean four-column sheet, the useful analysis takes minutes:
- A pivot table of spend by description keyword to find recurring subscriptions
- SUMIFS by month to prove average income for a loan or rental application
- A filter on negative amounts above a threshold to spot unusual outflows
- Conditional formatting on the balance column to see how close the account ran to zero
Multiple statements in one workbook
Convert each month separately, then paste them into a single sheet and add a column for the account name. Because every conversion uses the same column order, files from different banks stack without any rework.
Frequently asked questions
+Which Excel format do I get?
You can download CSV, which Excel opens natively, or an Excel workbook download for direct opening in Excel and Numbers.
+Will the balance column be included?
Yes, wherever the statement prints a running balance it is preserved so you can verify the export against the closing figure.
+Can I convert several years of statements?
Yes, one statement at a time. Each conversion is independent, so an archive can be worked through month by month.