How to Import Santander Bank Statement into Google Sheets

To import your Santander statement into Google Sheets: download your PDF from bancosantander.es → Online Banking → Mis Cuentas → Extractos, convert it to CSV using Bank Statement Converter (free, under 20 seconds), then upload via Google Sheets → File → Import → Upload. No manual re-keying — all transactions transfer automatically.

Step 1: Download Your Santander Statement

  1. 1. Log in at bancosantander.es and go to 'Mis Cuentas' (My Accounts)
  2. 2. Select the account you need a statement for
  3. 3. Click 'Extractos' (Statements) from the account details menu
  4. 4. Choose the statement period using the date range selector
  5. 5. Click 'Descargar PDF' (Download PDF) to save the statement to your device

Step 2: Convert PDF with Bank Statement Converter

Upload your PDF to Bank Statement Converter — select CSV output — download in under 20 seconds.

Step 3: Import into Google Sheets

  1. 1. Open Google Sheets (sheets.new) and create a new blank spreadsheet
  2. 2. Click File → Import → Upload
  3. 3. Drag and drop the CSV file from Bank Statement Converter
  4. 4. Choose 'Replace current sheet' or 'Insert new sheet(s)'
  5. 5. Click 'Import data' — all transactions appear with correct columns

Frequently Asked Questions

How do I download my Santander bank statement?
Log in at bancosantander.es and go to 'Mis Cuentas' (My Accounts) → Select the account you need a statement for → Click 'Extractos' (Statements) from the account details menu → Choose the statement period using the date range selector → Click 'Descargar PDF' (Download PDF) to save the statement to your device
Should I import as CSV or Excel into Google Sheets?
Either works. CSV is slightly simpler — File → Import → Upload. If you download Excel (.xlsx) from Bank Statement Converter, you can also open it in Google Sheets via File → Import → Upload and select the .xlsx file.
Does Google Sheets automatically detect dates in CSV imports?
Usually yes. If dates import as plain text, select the date column, click Format → Number → Date to apply proper date formatting. Then you can use MONTH() and YEAR() formulas for analysis.
Can I use Google Sheets formulas on the imported data?
Yes. All Google Sheets functions (SUMIF, QUERY, VLOOKUP, FILTER) work immediately on the imported transaction data. QUERY is especially powerful for date-range filtering.
Is my Santander data safe to upload?
Yes. Bank Statement Converter processes files in-memory and deletes them immediately after conversion. No data is stored, logged, or used for model training. No account is required.
Convert Free — No Signup