How do you get a PDF bank statement into Google Sheets?

By Kayabyte · Last updated 4 November 2026

Google Sheets cannot read a PDF statement as rows, but it imports a CSV. Convert the statement to a CSV first, then in Sheets choose File, Import, upload the file and pick a separator. Google’s help page for importing files lists the options (Create new spreadsheet, Insert new sheets, Replace spreadsheet, Replace current sheet, Append rows to current sheet, Replace data starting at selected cell) and, for CSV, the separator choices Detect automatically, Tab, Comma and Custom (support.google.com, checked 4 November 2026). Not every file type offers all six options.

Step 1: get a CSV

Ask your bank for a CSV download on the transactions page first; labels vary by bank. If you only have PDFs, convert them to a CSV with a tool that checks the totals. See how to convert a PDF bank statement to CSV for the manual route and its traps: wrapped lines, merged debit and credit columns and swapped dates.

Step 2: import into Google Sheets

Open a spreadsheet in Google Sheets, or a blank one.
Choose File, then Import.
Pick the CSV from your computer. It must not be password-protected.
Choose an import option. “Create new spreadsheet” keeps each month separate. “Insert new sheets” adds a tab per month to a yearly workbook. “Append rows to current sheet” stacks months under each other, so make sure the header row is not repeated in the data.
Choose the separator. Detect automatically usually works; pick Comma if columns land in one cell. If your CSV uses semicolons, choose Custom and type the semicolon.
Click Import.

Check these before you trust the sheet

Date order. 03/04/2026 can mean 3 April or 4 March. Compare a date with the day of the month you know from the statement. If you export the CSV from your own tool, ISO dates (2026-04-03) are unambiguous.
Signs. Money out should be negative in one signed column, or in a separate debit column. Add up the column and compare with the statement.
Totals. Opening balance plus credits minus debits should equal the closing balance. A total that is off means a missing, doubled or reversed row.
Appended months. Make sure the opening balance of one month equals the closing balance of the one before.

With Balanced

Balanced is a Mac app we make. You open the PDF, scanned PDF or CSV statement, see the transaction table in a preview, and fix what each column means, the date order and the sign handling. It checks that the opening balance plus the transactions equals the closing balance, and the running balance on each row when the statement has one, and asks before it decides a sign it is not sure about. Exporting a CSV is one step, with the delimiter and date format you choose; then you import that file with the steps above. Everything runs on your Mac and statements never leave it.

We have not tested the Google Sheets import itself with Balanced files, so look at the first import before you append twelve months.

Steps with Balanced

Open the statement in Balanced with Add Files or by dragging it in.
Check the preview and the totals check.
Export CSV, choosing comma as the delimiter and a date format Sheets reads, such as yyyy-mm-dd.
In Google Sheets choose File, Import and follow the steps above.

The free version converts and checks everything and exports the first 10 transactions per file. Pro is USD 59 per year or USD 7.99 per month. Macs running macOS 15 or later are supported. Download Balanced · Pricing

Questions

Can Google Sheets open a PDF bank statement? Not as a table. A PDF stores text by position, so you need a CSV first.

Does my statement data leave my Mac? Not in Balanced. Importing into Google Sheets uploads the CSV to Google, which is your choice.

Comma or semicolon? Use whichever your CSV was written with. If everything lands in column A, import again with the other separator.