You can open a text-based PDF statement in Word, let Word rebuild it as a document, copy the table across and paste it into Excel. It works for short, simple statements. It tends to fail on long ones, because Word reflows the layout and can split rows or lose columns, so check every total.
What are the steps?
- In Word, choose File > Open and select the PDF. Word will say it is going to convert the PDF to an editable document. Click OK.
- Wait for the conversion, then scroll through. The transactions should appear as a table. Statements with many pages can take a while.
- Click inside the table, then click the small four-arrow handle at its top left corner to select the whole table.
- Press Ctrl+C. In Excel, click cell A1 of a blank sheet and press Ctrl+V.
- Save the Excel file as an XLSX right away, then start the cleaning.
Word works only on PDFs whose text can be selected. A scanned statement is a picture, and Word will give you a page of images instead of a table. A password-protected PDF will ask for its password before Word opens it.
How do you clean what lands in Excel?
Pasted tables carry hidden extras. Cells may contain line breaks where Word had paragraph marks, extra spaces and non-breaking spaces that make numbers behave as text.
| Symptom | Cause | Fix |
|---|---|---|
| Cells show two lines of text | Paragraph marks inside cells | Select the range, press Ctrl+H, click Find what, press Ctrl+J, put a space in Replace with, and Replace All |
| Amounts left-aligned and will not add | Text with a hidden space | =VALUE(SUBSTITUTE(D2,CHAR(160),"")), then fill down and paste as values |
| Empty rows between transactions | Spacing from the layout | Filter the date column for blanks, delete those rows, clear the filter |
| Repeated header every page | Page header became a table row | Filter the Date column and delete rows equal to Date |
| Several columns merged | Word merged cells in the layout | Select merged cells and choose Unmerge Cells |
Turn on Word's formatting marks with Ctrl+Shift+8 before you copy. The paragraph symbols show where cells hold hidden line breaks, so you know in advance which cells will need the Ctrl+J clean-up in Excel.
What goes wrong with long statements?
- A transaction can split across two table rows, with the narration on one and the amount on the next.
- Different pages may become separate tables, with slightly different column widths.
- Text boxes or images used for logos and summaries can appear in the middle of the transactions.
- Debit and credit columns can swap places when a page's layout differs.
For a one-page statement, those problems are easy to spot. For a twenty-page one, they are easy to miss, which is why the next step matters most.
How do you check a long statement page by page?
Do not wait until the end. After pasting, compare the first and last transaction on each page with the PDF, since errors cluster at page breaks.
- Note the first and last row of every page in a spare column, then tick them off against the PDF.
- Check that the date order never goes backwards.
- Look for rows where the narration is long, because they wrap and split most often.
- Total each page's debits and credits separately if the totals are off, so you know which page to inspect.
Should you use Word at all?
It is a reasonable fallback when you have no other route, such as a PDF connector or a CSV from your bank. If your bank offers a CSV or Excel download, use that instead, because it carries the data rather than a picture of it. Keep the original PDF unchanged as the record, and treat the converted sheet as a working copy.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

