README

This SQL table contains 4810 entries. The data is generated by me from the Bundesbank Files in July 2025 and are valid from 09.06.25 to 07.09.2025

Find new CSV - File: Bundesbank CSV Download

At actual state you have to download the file, open it in your preferred spreadsheet application and save it as "utf-8". They stated that their file is "ASCII" and mb_detect_encoding($csvContent) is returning the same but mb_convert_encoding($csvContent, 'UTF-8', 'ASCII') is not working with german umlauts. Either the hole file nor the single row entry.

There is a ImportBlz Command and you can use it from command line like: ddev typo3 static-info-tables-bic-de:import:blz --file=blz-aktuell-csv-data.csv --skipFirstLine or use it with a scheduler task. Location of the file where it is searched is fileadmin

Each imported table row contains and rows with no swiftcode where not imported:

• The german BIC (BLZ)
• The name of the associated bank
• The Swiftcode / BIC

This table and the data in it is believed to be in the public domain. If you'd like to submit changes or updates, feel free to drop me a line.

Michael Staatz