Bulk CSV Validation

Validate thousands of bank coordinates in a single request by uploading a CSV file.

Business Pack Feature

Bulk CSV validation is available exclusively with the Business Pack (100,000 validations). Each row in the file consumes one validation credit.

How It Works

Prepare Your CSV

Create a CSV file with the required columns: type, identifier, account_number. Each row represents a bank coordinate to validate.

Upload the File

Upload your CSV file via the POST /api/v1/validate/bulk endpoint. Processing is asynchronous for large files.

Download Results

Download the enriched CSV file with result columns: status, confidence, bank_name, and errors.

CSV Format

Required Columns

Column	Description	Example
type	Validation type: US, UK, SWIFT, or IBAN	US
identifier	Primary identifier (routing number, sort code, BIC, or IBAN)	021000021
account_number	Account number (required for US and UK, empty for SWIFT and IBAN)	1234567890

Supported Types

ABA Routing

Sort Code

SWIFT

BIC/SWIFT

IBAN

Example CSV File

type	identifier	account_number
US	021000021	1234567890
UK	200000	58658244
SWIFT	CHASUS33
IBAN	DE89370400440532013000

API Endpoint

POST/api/v1/validate/bulk

Send your CSV file via a multipart/form-data request.

Content-Type:multipart/form-data

Max file size:10 MB

Max rows:10,000

curl

curl -X POST https://bankvalidor.com/api/v1/validate/bulk \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -F "file=@bank_coordinates.csv"

Response Format

The returned CSV file contains the original columns plus result columns added by BankValidor.

Added Columns

Column	Description
status	Validation result: VALID, WARNING, or INVALID
confidence	Confidence level: HIGH, MEDIUM, LOW, or NONE
bank_name	Identified bank name (if found in registries)
errors	Detailed error messages (if validation fails)

Full Example

Input file (input.csv)

input.csv

type,identifier,account_number
US,021000021,1234567890
UK,200000,58658244
SWIFT,CHASUS33,
SWIFT,INVALIDXX,
IBAN,DE89370400440532013000,

Output file (output.csv)

output.csv

type,identifier,account_number,status,confidence,bank_name,errors
US,021000021,1234567890,VALID,HIGH,JPMorgan Chase,
UK,200000,58658244,VALID,HIGH,Barclays Bank,
SWIFT,CHASUS33,,VALID,HIGH,JPMorgan Chase Bank N.A.,
SWIFT,INVALIDXX,,INVALID,NONE,,Invalid SWIFT/BIC format
IBAN,DE89370400440532013000,,VALID,HIGH,Commerzbank,

Limits and Constraints

10,000 rows maximum per file
Files exceeding this limit will be rejected. Split your files if necessary.
1 concurrent upload per API key
Additional uploads will be queued and processed sequentially.
5-minute timeout
Large files may require several minutes to process. Use webhooks to be notified of completion.