What you will get from this guide
Need Santander transactions in Excel, Google Sheets, or your accounting tool? The easiest path is a native CSV export from online banking for recent periods.
For older months (or statement archives) banks often only provide PDFs. KontoCSV converts those PDFs to clean CSV/Excel, including multi-page statements and common layout quirks.
Step-by-step
1. Export CSV from online banking (if available)
Look for an “Export”, “Download”, or “Transactions” section. CSV exports are usually limited to a date range (e.g. recent months).
2. Convert statement PDFs (for archives / missing CSV export)
Upload the PDF to KontoCSV. The parser removes headers/footers, keeps dates and signs intact, and merges multi-page statements into one export.
3. Choose the right export profile and import
Pick a target format like DATEV, Lexoffice, or sevDesk to avoid manual column mapping. Then import the CSV into your tool and quickly reconcile totals.
Best practices
- Keep both booking date and value date when your accounting workflow needs it.
- Avoid copy/paste from PDF into Excel: PDFs are optimized for printing, not for columns.
- If your statement includes balances, check that opening/closing balance matches after conversion (multi-page merge).
FAQ
Can I export CSV directly from Santander?
Often yes for recent transactions. For older periods, you may only get PDFs in the archive. Using both (CSV export + PDF conversion) is a common workflow.
What is the advantage of KontoCSV vs. generic converters?
Generic tools often break columns on German bank statements. KontoCSV focuses on statement layouts, preserves the sign of amounts, and supports accounting export profiles.
Which format should I use for DATEV?
Use the KontoCSV DATEV profile so delimiter/columns match common DATEV imports. If you import into other tools, pick their dedicated profile to reduce mapping work.
German original (more detail)
If you want the full German version with screenshots and extra edge cases, open the original guide here: