To convert a bank statement PDF to Excel, start with the original statement, identify its tables, review the columns, and export a workbook. Combine matching tables when transactions continue across pages. Keep account identifiers as text, and compare dates, amounts and balances with the PDF before sorting or calculating.

Before you start

Keep an unchanged copy of the statement. If your bank already provides an Excel or CSV download for the same account and period, consider using that structured file instead of reconstructing a table from a PDF.

For a PDF, check these three things:

  • Can you select a sentence? A bank-generated PDF often contains selectable text. A scan or photograph may contain only pictures of words. The preparation step below explains what to do with a scan.
  • Does it need an opening password? Use the password supplied for a document you are entitled to access. A PDF that opens normally does not need an extra password simply because it has editing restrictions.
  • Which pages contain the transactions? Note the page range and whether other sections, such as fees or account summaries, have different headings. This helps you choose what to include.

A statement does not need visible grid lines to look like a table. Columns may be formed by aligned text and blank space. Their positions still need to be checked during conversion, particularly around long descriptions and page breaks.

Convert the statement step by step

  1. Open PDF to Excel and choose your statement. The document is processed on your device.
  2. Set Pages (leave blank for all). For a long statement, try one representative transaction page first, then return to the full range once you understand the preview.
  3. Choose Export layout. Select Document to keep headings and nearby notes with the tables, or Tables only when you mainly need the detected cells. Choose the layout before making your final selections, because changing it resets some related options.
  4. Select Find tables. In Table to preview, switch between the detected tables and compare each with the PDF. Check that dates, descriptions, debits, credits and balances sit in the intended columns.
  5. Use Include this table to choose the sections you need. Correct individual cells in the preview where necessary. For longer tables, use Previous rows and Next rows to inspect more than the first screen.
  6. When multiple selected tables belong together, enable Combine selected tables with matching headings into one sheet. Different headings remain separate. The next section explains what to check across pages.
  7. Review the number and reference-text options. In Document layout, Use numbers for amounts and quantities converts unambiguous amounts while keeping leading-zero IDs, dates and long identifiers as text. Include original page text on separate sheets adds a useful reference copy of the wording.
  8. Select Create Excel file, then Download Excel. Open the workbook and complete the checks below before sorting, filtering or calculating with the transactions.

Use the preview to check how the table was extracted. Columns can be misplaced, and correcting a few cells will not fix a table whose structure is wrong throughout. If your bank offers a structured export, that can save you from rebuilding the table.

Combine a statement that spans several pages

Use Document layout when the heading, table and nearby notes should stay together. Matching table sections can be joined in page order, while a different set of headings starts another worksheet.

For example, pages containing Date, Description, Debit, Credit and Balance may belong to one transaction table. A separate section containing Fee type and Amount should remain distinct. Do not combine unrelated sections solely because they have the same number of columns.

Inspect the boundary between each pair of pages. A long description may continue onto another line, and a repeated header or carried-forward balance is not necessarily another transaction. Keep nearby notes identifiable. If a continuation page has no heading, check that it joined the right table.

Original-text worksheets intentionally contain one column. They preserve page wording for comparison and are separate from table worksheets. Keep them until you have checked for any missing notes or unplaced content.

Prepare a scanned statement

If you cannot select the visible words, open OCR PDF first. Choose the languages actually present, select Searchable PDF under Save as, and select Recognize text. Review the recognized words and download the searchable copy, then use that copy in PDF to Excel. Follow the searchable PDF guide for a page-by-page checking method.

OCR also offers an Excel tables (.xlsx) output. You can try that route for a scanned table, but still compare the resulting cells with the page image. OCR may recognize the words correctly but still place them in the wrong columns.

Faint print, skewed pages, stamps and small digits can affect recognition. Start with the clearest available original rather than a heavily compressed screenshot. Check similar-looking characters such as 0 and O, and review decimal points and minus signs in amounts.

Keep amounts usable and identifiers intact

Store amounts as numbers when you need to calculate with them. Keep account numbers as text: they identify an account even when every character is a digit.

  • Keep codes such as 001234 as text so the starting zeros remain part of the value.
  • Check the statement's date convention before treating an ambiguous date as a calendar value.
  • Preserve blank debit or credit cells. Removing blanks can move the balance into the wrong column.
  • Keep multi-word and multi-line descriptions attached to their transaction.
  • Review currency signs, thousands separators and decimal separators before adding amounts.

For an invented transaction, 01 Oct | CARD PAYMENT CITY STORE | 42.50 | blank | 957.50 contains five fields. The store description belongs in one cell, and the empty credit field still occupies its own column. Splitting on every space would break the description and would not recover the intended table.

Check the workbook against the PDF

Before relying on the exported data, check these points.

  1. Confirm the account and statement period match the source.
  2. Compare the first and last transaction on every page to spot missing or repeated rows.
  3. Check transaction counts, allowing for descriptions that wrap across printed lines.
  4. Review dates, debit and credit placement, signs, amounts and balances against the original.
  5. Keep opening balances, closing balances, totals and notes distinct from transaction rows.
  6. Save a reviewed copy before sorting or changing formulas, and retain the PDF as your reference.

If you only need the statement's wording, PDF to Text can produce a text file. Use that as a reference rather than expecting plain text to preserve spreadsheet columns.

Common situations and next steps

Situation What to check What to do
You see a worksheet with only one column Whether it is an original-text reference sheet Open the table worksheet and compare both with the PDF
No table is found on a page Whether the words are selectable and arranged consistently Try the scan preparation step if needed; otherwise review the available source format
A page starts a separate worksheet Whether its headings differ or are missing Check whether the section should be separate before manually joining it
A description appears on two lines Whether the second line belongs to the same transaction Preserve the full description and check the adjacent amounts
An amount or identifier looks different Whether recognition or number conversion changed its interpretation Compare with the PDF and correct the value before using the workbook

Questions

Is the bank's CSV download worth using instead of its PDF?

Yes, when it covers the account, period and details you need. CSV already separates data into fields, so it avoids reconstructing columns from a page layout. Check the download's dates, identifiers and totals just as you would check a converted workbook.

Should account summaries and transaction tables go in the same worksheet?

They do not have to. Document layout can preserve nearby headings and notes, while tables with different headings stay separate. Keep summaries distinguishable so their balances and totals are not accidentally counted as transactions.

Is searchable text enough to guarantee a correct statement table?

No. Searchable text helps make the words available, but column positions, wrapped descriptions and missing headings still need interpretation. Review the table preview and compare important cells with the original.

Can I remove the reference-text sheets after reviewing the workbook?

Yes, if you no longer need them and have confirmed that important notes and transactions are preserved elsewhere. Keep the original PDF and a copy of the reviewed workbook so you can check the source later.