An Airwallex batch transfer template is a customised Excel (.xlsx) file used to send multiple international or local transfers at once. You can generate a template directly in the Airwallex web app under Transfers > Batch transfer. Always save and upload the file in .xlsx format.
What is an Airwallex batch transfer template?
A batch transfer template is a pre-formatted Excel file generated in the Airwallex web app. It contains specific field requirements, valid transfer methods, and drop-down values tailored to the countries and currencies of your payees.
Using this template ensures your transfer data matches Airwallex system requirements, preventing upload errors and processing delays.
How to generate a batch transfer template
- Navigation: Log in to the Airwallex web app, click New transfer, and select Batch transfer. Choose a “from account”, then click Batch transfer template.
- Select transfer methods: Select the transfer methods based on your payee’s bank account countries and currencies. The platform will display estimated transfer speed and fees for each method. Configure SWIFT fee options (if applicable)
- Set transfer currency rules: Indicate whether transfer amounts will be entered in the currency you pay or the currency the payee receives.
- Download the Excel file.
How to read color coding and legend in the template
Airwallex batch templates use dynamic colour coding and cell rules to guide data entry:
| Cell type | Meaning | Action required |
| Grey cell with value | Pre-defined mandatory system field | Do not edit. Required for system parsing. |
| Grey cell without value | Irrelevant for this specific row | Do not edit. Leave blank. |
| White cell with value | Required user field | Edit cell with your transaction details. |
| White cell without value | Optional field | Optional. Fill in if needed. |
Validating field inputs
- Drop-down lists: Use the built-in drop-down menus for fields like Currency you pay, SWIFT fee option, Fee paid by, Transfer purpose, Country, and State.
- Example data (e.g., xxx): If no drop-down menu is available, follow the formatting shown in the sample text.
Best practices for filling out a batch transfer file
To prevent file parsing failures and upload errors, follow these rules:
- Always edit the original template file: Do not copy and paste cell values into a blank Excel sheet. The downloaded file contains hidden schema data required for validation.
- Use .xlsx format only: Airwallex does not accept .csv or .xls file formats for updated batch transfers.
- Keep standard headers intact: Never rename, reorder, or delete column headers.
- Format cells as text: Ensure the number format for all cells is set to Text to prevent stripped leading zeroes in account or routing numbers.
- Use Google Sheets carefully: If using Google Sheets or Excel Online, upload the original .xlsx file, make your edits, and re-export it as a .xlsx file.
- Bulk copying rows: To duplicate settings across rows using the same transfer method, drag the Excel fill handle (+ icon) across the row.
- Automating data mapping: Use Excel formulas like VLOOKUP or XLOOKUP to pull payee details from your internal accounting files into the Airwallex template.
Frequently asked questions (FAQ)
Can I still use my older batch transfer CSV or XLSX files?
Yes. Existing batch transfer files (.csv or .xlsx) created prior to recent releases can still be processed. However, if you add new currencies, transfer corridors, or transfer methods, you must generate a new template from the Airwallex web app.
Can I choose different SWIFT fee options for different rows in the same file?
Yes. You can customise the SWIFT fee option (OUR or SHA) and Fee paid by values individually for each transfer line within a single batch file.
What file formats are supported for batch transfer uploads?
Airwallex only accepts the .xlsx file format for new batch transfers. Files saved as .csv or .xls will fail to upload.