To simplify the batch file creation, we provide a helper Excel spreadsheet that automatically generates the SEPA XML file based on your inputs. This can be used with copy-pasted data from another spreadsheet or existing CSV files.
Download the Excel Spreadsheet file using direct link below:
<aside>
⚠️ Excel 2019 or later should be used
</aside>
When opening, Excel will ask whether to enable Macros. Macros support is needed so that the generated XML contents might be saved as a file.
While you might instead try copying the generated XML content from the File sheet, Excel makes it tedious as it automatically quotes the text (and double-quotes the text inside), breaking the XML format altogether. Thus, enabling Macros is highly recommended.
Change the PayerName and PayerAccount in the Configuration sheet to your company title and account IBAN from which you want to initiate the payments.
Supply the payment data in the Payments sheet, one per line:
RecipientName. Make sure to use latin-only symbols.RecipientAccount. The IBAN of the recipient.EuroAmount. Amount in euros, such as 32.99. Only payments in Euros are supported at this time using this method.Details. Payment description. Make sure to use latin-only symbols.The recommended way to fill-up this sheet is by copy-pasting the data from your own Spreadsheet/CSV file. Feel free to reorder the columns before doing so.