The Scenario
You are a treasury analyst. The payment batch goes to the bank at 4 PM. You have an Excel workbook with 150 counterparty BIC codes on the Payments tab from incoming payment instructions this week.
Your bank requires SWIFT code, correspondent account, and city for every payment row before processing. Those columns are blank. The last batch was rejected because three SWIFT codes were wrong.
The slow version of this afternoon:
- Open the Central Bank BIC directory
- Search each BIC manually
- Copy the bank name, SWIFT, and correspondent account
- Paste them into the workbook
- Repeat 150 times while fielding calls from the CFO
- Miss a row at 3:47 PM and send an incomplete batch.
The fast version is one prompt and the enriched workbook is ready with two hours to spare.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the BIC column on the Payments tab, calls DaData's bank lookup for every row, and writes the bank metadata back.
Open the SheetXAI sidebar and type:
For each BIC code in column A of the Payments tab, use DaData to look up the bank and write the bank's full name into column B, the SWIFT code into column C, the correspondent account number into column D, and the city into column E. If DaData returns no result for a BIC, write "NOT FOUND" in column B and leave the rest blank.
SheetXAI reads the BIC column, calls DaData for each row, and writes four columns of bank metadata back. All 150 rows, verified against the official CBR registry, ready for the 4 PM batch.
What You Get
Four enriched columns next to every BIC in the workbook:
- Column B — official bank full name from the CBR registry
- Column C — SWIFT / BIC international code
- Column D — correspondent account number (korr. schet)
- Column E — city of the bank's registered branch
NOT FOUND rows are flagged explicitly. Liquidated banks and invalid BICs are visible before the batch goes out.
What If the Data Is Not Quite Ready
Payment instruction data from emails and PDFs has formatting issues. SheetXAI handles them in the same prompt.
When BIC codes have extra spaces or formatting from PDF copy-paste
Some rows have BICs with spaces or dashes.
Before looking up each BIC in column A of the Payments tab, strip all spaces and non-numeric characters. If the result is fewer than 9 digits, pad with leading zeros. Then run the DaData bank lookup and write results to columns B through E.
When you need to flag revoked banks before the payment goes out
Some counterparties use BICs for banks that have had their license revoked.
For each BIC in column A, use DaData to look up the bank and write name, SWIFT, correspondent account, and city into columns B through E. In column F, write "REVOKED — DO NOT PAY" if DaData shows the bank's license has been revoked. Otherwise write "OK."
When you have both BICs and IBANs mixed in the same column
Some rows use Russian BIC, others have international IBANs from foreign counterparties.
For rows where column A contains a 9-digit BIC, use DaData's bank lookup and write the bank name and SWIFT into columns C and D. For rows where column A contains an IBAN (starting with a 2-letter country code), write "INTERNATIONAL — MANUAL REVIEW" in column C and leave column D blank.
When the CFO wants a pre-batch audit summary in the same workbook
You need the enriched columns plus a summary tab so the CFO can sign off without reading 150 rows.
Enrich all 150 BIC codes in the Payments tab using DaData — name to column B, SWIFT to column C, correspondent account to column D, city to column E. Flag revoked banks in column F. Then create a new sheet called "CFO Summary" with: total BICs processed, number of NOT FOUND results, number of revoked banks flagged, and total rows cleared for payment.
The pattern: the enrichment and the audit trail come from the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel payment workbook with BIC codes, then ask it to enrich the rows with DaData bank metadata. The DaData integration is included in every SheetXAI plan. For related workflows, see how to validate Russian passport numbers in Excel or the DaData in Excel overview.