You can turn a statement PDF into an Excel sheet in three steps: find out whether the PDF holds real text, bring the table into Excel by import or by copy and paste, then clean the dates and amounts and check the total against the statement. Whether the first step works depends on how the file was produced, so open your own file and test it before you plan the rest.
Is my PDF text or a picture?
Open the file and try to select a single word with your cursor, then use the search shortcut to look for a merchant name. If the word highlights and search finds it, the PDF contains text. If nothing highlights, it is an image of a page, and no copy or import will work without character recognition. In that case ask your bank for a CSV or Excel download instead, if it offers one, or key the lines in by hand.
What are the ways to get the table into Excel?
- Import from PDF. Recent versions of Excel for Windows on a Microsoft 365 or similar plan have a Get Data option with a From PDF choice under the Data tab. It lists the tables it finds, and you pick one to load. Older versions and some other editions do not have it, so check your own menu.
- Copy and paste. Select the table in the PDF viewer, copy, and paste into a blank sheet. Columns may collapse into one, which you can split with Text to Columns.
- Export from the PDF viewer, if it can save to a spreadsheet format. Check the result carefully.
- Ask the bank for a CSV or Excel version, which avoids the problem.
None of these is perfect, and layouts change over time, so test with one statement before processing a year.
How do I clean the data?
- Dates may arrive as text. Test with =ISNUMBER(A2). If it returns FALSE, convert with Data, Text to Columns, or use =DATEVALUE(A2) where the text matches your regional format.
- Amounts may carry a minus sign, brackets or a trailing letter. Remove commas and symbols, then wrap with =VALUE(D2) to make a number.
- Descriptions can split across two rows. Merge them so each transaction has one row.
- Delete page headers and footers repeated on every page.
How do I check the conversion is right?
Total the converted amounts and compare them with the statement. Say the statement shows deposits of 4,500 and withdrawals of 3,120.75. Sum the positive column with =SUMIF($D$2:$D$300,">0") and the negative one with =SUMIF($D$2:$D$300,"<0"). If the withdrawals come to 3,095.75, you are 25.00 short, so one line was lost. Count rows too: the statement may say how many transactions it lists, or you can count them by eye on the first page.
| Check | Statement says | Sheet says | Verdict |
|---|---|---|---|
| Total deposits | 4,500.00 | 4,500.00 | Match |
| Total withdrawals | 3,120.75 | 3,095.75 | Missing 25.00 |
| Row count | 31 | 30 | One row lost |
Where does SpendixAI fit?
If you do this each month, SpendixAI takes bank and card statements as PDF, CSV or Excel directly, and you review the rows before they are saved. Pick the account before importing, and choose the base currency first if the statement is in another currency, since it cannot be changed once transactions exist. It will not read every layout perfectly, which is why the review step matters. Check the bank's own site for how to download your file; this article does not describe its menus.
Before you save
- Keep the original PDF.
- Save the sheet as a new file, not over a template.
- Note the statement period in the file name.
- Keep the check table with the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


