1. Home
  2. Blog
  3. Work & study

How to convert a bank statement PDF to Excel (and fix the numbers and dates)

SEditorial team·Updated: ·5 min read
Quick answer

The easiest way to turn a bank statement PDF into Excel is inside Excel itself: Data > Get Data > From File > From PDF, available in Excel for Microsoft 365 on Windows. If you don't have it, open the statement in Word and copy the table into Excel. Before converting, check whether your bank lets you download the statement as Excel or CSV, and remove the statement's password if it has one.

Your accountant wants the statement in Excel, or you want to sort three months of spending, or you're preparing a loan application, and the bank sent a password-protected PDF. Copying rows by hand takes an hour and invites mistakes. These methods move the transactions into clean columns you can add up and filter.

Before you start: try a direct download and remove the password

The most accurate result comes from the bank itself. Many online banking apps and websites let you download a statement as Excel or CSV from the statements section. Look for that option first; if it exists, you don't need to convert anything.

If only a PDF is available and it is password-protected, Excel may refuse to read it. Remove the protection first:

  1. Open our Unlock PDF tool.
  2. Click "Select PDF file" and choose the statement.
  3. Type the password your bank gave you when asked.
  4. Click "Unlock" and download the new copy.

The tool runs in your browser and the file is not uploaded to a server. It is meant for files you own. More detail in how to remove a PDF password.

Unlock PDFFree, no sign-up, and the file never leaves your device.
Use the tool

Method 1: From PDF inside Excel

This is the best route because Excel reads the tables straight from the PDF on your computer. It is available in Excel for Microsoft 365 on Windows.

  1. Open a blank workbook in Excel.
  2. Go to Data > Get Data > From File > From PDF.
  3. Choose the statement and click Open.
  4. The Navigator window lists items such as Table001 and Page001. Click each one to preview it.
  5. To take several pages at once, tick Select multiple items and choose the table from each page.
  6. Click Load to put them on a sheet, or Transform Data to clean them in Power Query first.

If you see a message that the connector needs additional components, Windows is missing .NET Framework 4.5 or later, which the PDF connector requires.

From PDF may not appear in Excel for Mac or in older versions such as Excel 2016. In that case use Method 2.

Method 2: Word as the middle step

When Excel lacks the option, Word can turn the statement table into a table you can copy.

  1. In Word, go to File > Open, pick the statement and click OK when Word offers to convert it.
  2. Select the whole table and copy it.
  3. In Excel, click cell A1 and paste.
  4. Check merged cells and rows that split into two lines, as these break the order most often.

Method 3: Google Sheets

Google Sheets can't import a PDF directly, but you can go through Google Docs.

  1. Upload the statement to Google Drive, right-click it and choose Open with > Google Docs.
  2. Copy the transaction text and paste it into Google Sheets.
  3. Select the column and choose Data > Split text to columns.

Treat this as a last resort. Google says tables and columns are often not detected when it converts a PDF, and the file limit is 2 MB. For a long statement, keep only the pages you need with Split PDF.

Which method to use

Pick based on what you have.

Method You need Table accuracy File stays on your device
Excel or CSV download from the bank Online banking access Highest Yes
Excel From PDF Microsoft 365 on Windows High Yes
Word in the middle Word 2016 or later Medium Yes on Windows
Google Docs then Sheets Google account Low No, uploaded to Drive

Cleaning the columns

Most converted statements need five fixes before numbers add up and dates sort properly.

Numbers stored as text: if a green triangle appears or SUM returns 0, remove commas and currency labels such as "SAR" with Find and Replace (Ctrl+H), then choose Convert to Number from the warning icon, or use =VALUE(A2).

Arabic-Indic digits (١٢٣): some statements print digits in this form, and Excel treats them as text. In Microsoft 365 this formula turns them into a number:

=VALUE(REDUCE(A2,SEQUENCE(10,,0),LAMBDA(t,d,SUBSTITUTE(t,UNICHAR(1632+d),d))))

If the number uses the Arabic decimal mark "٫", replace it with a full stop first.

Trailing minus: for amounts like 150.00-, use Data > Text to Columns, click Advanced in the last step and tick the trailing minus option for negative numbers.

Swapped dates: if Excel reads 05/03/2026 as 3 May instead of 5 March, select the column, run Text to Columns and in step 3 choose Date with the DMY format.

Separate debit and credit columns: add a net column such as =D2-C2 so all movements sit in one column.

To read Arabic descriptions comfortably, use Page Layout > Sheet Right-to-Left.

Finally, check that opening balance + credits − debits = the closing balance printed on the statement. If not, a row is missing or duplicated.

Keep your bank data private

A statement contains your name, account number, IBAN and every transaction, so don't upload it to a converter whose policy you don't know.

The methods here run on your device, except Google Docs, which keeps a copy in Drive. Delete temporary copies when you're done. If you need to send the statement as a PDF, remove unneeded pages and add a password as shown in how to password-protect a PDF. To judge which tools are safe, read are online PDF tools safe?.

Frequently asked questions

How do I convert a bank statement PDF to Excel?

In Excel for Microsoft 365 on Windows, go to Data > Get Data > From File > From PDF, pick the tables shown in the Navigator and click Load. Then check that the totals match the closing balance.

How can I convert PDF to Excel without extra software?

If you have Word, open the PDF with File > Open and copy the table into Excel or Google Sheets. Otherwise, open it in Google Drive with Google Docs, paste the text into Google Sheets and split it into columns.

Why is there no From PDF option in my Excel?

The PDF connector is available in Excel for Microsoft 365 on Windows and may be missing in Excel for Mac or older versions such as Excel 2016. Use the Word method instead.

My bank statement has a password. How do I convert it?

Remove the password first with an unlock tool, entering the password your bank gave you, then import the file into Excel. Only do this for files you own.

Is it safe to upload a bank statement to an online converter?

The statement holds your account number, IBAN and every transaction. Converting on your own device with Excel or Word is safer than uploading it to a site whose storage policy you don't know.

Why won't Excel add up the numbers after conversion?

They are stored as text because of commas, currency symbols or Arabic-Indic digits. Remove those with Find and Replace, then convert the cells to numbers or use the VALUE function.

Related articles