Skip to content

Convert Santander México statements to Excel or CSV

Santander México doesn't usually offer a spreadsheet export of a full estado de cuenta, and only a limited number of past months stays online in Santander Web or the app, so save the PDFs you need. BankConv converts them to Excel, CSV or Google Sheets. Expect deposits before withdrawals and a reference number on every line.

Updated

Download your Santander México estado de cuenta

  1. 1.Sign in to Santander Web (santander.com.mx) on a computer, or open the Santander México app.
  2. 2.Select the account.
  3. 3.Look for Estados de cuenta and choose the period.
  4. 4.Download the PDF.

Do you need to convert at all?

Santander México usually provides the estado de cuenta as a PDF in Santander Web and the app. Business customers using Enlace can also get electronic statements as XML.

Movements online cover recent activity only, and the PDF is not a spreadsheet. Only a limited number of past months is usually available online, so download the ones you need.

Santander México export formats: PDF

What to know about Santander México PDFs

Deposits before withdrawals
The movements table usually lists Depósitos before Retiros, the reverse of many other banks. Check the column order when you map the CSV in your accounting software, so money in isn't imported as money out.
A reference number on each line
Movements usually carry a folio or reference number in its own column. Keep it as text so long numbers aren't turned into scientific notation in Excel.
SPEI details on extra lines
SPEI transfers often add lines under the description with the counterparty bank, reference and tracking key (clave de rastreo). Check that these joined the right movement instead of becoming new rows.

Converting a Santander México estado de cuenta

Santander México’s estado de cuenta normally comes as a text-based PDF. The first pages hold the account summary and notices; the movements table converts row for row, with amounts in pesos (MXN) using a decimal point.

  1. Download the PDF estados de cuenta from Santander Web or the app.
  2. Upload them to BankConv, up to 10 at a time.
  3. Check the rows, then export Excel or CSV.
A Santander México estado de cuenta converted, with deposits and withdrawals kept separate.

What to check

The summary near the start of the statement lists the saldo anterior, total deposits, total withdrawals and saldo final. Use it to check the conversion yourself.

  • Sum Depósitos and Retiros and compare them with the summary totals.
  • Check that saldo anterior + depósitos − retiros = saldo final. With a saldo anterior of 18,420.50, the sample rows above end at 24,094.75.
  • Confirm the Folio column stayed as text.
  • Add the year to each date if your software needs it, and check statements that cross into January.

For another Mexican estado de cuenta, with two dates per movement, see BBVA México.

Files are deleted after 24 hours; see security. Other Mexican banks are on the Mexican banks page.

How to convert a Santander México estado de cuenta to ExcelVideo coming soon · 1:15
Product screenshotBankConv results page after converting a Santander México statement (anonymised): rows table, format switch and export button.
A Santander México estado de cuenta converted in BankConv

Columns you get

FechaFolioDescripciónDepósitosRetirosSaldo
03-SEP-20264471201ABONO TRANSFERENCIA SPEI BANORTE CLIENTE LOPEZ9,500.0027,920.50
04-SEP-20264471288PAGO DE SERVICIO TELMEX589.0027,331.50
06-SEP-20264471402COMPRA SORIANA HIPER QRO1,236.7526,094.75
09-SEP-20264471557RETIRO CAJERO AUTOMATICO2,000.0024,094.75

Sample rows in Santander México's layout, fictional data. First 5 pages free to check.

  • Deleted after 24 hours

    Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.

  • Read only to extract transactions

    Your statement is read (with OCR for scans) to pull out the transaction rows you download.

  • Encrypted in transit

    Uploads and downloads use HTTPS (TLS).

  • Passwords never stored

    The password of a protected PDF is used once to open the file.

  • No bank login

    BankConv works from the PDF you download, never from a connection to your bank.

How we handle your data

Santander México statement questions

Can I download a Santander México estado de cuenta in Excel?

Not usually. Santander provides the estado de cuenta as a PDF. Convert it in BankConv to get Excel or CSV with one row per movement.

Can I import the result into CONTPAQi or Alegra?

BankConv exports CSV and Excel. CONTPAQi and Alegra can generally import bank movements from a spreadsheet file; map the date, description, depósito and retiro columns in their import screen.

Is SuperNet the same as Santander Web?

Yes. Santander México renamed its online banking from SuperNet to Santander Web. Statements are still downloaded as PDF there.

Other Mexico banks

  • BBVA México
  • Banorte
  • Banamex
  • HSBC México
  • Nu México
All Mexico banks