How to Convert a Bank Statement to Excel or CSV: 4 Methods That Work

Your accountant wants the transactions in a spreadsheet. Your bank gave you a PDF. This guide covers four ways to convert a bank statement to Excel or CSV, starting with the free ones, and it is honest about where each one stops working: scanned statements, tables that run across many pages, and Excel on a Mac.

The short version:

1. Check your bank first. Many banks let you download transactions as CSV or Excel, and that file is cleaner than anything you can pull out of a PDF.
2. If you only have a PDF and you use Excel on Windows, try Excel's built-in PDF import: Data > Get Data > From File > From PDF.
3. If the statement is one or two pages, copy and paste can be quicker than either.
4. If the statement is scanned, runs to dozens of pages, or you do this every month, use a tool that extracts the transactions for you. That is what SparkReceipt's bank statement extractor does, and it exports the result to Excel or CSV.

How to convert a bank statement to Excel: which method fits?

Method 1: Download the bank statement as CSV or Excel

Before you convert anything, log in to online banking and look for Download, Export or Statements and documents next to your transaction history. Pick the date range, then choose CSV or Excel if it is offered. A file that comes straight from the bank has one row per transaction and no page headers to clean up, so it beats every PDF method on accuracy.

Two things catch people out:

• How far back you can export varies by bank. Recent months are usually there; older periods are often available as PDF statements only. That is how most people end up needing the other methods.
• Opening the CSV by double-clicking can scramble it. Excel guesses the formats. A date like 03/04/2026 can flip between March and April, and amounts written with a decimal comma can arrive as text. Use Data > From Text/CSV instead, check the preview, and set the date and number columns yourself.

In Google Sheets, use File > Import. Sheets accepts CSV and Excel files. It cannot import a PDF, so a PDF statement has to be converted first.

Method 2: Import a PDF bank statement into Excel with Power Query

Excel on Windows can read tables out of a PDF. It works well on a short, digitally generated statement.

1. Open a blank workbook.
2. Go to Data > Get Data > From File > From PDF.
3. Select the statement and click Import.
4. In the Navigator window, Excel lists the tables and pages it found. Select the table that holds your transactions. Tick Select multiple items if the transactions are spread over several tables.
5. Click Transform Data to open the Power Query editor. Remove the header and footer rows, and set the column types: date for the date, decimal number for the amounts.
6. Click Close & Load to place the clean table on a sheet.

This import is part of Excel 2016 and later on Windows, including Microsoft 365. It is not included in Excel for Mac or Excel for the web, which is why the From PDF option is simply missing for many people.

Where the Excel import stops working

• Long statements. Excel tries to join a table that continues over several pages, but statements rarely cooperate. Repeated column headers, page totals and "balance brought forward" rows land inside your data, and you often end up with several tables to append by hand. Microsoft's own documentation suggests loading large PDFs a few pages at a time to avoid timeouts.
• Descriptions that wrap onto a second line. One transaction becomes two rows, the second with no date or amount. Microsoft documents this as well, and the fix is manual: fill down, then group the rows back together.
• Scanned or photographed statements. Power Query reads the text stored inside the PDF. A scan is a picture of text, so there is no table for it to find until the file has been through OCR.
• Debits and credits. Some banks print one signed amount column, others print separate money in and money out columns. You will need a formula to turn them into a single amount you can total.

If your statement is short and clean, Method 2 is free and good enough. If you hit two or more of the problems above, the cleanup takes longer than the conversion.

Method 3: Copy and paste

For a one or two page statement, select the transaction table in your PDF viewer, copy it, and paste it into Excel. If everything lands in one column, select it and use Data > Text to Columns to split on spaces or tabs.

Expect to fix the result by hand. Descriptions with spaces in them break the columns, and negative amounts often lose their sign. It is a reasonable last resort for twenty transactions and a poor one for two hundred.

Method 4: Convert the bank statement to Excel with AI extraction

When the statement is scanned, long, in another language or currency, or simply something you deal with every month, a dedicated extractor saves the most time. Here is how to convert a bank statement to Excel with SparkReceipt.

1. Upload the statement. In the web app, choose Add new bank / credit card statement in the sidebar. PDF, CSV and Excel files all work, up to 24 MB each, and credit card statements are handled the same way. If the PDF is password protected, remove the password first.
2. Let the extraction run. It starts on its own. The AI reads the document, pulls out every transaction line, and then checks those lines against the statement's own totals, so a missed row shows up instead of hiding. You can leave the page while it works.
3. Review the transactions. Open View transactions. Fix any line the statement got wrong, delete transfers between your own accounts, or use Add new transaction for one that is missing.
4. Export to Excel or CSV. Click Export, or select only the lines you want and export those. In the Select export format dialog, choose Excel or CSV. Tick Include matched document files if you want the receipts in the same download.

There are no templates to set up for your bank. Statements are read in any language and in 190 currencies, which matters if you bank in more than one country.

What you get that a converter does not give you

A spreadsheet of transactions tells you what you spent. It does not tell you whether you can prove it. After extraction, SparkReceipt matches each transaction to the receipts and invoices already in your account and flags the ones with nothing behind them, so you can see what is missing before tax time rather than during it. The Transaction Manager keeps track of that reconciliation, and the lines you keep can become categorized expense and income entries that flow into your reports and exports or get published to QuickBooks Online or Xero. Your accountant can join your account for free and work from the same data.

If your bank is in the United States, you can skip statements altogether and connect the account so transactions arrive on their own.

What it is not

SparkReceipt is not a free one-off file converter, and we would rather say so here than after you sign up. It is paid software with a 7-day free trial. Statement extraction runs on credits, one per extracted transaction line, and your plan includes credits that renew every month. The help center explains how extraction credits work. If you need one statement converted once and your bank offers a CSV download, Method 1 is the right answer and it costs nothing.

Check the numbers before you trust the spreadsheet

Whichever method you use, spend two minutes on this before the file goes to your accountant:

• Balance check. Opening balance, plus money in, minus money out, should equal the closing balance printed on the statement. If it does not, a row is missing, duplicated or has the wrong sign.
• Row count. Count the transactions on the first and last page of the PDF and compare them with the matching rows in the sheet. Page breaks are where rows go missing.
• Dates. Sort by date. Anything that lands in the wrong month was read in the wrong format.
• Overlaps. If you combine several statements, check the days where one ends and the next begins for duplicated rows.

Before you upload a statement anywhere

A bank statement shows your account number, your balance and everyone you paid. Before you upload one to any online converter, find out who runs the service, where the files are stored, how long they are kept and whether you can delete them. For SparkReceipt, those answers are on our security page: data is encrypted in transit and at rest, files are stored in the EU, you can delete your documents, and we do not sell your data.

Converting other PDFs: receipts and invoices

Bank statements are the hard case because they are long tables. If what you have is a folder of PDF receipts and invoices, the job is different: each file is one expense, and you want one spreadsheet row per document with the merchant, date, amount and tax. Our guide to scanning receipts into Excel covers that workflow, and the same export options apply.