Statement to Google Sheets with Statement to Spreadsheet
This page opens with a statement that has separate Debit, Credit and Balance columns and CSV as the download. A CSV is the format Google Sheets imports most reliably, so you read the PDF here, download the file, and bring it into a sheet with File, then Import.
- Drop your statement PDF on the tool. It is read in your browser and never uploaded.
- Check the preview and fix or untick any amber rows, then press Download CSV.
- In Google Sheets choose File, then Import, then Upload, and pick the CSV.
- In the import options keep the separator as comma and turn off Convert text to numbers, dates and formulas if you want descriptions kept exactly as printed.
What to know
Google Sheets cannot read a bank PDF directly, and pasting from a PDF usually collapses the columns into one. Reading the table by position first, then importing a CSV, keeps every value in its own cell. The CSV has a fixed set of columns: Date, Description, Debit, Credit, Amount and Balance, with any extra columns the statement has, such as a reference number, added after them.
Dates in the CSV are written as yyyy-mm-dd, which Sheets recognises as a date in any regional setting, so the day and month are never swapped by the importer. Amounts are plain numbers with a dot as the decimal separator and no thousands separators, so they stay numbers instead of turning into text.
The file is built in your browser, so the statement is not uploaded to us. When you import into Google Sheets it goes to your own Google account, which is the usual place for the data to end up. If you want a record that the conversion matches the statement, use the balance check shown above the preview.
Updated · Cosmovex
Questions
Can Google Sheets open a PDF statement directly?
Not as a table. Opening a PDF in Google Drive gives you text, not columns, and copy and paste usually merges the columns. Converting to CSV first keeps each value in its own cell.
Why choose CSV and not Excel for Sheets?
Both import, but CSV is simple and predictable: no formatting surprises, and dates as yyyy-mm-dd are read correctly in any regional setting. Choose Excel if you prefer typed cells and plan to open the file in Excel as well.
Will Sheets change my descriptions or amounts?
Amounts import as numbers. If a description looks like a date or a formula, Sheets may convert it unless you turn off Convert text to numbers, dates and formulas in the import dialog.
Is the statement sent to Google or to you?
Not by this tool. It reads the PDF in your browser and builds the CSV there. Importing the CSV into Google Sheets is your own step and sends it to your Google account.
Does it handle statements with Debit and Credit columns?
Yes. Statements with separate Debit and Credit columns, or one signed Amount column, are both read, and the CSV always includes Debit, Credit and a signed Amount.
The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.