How to Import Bank Statements Into Excel (CSV and PDF)

Quick Answer: Don't double-click the file. In Excel, go to Data > From Text/CSV, select the bank's CSV, check the delimiter and File Origin in the preview, and choose Transform Data so you can set each column's type yourself: Date using the bank's locale, amounts as Decimal Number, account or reference numbers as Text. Then Close & Load. A PDF statement needs converting to rows first.

Importing a bank statement into Excel means getting each transaction into its own row with a real date, a description and a number you can add up. A bank CSV gets you most of the way, but opening it with a double-click lets Excel guess formats, and its guesses are where swapped days and months, lost zeros and text-only amounts come from. Importing through Power Query avoids that.

Which file do you actually have?

What you do next depends on what the bank gave you.

If you do not have a file yet, our guide on exporting a bank statement from online banking explains where banks put the download and how far back it goes.

How do you import a bank CSV into Excel step by step?

Microsoft's article on importing text and CSV files sets out the route in Excel for Microsoft 365. With the bank file saved:

1. Click the cell where the data should start (a blank sheet is easiest).
2. On the Data tab, in Get & Transform Data, choose From Text/CSV.
3. Select the CSV and click Import. A preview window opens.
4. Check File Origin. The Power Query Text/CSV documentation notes that the character set is not inferred, and UTF-8 is detected only when the file starts with a byte-order mark. If you see characters like "é" where "é" should be, switch to UTF-8 (65001).
5. Check Delimiter. Most banks use commas; European ones often use semicolons.
6. Set Data Type Detection. "Based on first 200 rows" is the default. For bank files, choose Do not detect data types, which loads everything as text so nothing gets silently converted, and set types yourself in the next step.
7. Click Transform Data to open the Power Query editor.
8. If the first row holds the column names, use Use First Row as Headers on the Home tab. Delete any rows above it that hold the bank's name or account summary.
9. Set each column's type (next sections), then Home > Close & Load.

The result lands as a formatted Excel table connected to the query. When next month's CSV arrives, you can point the query's source at the new file and refresh rather than repeating every step.

Why do the dates come out wrong?

A date such as 04/07/2026 means 7 April in the US and 4 July in the UK. Excel reads text dates using your computer's regional format, so a UK bank file on a US-configured PC produces a mix of wrong dates (when the day is 12 or less) and errors or leftover text (when it is not). Microsoft's Power Query data types page walks through exactly this case.

The fix in the editor: right-click the date column heading, choose Change Type > Using Locale, pick Date as the type and the bank's country as the locale, for example English (United Kingdom). Power Query then reads day/month/year correctly and Excel displays the dates in your own format.

If you already loaded the data and the dates are sitting in cells as left-aligned text, Microsoft's guide to converting dates stored as text uses =DATEVALUE(A2) in a helper column, then Paste Special > Values over the original and a Short Date format. DATEVALUE also follows your regional settings, so it only helps when the text is already in your local order.

Fixing amounts and signs

Banks lay out money in three common ways, and analysis is much easier once every file uses one signed Amount column where money out is negative.

• One signed column. Already right. Set its type to Decimal Number.
• Separate Debit and Credit columns. In Power Query, add a custom column = [Credit] - [Debit] after replacing empty cells with 0. In a plain sheet, =IF(C2="",0,C2)-IF(B2="",0,B2) does the same.
• One positive column with a type flag (DR/CR, or "Debit"/"Credit"). Use a conditional column: if the flag says debit, multiply by -1.

Two more things break totals. Some statements show negatives in parentheses, such as (45.10), and some include currency symbols or thousands separators that a different locale reads wrongly. Use Replace Values to strip the symbol, and use Change Type > Using Locale for numbers too when the bank writes 1.234,56.

If amounts land as text in an existing sheet (they line up on the left and a green triangle appears), Microsoft's numbers stored as text fix is to select them, click the warning icon and choose Convert to Number, or use =VALUE() in a helper column.

Credit card exports deserve a second look: some show purchases as positive numbers. Flip them before combining a card with a checking account.

Leading zeros and long reference numbers

Sort codes, routing numbers, check numbers and card references often start with zero or run past 15 digits. Excel treats them as numbers, drops the leading zero and, beyond 15 significant digits, replaces the tail with zeros (the Decimal Number type tops out at 15 digits of precision). Neither change can be undone after saving.

Prevent it by setting those columns to Text in Power Query before loading. If you skipped the editor and the zeros are already gone, re-import; formatting the cells afterwards will not bring the digits back.

How do you import a PDF bank statement into Excel?

A PDF has no rows, only text placed on a page, so it has to be turned into a table first. Your options:

• Excel's Get Data > From PDF in Microsoft 365 for Windows can pick up tables from a text-based PDF. Our guide to importing a PDF into Excel covers the Navigator and how to combine pages.
• Copy and paste works for a page or two but usually drops everything into one column. The copy PDF table to Excel guide shows how to split it back out.
• A statement converter. QuickBankConvert reads the statement PDF you upload and returns date, description and signed amount columns, plus the running balance when the statement prints one, so the sign and date fixes above are already done. A free account can download Excel or CSV; the PDF to Excel page shows the output.

Turning the import into something you can analyse

Once the columns are clean:

1. Make sure the data is an Excel table (it is if it came from Power Query; otherwise press Ctrl+T) and give it a name such as Bank2026.
2. Add a Month column with =TEXT([@Date],"yyyy-mm") for grouping.
3. Add a Category column and fill it as you review.
4. Check completeness: opening balance plus the sum of Amount should equal the statement's closing balance. If it does not, a row is missing or a sign is wrong.

From here, a PivotTable answers most questions. Our guide to bank statements and pivot tables picks up at this point, and the CSV formatting fixes article helps with stubborn files.

Related guides

• Export a bank statement to Excel from online banking
• Bank statement data cleanup tips
• How to import a PDF into Excel