How to Convert ING Bank Statements to Excel
Quick Answer: To convert an ING Bank statement PDF to Excel or CSV, log in to your ING online banking portal, download your statement as PDF, then upload to [QuickBankConvert](/) β free, browser-based conversion with no account required and your data never leaving your device.
Why ING Customers Need Statement Conversion
ING Group is one of the largest financial institutions in Europe, operating retail banking under the ING brand in the Netherlands, Belgium, Germany, Austria, Spain, Italy, Australia, and other markets. While ING Netherlands (mijn.ing.nl) offers good structured data export options β including CSV and MT940 β many ING entities globally and many customers still work with PDF statements.
The need for Excel or CSV conversion of ING statements spans multiple user types:
- ING Netherlands customers who have downloaded historical PDF statements before the export feature was added or available for their account type
- ING Direct Spain, Australia, and other regional customers where CSV export may be limited or unavailable
- SME owners importing ING business account transactions into Exact Online, AFAS, or Twinfield
- Expats managing Netherlands-based ING accounts from abroad who need structured data for their home country tax filings
- Individuals using personal finance tools or Excel-based budgets who want transaction data from their ING account
- ZZP'ers (Dutch self-employed) tracking business income and expenses for Belastingdienst (Dutch Tax Authority) VAT and income tax declarations
For all these use cases, QuickBankConvert converts ING statement PDFs to clean, usable CSV or Excel format β handling Dutch date formats, European number notation, and ING's specific column structure.
How to Download Your ING Statement
Downloading via ING Online Banking β Netherlands (mijn.ing.nl)
- Go to mijn.ing.nl and log in with your ING app QR code, fingerprint, or password.
- Select your account (Betaalrekening, Spaarrekening, etc.) from the dashboard.
- Click Afschriften (Statements) in the account menu.
- Select the statement month or period.
- Click Download PDF (or Exporteren for CSV/MT940 if available).
Callout β ING Direct CSV Export (Netherlands): ING Netherlands offers CSV and MT940 export directly from the Afschriften (Statements) section. If the Exporteren option is visible for your account, use it for direct accounting import. For PDF statements you already have or accounts without export access, proceed with QuickBankConvert.
Downloading via ING App
- Open the ING App (iOS/Android).
- Tap your account.
- Tap Afschriften or Statements.
- Select the period and download as PDF.
- Transfer the PDF to your computer for conversion.
ING Direct Spain
- Log in at ingdirect.es or via the ING app.
- Go to Mi PosiciΓ³n β Cuenta NΓ³mina (or your account).
- Select Extractos and choose your date range.
- Download the PDF statement.
ING Direct Australia
- Log in to ING Online Banking at ing.com.au.
- Select your account and go to Transaction History.
- Choose your date range and export as PDF.
Converting ING PDF to Excel or CSV
Step 1: Open QuickBankConvert
Visit [QuickBankConvert.com](/) in any browser. No account, no installation.
Step 2: Upload Your ING PDF
Drag and drop your ING statement PDF onto the upload area. Processing happens entirely in your browser β your data stays on your device.
Step 3: Preview Extracted Transactions
Review the transaction preview. Check that dates (DD-MM-YYYY for ING Netherlands, DD/MM/YYYY for ING Direct), transaction descriptions (omschrijvingen), and EUR or AUD amounts are correctly extracted.
Step 4: Choose Output Format
- CSV β Best for Exact Online, AFAS Profit, Twinfield, Xero, or QuickBooks
- Excel (XLSX) β Best for direct use in Microsoft Excel or Google Sheets
Step 5: Download and Open
Download and open in your preferred tool.
Callout β European Number Format: ING Netherlands statements use Dutch/European number formatting β periods as thousands separators and commas as decimal separators (e.g., 1.250,00). QuickBankConvert normalizes these to standard format (1250.00) so Excel formulas and accounting imports work correctly.
ING-Specific Formatting Challenges
Dutch Date Format
ING Netherlands uses DD-MM-YYYY (e.g., 05-08-2024 = August 5, 2024). ING Direct Spain and Australia use DD/MM/YYYY. QuickBankConvert identifies all ING date formats correctly.
European Number Notation
Dutch and European standard uses:
- Period (.) as thousands separator
- Comma (,) as decimal separator
Example: 1.250,00 = 1,250.00
QuickBankConvert normalizes these during conversion for standard numeric output.
ING Transaction Description (Omschrijving)
ING Netherlands statements include rich transaction metadata in the description:
- Sender/receiver name
- IBAN of the other party
- Payment reference (Kenmerk)
- iDEAL, SEPA, or PIN transaction code
All of this text is preserved in the converted description field.
Tegenrekening (Counterparty IBAN)
ING statements include the counterparty IBAN (Tegenrekening) for bank transfers. QuickBankConvert may extract this as part of the description field.
ING Spaarrekening (Savings Account)
ING savings account statements have a simpler format than payment account statements β fewer columns and mostly interest credit entries. These convert correctly with QuickBankConvert.
ING Export Format Comparison
| Method | Format | History | Notes |
|---|---|---|---|
| mijn.ing.nl PDF | Up to 24 months | Standard; always available | |
| mijn.ing.nl CSV/MT940 export | CSV/MT940 | Varies | Some account types; check Afschriften β Exporteren |
| ING App | Up to 24 months | Needs transfer to PC | |
| ING Direct Spain PDF | 12 months | Extractos section | |
| ING Direct Australia PDF | 12 months | Transaction History section | |
| Branch request | Certified PDF | Full history | Older statements; fee may apply |
Importing into Accounting Software
Exact Online (Netherlands)
Exact Online is the most widely used accounting platform for Dutch SMEs. After converting your ING statement to CSV with QuickBankConvert, import via Financieel β Banken β Bankafschriften importeren. Map the datum, omschrijving, debet, and credit columns. Exact Online handles EUR natively.
AFAS Profit
AFAS is another major Dutch business software suite. Bank statement imports are handled via the AFAS Bankimport module. Map your ING CSV columns to AFAS's expected format.
Twinfield
Twinfield (Wolters Kluwer) is used by Dutch accounting firms. Import bank statements via the bank module using CSV format. Map date, description, and amount columns.
Xero (International ING Customers)
Expats and international businesses with ING accounts can import converted CSVs into Xero via Accounting β Bank Accounts β Import Statement. EUR accounts work natively in Xero.
Belastingdienst Tax Declaration (ZZP'ers)
Dutch ZZP'ers (zzp = zelfstandige zonder personeel, self-employed) filing annual income tax (IB aangifte) and quarterly BTW (VAT) returns benefit significantly from having ING transaction data in Excel:
- Sum income (omzet) per quarter for BTW filing
- Total deductible business expenses (telefoon, internet, kantoorartikelen, auto)
- Calculate and verify BTW amounts charged on invoices vs. received
Converting monthly ING statements to CSV and consolidating into an annual Excel workbook is a common workflow for Dutch freelancers.
Bottom Line
Converting ING Bank statement PDFs to Excel or CSV is straightforward: download from your ING Online Banking portal (mijn.ing.nl, ingdirect.es, ing.com.au, or your regional ING platform), then convert with [QuickBankConvert](/) in under two minutes.
ING PDFs use European date formatting, Dutch/European number notation, and SEPA payment references β all handled correctly by QuickBankConvert. The output works in Excel, Google Sheets, Exact Online, AFAS, Twinfield, Xero, and QuickBooks.
Whether you're a Dutch ZZP'er tracking business expenses, an expat managing a Netherlands account, or an SME reconciling ING transactions in your accounting system, converting your ING statement from PDF to spreadsheet format gives you the data access you need.
Frequently Asked Questions
Does ING Netherlands offer a direct CSV or MT940 export?
What date format does ING use in statements?
Can I convert ING statements in Dutch?
Does QuickBankConvert work with ING Direct (Australia, Spain)?
Ready to convert your bank statement?
Free. Private. Instant. Your files never leave your browser.
Convert Your Statement