How to Import a Bank Statement CSV into Excel

You have converted your bank statement from PDF to CSV. Now what?

Getting the data into Excel or Google Sheets takes about two minutes — but a few settings, particularly around date and currency formatting, can make the difference between clean, usable data and a mess you have to fix manually.

(If you need to convert a different type of PDF to Excel, check out our complete guide on 5 methods to convert PDF to Excel.)

Importing into Microsoft Excel

Method 1: Excel's Import Wizard (Recommended)

The import wizard gives you control over how each column is parsed — particularly important for date columns that Excel sometimes misreads.

1. Open Excel and click the Data tab
2. Click Get Data → From File → From Text/CSV
3. Navigate to your CSV file and click Import
4. In the preview window, verify the column names and data look correct
5. Click Load to import into a new sheet

Method 2: Double-Click to Open

You can also double-click the CSV file to open it directly in Excel. This works fine for most files, but occasionally Excel misinterprets date formats — particularly if your regional settings differ from the file's format (MM/DD vs DD/MM). If dates look wrong after opening, use the import wizard instead.

Formatting the Data in Excel

After importing, two quick formatting steps make the data much easier to work with:

Format the Date column:

• Select the Date column
• Right-click and choose Format Cells → Date
• Select your preferred format (for example, MM/DD/YYYY)

Format the Amount column:

• Select the Amount column
• Right-click and choose Format Cells → Currency
• Set decimal places to 2

Convert to a Table (highly recommended):

• Click anywhere in your data
• Press Ctrl+T or go to Insert → Table
• Check "My table has headers"

Converting to a Table enables one-click sorting and filtering on every column, and makes formulas automatically extend to new rows.

Importing into Google Sheets

1. Open Google Sheets and create a new spreadsheet
2. Go to File → Import
3. Click the Upload tab and drag in your CSV file
4. Select Replace spreadsheet or Insert new sheet
5. Leave the separator type set to "Detect automatically"
6. Click Import data

Google Sheets handles CSV parsing well out of the box. Dates and amounts typically come through correctly without extra formatting steps.

Useful Formulas for Bank Statement Analysis

Once your data is in a spreadsheet, these formulas help you make sense of it:

Sum spending in a specific category — after adding a Category column, use SUMIF(CategoryRange, "Food", AmountRange) to total transactions in any category.

Total all debits — use SUMIF(AmountRange, "<0", AmountRange) to sum all negative (outgoing) amounts for the period.

Count transactions in a date range — use COUNTIFS with two date conditions to count transactions between any two dates.

Importing into Accounting Software

Bank statement CSV files from Statement PDF Converter work directly with major accounting platforms:

Most platforms ask you to map the columns (Date, Description, Amount) the first time you import. After that, they remember your mapping for future uploads.

What to Do With the Data

Now that your transactions are in a spreadsheet:

• Sort by amount to find your largest expenses immediately
• Filter by merchant to see all transactions from a specific payee
• Create a pivot table for a monthly spending breakdown by category
• Add a Category column and use SUMIF to total by category for budgeting or tax prep

For using your data to prepare for taxes, see how to organize bank statements for tax season. For small business workflows with multiple accounts, see PDF-to-CSV conversion for small business accounting.

Conclusion

Importing a bank statement CSV into Excel or Google Sheets takes under two minutes. The key steps: use the import wizard to control column parsing, and format dates and amounts after the import. From there, your transactions are ready for sorting, filtering, formulas, and analysis.

Need to convert your statement first? See our complete bank statement to CSV guide for the full process, or visit statementpdfconverter.com to convert your first statement free.