Frequently Asked Questions

467. Does the Sanctions List Search tool show historic information? For example, does it show names that have been removed from one of OFAC's sanctions lists?

OFAC's Sanctions List Search is updated frequently and always contains the latest versions of OFAC's sanctions lists. Like OFAC's other list-related publications, Sanctions List Search does not contain historical information. Names that have been removed from OFAC's Specially Designated Nationals (… Read more

253. When conducting a search using the ID field, does Sanctions List Search account for variations in non-alphanumeric characters?

Sanctions List Search’s ID field uses exact character matching to provide users with a result. In order to receive the broadest number of results, users should conduct ID field searches both with and without any non-alphanumeric …

79. Does OFAC provide its Specially Designated Nationals (SDN) List in a format that can be easily imported into a database?

Yes. OFAC's SDN list is available in XML, fixed-field and delimited formats that can be imported into a variety of software programs. …

80. Does OFAC provide its Specially Designated Nationals (SDN) List in a spreadsheet format?

OFAC publishes the SDN data in a comma separated values format (CSV). This format is recognized by Excel and other spreadsheet programs and can be imported into spreadsheet format by simply opening the file in your default spreadsheet …

422. How do I get a copy of one or more of OFAC’s other sanctions lists (in addition to the Specially Designated Nationals list)?

OFAC maintains other sanctions lists in addition to its Specially Designated Nationals (SDN) list . The names on these lists may also appear on the SDN list when such targets have a blocking provision associated with them. However, when the treatment of sanctions targets is unique and stops short… Read more

83. How are OFAC's delimited files structured?

All of OFAC's delimited files are described in OFAC's SDN data file specification guide and non-SDN data specification guide . In addition, OFAC published a tutorial on how to construct a basic relational database using OFAC’s delimited list …

81. What is the delimiter in OFAC's delimited files?

The delimiter varies based upon the file type. Files that end in .CSV have a comma delimiter. Files that end in .FF have a fixed width delimiter. …

88. I am a developer looking to design an automated process that will download OFAC's Specially Designated Nationals (SDN) list and other sanctions lists without human intervention. How can I do this given that changes to the sanctions lists can be sporadic?

OFAC cannot give specific advice on how to design an automated system for downloading its sanctions list data. Many institutions solve this problem by setting up a scheduled download of the SDN List and other sanctions lists . These firms conduct their own risk assessments and decide how often they… Read more

89. I am a database administrator at a financial institution and am responsible for keeping my company's sanctions list data current. Are OFAC's sanctions lists comprehensive or do I need to download some kind of supplement to the list every time there is an update?

The SDN list and OFAC's non-SDN Consolidated lists are comprehensive. Database administrators can overwrite any old data in their systems with the latest versions of the list's data files, thus ensuring that their database is …

90. Do you offer a Specially Designated Nationals (SDN) changes file or "delta file" in a data format? Do you offer delta files for OFAC's other sanctions lists?

Yes, OFAC offers a delta file as part of its Sanctions List Service (SLS) . While this delta file format is used by OFAC to update its sanctions lists on SLS, members of the public may use this file as well. OFAC also records changes to the SDN list and other sanctions lists in human-readable… Read more

Frequently Asked Questions

Office of Terrorism and Financial Intelligence