The Excel table is chaos
Typical issues: everything ends up in one column, dates and amounts merge, numbers are treated as text, or rows shift when descriptions wrap.
Why it happens
PDFs are not spreadsheets. They store visual layout, not a strict table structure. Excel can read text, but it cannot reliably reconstruct statement columns from a PDF layout.
How to fix it
Recommended: convert PDF to CSV
Use a statement converter to extract rows/columns correctly, then open the CSV in Excel.
Convert nowExcel import (sometimes helps)
Use Data → From Text/CSV and choose the correct delimiter and encoding. This does not fix scanned PDFs.
Excel workflow guideFAQ
Does this work for scanned PDFs?
Scans require OCR. If there is no selectable text, Excel import will not help.
Why are amounts treated as text?
It is usually locale/formatting (comma vs dot) or broken delimiter parsing. A clean CSV export fixes this.
German original
The full German version is here:
Open German article