How to Convert a PDF Bank Statement to Google Sheets

Google Sheets does not have a native PDF import option. If you try to open a bank statement PDF through Google Drive, Drive's document viewer will display it, but there is no way to extract structured transaction data from it automatically. You need to convert to CSV first, then import that CSV into Sheets.

The good news is that once you have clean CSV data, the import into Google Sheets takes about a minute and the result is a live, editable spreadsheet you can analyze immediately.

Step 1: Convert your bank statement PDF to CSV

If your bank offers a native CSV download, use that rather than converting the PDF. Several major US banks let you download transaction activity directly:

• Chase: Transaction activity > Download > Activity (CSV). See the Chase guide.
• Bank of America: Account activity > Download > Microsoft Excel (.csv). See the BofA guide.
• Citibank: Account activity > Download. See the Citi guide.
• American Express: Statements and Activity > Download. See the Amex guide.

If your bank does not offer a CSV download, or you need to work with a specific monthly statement PDF, upload the PDF to Statement Pro. It auto-detects the bank and produces a clean CSV file with Date, Description, and Amount columns.

Step 2: Import the CSV into Google Sheets

1. Open a new or existing Google Sheets spreadsheet.
2. Click File > Import.
3. In the Import File dialog, click Upload and select the CSV file from your computer.
4. On the import settings screen:
   • Set Import Location to "Replace spreadsheet" (if this is a new sheet) or "Insert new sheet(s)" if you want to add it alongside existing data.
   • Set Separator type to "Comma".
   • Uncheck "Convert text to numbers, dates, and formulas" if you want to handle formatting yourself, or leave it checked to let Sheets auto-format.
5. Click Import data.

Your transactions will appear as rows in the spreadsheet with dates, descriptions, and amounts in separate columns.

Step 3: Format the data

After import, a few formatting steps make the data much easier to work with:

Format the Date column: Select the date column, then Format > Number > Date (or Date and Time if timestamps are included). This lets you use date functions and filters correctly.

Format the Amount column: Select the amount column, then Format > Number > Accounting or Currency. This adds a dollar sign and two decimal places consistently across all rows.

Freeze the header row: Click on row 1, then View > Freeze > 1 row. This keeps your column headers visible when you scroll down through a long transaction list.

Useful Sheets formulas for bank statement data

Once your data is in Sheets, a few formulas make analysis straightforward:

Sum by category or keyword:

=SUMIF(B:B,"*AMAZON*",C:C)

This sums all amounts in column C where the description in column B contains "AMAZON". Replace the keyword to total any merchant or category.

Filter by date range:

=SUMIFS(C:C,A:A,">="&DATE(2025,1,1),A:A,"<="&DATE(2025,1,31))

This totals amounts between January 1 and January 31, 2025. Adjust the dates as needed.

Count transactions above a threshold:

=COUNTIF(C:C,"<-100")

This counts all transactions where more than $100 left the account.

Keeping the data updated

Google Sheets does not connect to bank accounts directly (without third-party add-ons). If you want to add a new month, download the new statement, convert it to CSV, and import it using File > Import with "Append to current sheet" as the import location. You can then resort the full dataset by date to keep everything in chronological order.

For the full PDF-to-CSV conversion process, see How to Convert PDF to CSV. For importing into Excel specifically, see Bank Statement to CSV and Excel: The Complete Guide.