SWIFT/BIC Codes Database

SWIFT/BIC codes for banks and financial institutions worldwide. 232 countries, 112,000+ records.

What is this?

This repository provides a ready-to-use database of swift/bic codes database with 112,887 records across 232 countries. Available as SQLite database and SQL dumps — ideal for developers, data analysts, and fintech applications.

Downloads

Format	Description	Link
SQLite	Single database file, ready to query	Releases
SQL	SQL dump, import into MySQL/PostgreSQL/etc.	Releases
Excel / CSV / PDF	Formatted spreadsheets	listbase.org

Database Schema

CREATE TABLE swift_codes (
  country_code TEXT NOT NULL,
  swift_code TEXT NOT NULL,
  bank TEXT,
  city TEXT,
  branch TEXT
);
CREATE INDEX idx_swift_codes_country_code ON swift_codes (country_code);
CREATE INDEX idx_swift_codes_swift_code ON swift_codes (swift_code);

Stats

• 112,887 records
• 232 countries
• Updated: 2026-07-30

Preview

country_code	swift_code	bank	city	branch
AD	BACAADAD	ANDORRA BANC AGRICOL REIG S.A.	LES ESCALDES
AD	AAMAADAD	ANDORRA GESTIO AGRICOL REIG SAU	ESCALDES-ENGORDANY
AD	BSANADAD	BANC SABADELL D'ANDORRA S.A.	ANDORRA LA VELLA
AD	CASBADAD	BANCA PRIVADA D'ANDORRA S.A.	LES ESCALDES
AD	CRDAADAD	CREDIT ANDORRA,S.A.	ANDORRA LA VELLA
AD	BINAADAD	MORA BANC GRUP SA	ANDORRA LA VELLA
AD	BINAADB1	MORA BANC SAU	LES ESCALDES
AD	RINSADA1	RESULT INTERNACIONAL SA	ANDORRA LA VELLA
AD	VALBADAD	VALL BANC	ESCALDES-ENGORDANY
AE	ABNAAEAAIPC	ABN AMRO BANK N.V. UNITED ARAB EMIRATES	DUBAI	(INTERNATIONAL PRIVATE CLIENTS DEPARTMEN
AE	ABNAAEAA	ABN AMRO BANK N.V. UNITED ARAB EMIRATES	DUBAI
AE	ABPPAEA1	ABRAAJ CAPITAL LIMITED	DUBAI
AE	ADCBAEAACMD	ABU DHABI COMMERCIAL BANK	ABU DHABI	(CASH MANAGEMENT DEPARTMENT)
AE	ADCBAEAAFIN	ABU DHABI COMMERCIAL BANK	ABU DHABI	(FINANCE DEPARTEMENT)
AE	ADCBAEAAREM	ABU DHABI COMMERCIAL BANK	ABU DHABI	(RBS)
...	...	...	...	...

Showing 15 of 112,887 records

Release Files

File	Records	Description
swift-bic-codes.db	112,887	SQLite database (all data)
swift-bic-codes-part1.sql	1-50,000	SQL dump (part 1)
swift-bic-codes-part2.sql	50,001-100,000	SQL dump (part 2)
swift-bic-codes-part3.sql	100,001-112,887	SQL dump (part 3)

SQL files are split into parts of 50,000 records each. Import all parts in order.

Usage

SQLite

sqlite3 swift-bic-codes.db "SELECT * FROM swift_codes WHERE country_code = 'US' LIMIT 10;"

Import SQL (MySQL)

mysql -u root -p your_database < swift-bic-codes-part1.sql

Import SQL (PostgreSQL)

psql -U postgres -d your_database -f swift-bic-codes-part1.sql

Use Cases

• International wire transfers — Look up SWIFT/BIC codes before sending money abroad
• Payment system integration — Validate bank codes in fintech and payment applications
• Banking directory — Build a searchable bank directory for any country
• Compliance & KYC — Verify financial institution identifiers
• Data enrichment — Enrich transaction data with bank names and locations

FAQ

What is a SWIFT/BIC code?

A SWIFT/BIC code is an 8-11 character identifier used to identify banks and financial institutions globally for international wire transfers. SWIFT stands for Society for Worldwide Interbank Financial Telecommunication.

How often is this data updated?

The database is updated monthly. Check the Releases page for the latest version.

Can I use this data commercially?

Yes. This data is released under the MIT License — free to use for any purpose, including commercial applications.

How do I look up a SWIFT code for a specific bank?

SELECT * FROM swift_codes WHERE bank LIKE '%KASIKORN%';

How do I get all banks in a specific country?

SELECT * FROM swift_codes WHERE country_code = 'TH' ORDER BY bank;

Countries (232)

Country	Code	Records	Details
Italy	IT	26,259	View
United Kingdom of Great Britain and Northern Ireland	GB	20,757	View
Germany	DE	8,518	View
United States of America	US	5,781	View
France	FR	4,924	View
India	IN	4,272	View
China	CN	2,652	View
Switzerland	CH	1,904	View
Taiwan, Province of China	TW	1,889	View
Netherlands, Kingdom of the	NL	1,714	View
Russian Federation	RU	1,646	View
Türkiye	TR	1,459	View
Hong Kong	HK	1,362	View
Egypt	EG	1,276	View
Austria	AT	1,191	View
Ireland	IE	1,087	View
Australia	AU	1,063	View
Luxembourg	LU	1,051	View
Bangladesh	BD	993	View
Spain	ES	933	View
Iran, Islamic Republic of	IR	902	View
Singapore	SG	880	View
Indonesia	ID	772	View
Norway	NO	731	View
Japan	JP	712	View
Viet Nam	VN	701	View
Belgium	BE	651	View
Canada	CA	613	View
Ecuador	EC	612	View
Denmark	DK	611	View
Finland	FI	602	View
Sweden	SE	523	View
South Africa	ZA	471	View
Pakistan	PK	468	View
Philippines	PH	456	View
United Arab Emirates	AE	438	View
Malaysia	MY	413	View
Brazil	BR	410	View
Poland	PL	398	View
Ukraine	UA	296	View
Thailand	TH	282	View
Korea, Republic of	KR	272	View
Romania	RO	263	View
Portugal	PT	253	View
Jersey	JE	246	View
Libya	LY	222	View
Greece	GR	221	View
New Zealand	NZ	209	View
Cyprus	CY	205	View
Colombia	CO	199	View
Dominican Republic	DO	198	View
Nigeria	NG	196	View
Cayman Islands	KY	194	View
Argentina	AR	184	View
Mexico	MX	177	View
Jordan	JO	168	View
Bahrain	BH	167	View
Kenya	KE	166	View
Hungary	HU	160	View
Lithuania	LT	150	View
Czechia	CZ	148	View
Kuwait	KW	145	View
Bulgaria	BG	132	View
Lebanon	LB	126	View
Panama	PA	123	View
Saudi Arabia	SA	123	View
Slovakia	SK	122	View
Algeria	DZ	119	View
Chile	CL	114	View
Belarus	BY	113	View
Malta	MT	106	View
Bahamas	BS	104	View
Morocco	MA	101	View
Ghana	GH	97	View
Tanzania, United Republic of	TZ	97	View
Venezuela, Bolivarian Republic of	VE	95	View
Iraq	IQ	94	View
Syrian Arab Republic	SY	85	View
Côte d'Ivoire	CI	84	View
Kazakhstan	KZ	82	View
Sri Lanka	LK	82	View
Qatar	QA	82	View
Sudan	SD	81	View
Guernsey	GG	80	View
Israel	IL	79	View
Serbia	RS	79	View
Tunisia	TN	79	View
Croatia	HR	78	View
Isle of Man	IM	78	View
Yemen	YE	69	View
Latvia	LV	68	View
Monaco	MC	68	View
Uruguay	UY	66	View
Georgia	GE	65	View
Jamaica	JM	65	View
Oman	OM	65	View
Uzbekistan	UZ	65	View
Slovenia	SI	64	View
Zimbabwe	ZW	64	View
Guatemala	GT	61	View
Mauritius	MU	60	View
Bolivia, Plurinational State of	BO	59	View
Bermuda	BM	58	View
Palestine, State of	PS	57	View
Honduras	HN	53	View
Zambia	ZM	53	View
Azerbaijan	AZ	52	View
San Marino	SM	52	View
Cambodia	KH	51	View
Uganda	UG	51	View
Curaçao	CW	48	View
North Macedonia	MK	48	View
Botswana	BW	46	View
Albania	AL	45	View
Cameroon	CM	45	View
Estonia	EE	44	View
Paraguay	PY	44	View
Liechtenstein	LI	42	View
Myanmar	MM	42	View
Angola	AO	41	View
Trinidad and Tobago	TT	40	View
Lao People's Democratic Republic	LA	39	View
Peru	PE	39	View
Costa Rica	CR	38	View
Iceland	IS	36	View
Nepal	NP	36	View
Senegal	SN	36	View
XK	XK	34	View
Bosnia and Herzegovina	BA	33	View
Macao	MO	33	View
Mozambique	MZ	33	View
Puerto Rico	PR	33	View
Congo, Democratic Republic of the	CD	31	View
Gibraltar	GI	31	View
Malawi	MW	31	View
Tajikistan	TJ	31	View
Barbados	BB	29	View
Moldova, Republic of	MD	28	View
Togo	TG	28	View
Virgin Islands (British)	VG	28	View
Ethiopia	ET	27	View
El Salvador	SV	27	View
Kyrgyzstan	KG	26	View
South Sudan	SS	25	View
Gabon	GA	24	View
Gambia	GM	24	View
Rwanda	RW	24	View
Namibia	NA	22	View
Mauritania	MR	21	View
Afghanistan	AF	20	View
Armenia	AM	20	View
Burkina Faso	BF	20	View
Mali	ML	20	View
Nicaragua	NI	20	View
Benin	BJ	19	View
Belize	BZ	19	View
Congo	CG	19	View
Guinea	GN	19	View
Niger	NE	19	View
Montenegro	ME	18	View
Mongolia	MN	18	View
Sierra Leone	SL	18	View
Vanuatu	VU	18	View
Antigua and Barbuda	AG	17	View
Burundi	BI	17	View
Saint Kitts and Nevis	KN	17	View
Liberia	LR	17	View
New Caledonia	NC	17	View
Comoros	KM	16	View
Madagascar	MG	16	View
Brunei Darussalam	BN	15	View
Guadeloupe	GP	15	View
Seychelles	SC	15	View
Cuba	CU	14	View
Haiti	HT	14	View
Saint Lucia	LC	14	View
Cabo Verde	CV	13	View
Djibouti	DJ	13	View
Dominica	DM	13	View
Suriname	SR	13	View
Korea, Democratic People's Republic of	KP	12	View
Martinique	MQ	12	View
Chad	TD	12	View
Turkmenistan	TM	12	View
Saint Vincent and the Grenadines	VC	12	View
Equatorial Guinea	GQ	11	View
French Polynesia	PF	11	View
Réunion	RE	11	View
Fiji	FJ	10	View
Andorra	AD	9	View
Aruba	AW	9	View
Guyana	GY	9	View
Maldives	MV	9	View
Bonaire, Sint Eustatius and Saba	BQ	8	View
Bhutan	BT	8	View
Sao Tome and Principe	ST	8	View
Sint Maarten (Dutch part)	SX	8	View
Samoa	WS	8	View
Grenada	GD	7	View
Papua New Guinea	PG	7	View
Somalia	SO	7	View
Eswatini	SZ	7	View
Cook Islands	CK	6	View
Faroe Islands	FO	6	View
French Guiana	GF	6	View
Guinea-Bissau	GW	6	View
Lesotho	LS	6	View
Solomon Islands	SB	6	View
Turks and Caicos Islands	TC	6	View
Tonga	TO	6	View
Virgin Islands (U.S.)	VI	6	View
Central African Republic	CF	5	View
Timor-Leste	TL	5	View
Anguilla	AI	4	View
Guam	GU	4	View
Marshall Islands	MH	4	View
Northern Mariana Islands	MP	4	View
Montserrat	MS	4	View
Wallis and Futuna	WF	4	View
Eritrea	ER	3	View
Holy See	VA	3	View
American Samoa	AS	2	View
Nauru	NR	2	View
Saint Pierre and Miquelon	PM	2	View
Falkland Islands (Malvinas)	FK	1	View
Micronesia, Federated States of	FM	1	View
Greenland	GL	1	View
Kiribati	KI	1	View
Palau	PW	1	View
Saint Helena, Ascension and Tristan da Cunha	SH	1	View
Tuvalu	TV	1	View
Mayotte	YT	1	View

Browse Online

Explore and download individual datasets at listbase.org.

License

MIT — Free to use for any purpose.

Source

SWIFT via public registries

---

Made with data from ListBase.org — Free Reference Tables & Lists