How to get a bank statement PDF into Google Sheets

Short answer

1. Convert the statement PDF to CSV.
2. In Google Sheets, choose File › Import and pick the CSV.
3. Check the dates and amounts against the PDF.

Step 1: Convert the PDF to CSV

1. Open Bank Statement PDF to CSV and drop the statement PDF. It must be text-based: if you can highlight a word in the PDF, it will work. Scans and photos won't.
2. Check the rows. Click any cell to fix it, rename a heading by clicking it, or remove a column you don't want in the sheet with the ✕ in its heading.
3. If you want one Amount column to add up, click Combine into one Amount column. Money out becomes negative and money in stays positive. The button appears when the statement has separate money-out and money-in columns.
4. Download the CSV. The free version exports the first 15 rows; the full version ($19 once) exports every row.

Step 2: File › Import in Google Sheets

From Google's help article on importing (checked 2026-11-08):

1. Open a spreadsheet in Google Sheets.
2. Choose File › Import and select the CSV file.
3. Choose an import location (see the table below).
4. For the separator type, leave Detect automatically or choose Comma.
5. Click Import.

Google notes that not every import location is offered for every file type. The dialog may show other options depending on the version; follow what you see on screen.

Check dates and amounts after import

Quietools does not reformat dates: a statement that prints 01/05/2026 gives 01/05/2026 in the CSV. Google says changing a spreadsheet's locale changes its default currency, date and number formats (Google help); the locale is in File › Settings. We have not confirmed how each locale reads a date like 01/05/2026, so compare a few rows with the PDF, especially dates where the day is 12 or lower.

Amounts use a dot as the decimal separator with no thousands separators or currency symbols. If you combined the money columns, a formula such as =SUM(C2:C) gives the net change for the period. If you kept separate columns, withdrawals are positive numbers in their own column.

Size is rarely a problem for a statement: Google's Drive limits page gives up to 20 million cells and 100 MB for a spreadsheet created in or converted to Sheets.

Why the privacy of the CSV matters after import

Quietools' promise covers the conversion: the PDF is read in your browser and 0 bytes of it are sent to a server. Importing the CSV into Google Sheets is a separate step. After it, the rows live in your Google account and follow your Google settings and the spreadsheet's sharing settings.

• Remove columns you don't need in the sheet, such as Balance, before you download the CSV.
• Edit or shorten descriptions that contain reference or card numbers you don't want to keep.
• Check who the spreadsheet is shared with before adding a statement to it.

Using QuickBooks Online or Xero instead? See Bank statement PDF to CSV for Xero and QuickBooks.

Questions