Sanctions List CSV: Upload & Screen Your Data Against Official Lists

Accessing official sanctions list data in CSV format is straightforward, with each authority providing its lists for free. However, processing these raw files for screening can be complex and time-consuming. This page guides you to the official sources and introduces an alternative that simplifies the entire screening process, allowing you to upload your customer names and receive a match report quickly.

Where to Find Official Sanctions List CSV and XML Files

Each major sanctions authority publishes its official lists in machine-readable formats like CSV or XML, free of charge. You can obtain the OFAC SDN list and the US Consolidated Screening List directly from the US Treasury's Office of Foreign Assets Control. The European Commission provides the EU Consolidated Sanctions List. For the UK Sanctions List, refer to the UK's Foreign, Commonwealth & Development Office (FCDO). The Office of Financial Sanctions Implementation (OFSI) also publishes a separate Consolidated List of Financial Sanctions Targets.

The UN Security Council offers its Consolidated List on its official website. France's Direction générale du Trésor publishes its registre national des gels. Poland's national sanctions list is provided by the MSWiA. The Swiss SECO consolidated list is available from the State Secretariat for Economic Affairs. It is important to download these files from the authorities' own websites to verify authenticity and obtain recent data. sanctionlistcheck.com does not host or redistribute these raw files; we focus on providing a screening service based on these official lists.

While these official sources are readily available, note that each authority uses different data formats and field structures. These lists are also updated daily, requiring consistent effort to download and integrate the latest versions into your screening process. Managing these varied formats and frequent updates can present a significant operational challenge for businesses aiming to conduct thorough and current sanctions checks.

Challenges of Manual Sanctions List CSV Processing

Manually processing raw sanctions list CSVs involves more than just downloading files. You must develop robust systems to parse different data structures from each authority and merge them into a usable format. A critical challenge is accurate name matching. Simple exact text matching will miss potential matches due to common issues like aliases, variations in name order, and transliteration differences across languages. Implementing fuzzy matching logic, such as Jaro-Winkler plus token-set algorithms, is essential to catch these nuanced variations.

Developing and maintaining a system capable of handling these complexities requires significant technical expertise and ongoing resources. You need to verify your matching algorithms correctly identify potential connections while minimizing false positives. Furthermore, the daily updates to the lists mean your processing system must be constantly refreshed and validated to avoid screening against outdated information, adding another layer of complexity to self-managed screening.

An Easier Alternative: Upload Your Names for Automated Screening

Instead of managing complex data parsing and matching systems, sanctionlistcheck.com offers a streamlined alternative. You can upload your customer or supplier names in a CSV or XLSX file directly to our platform. Our system automatically detects the name column, allowing you to confirm it easily. We then process your list against eight key official sanctions lists: OFAC SDN, the US Consolidated Screening List (US CSL), the EU Consolidated Sanctions List, the UK Sanctions List, the UN Security Council Consolidated List, France's registre national des gels (the national designations published by the Direction générale du Trésor), Poland's lista sankcyjna MSWiA, and the Swiss SECO consolidated list.

Stored data is placed in Cloudflare's Eastern Europe region with a location hint of EEUR; every request passes through Cloudflare's global edge network, which can be outside the EU; name matching normally runs on a matching server in Helsinki, Finland, hosted by Hetzner, but if that server is not available or returns an error, or if we switch it off, the matching runs in Cloudflare's network instead, which can be outside the EU; uploaded files and generated reports are deleted no later than 24 hours after upload; and customer data is never used to train AI models.

Once your check is complete, you receive a detailed report via email in PDF and CSV formats (JSON is also available). Each line in the report provides your input name, the match result, the specific list matched, a match score, and a per-list timestamp/version for clarity. Even if no matches are found, the report confirms "no match found on [list] as of [timestamp]" for every list checked. Name matching is deterministic fuzzy matching, using methods such as Jaro-Winkler and token-set, where the same input and list version give the same result, without AI judgement or LLMs.

Staying Current with Daily Sanctions List Updates

The global sanctions landscape is highly dynamic, with lists frequently updated by various authorities. Relying on outdated sanctions data exposes your organization to unnecessary risks. sanctionlistcheck.com addresses this challenge by refreshing all eight official sanctions lists daily. This means that every check you perform, whether a free single-name check or a paid bulk upload, is conducted against information available from OFAC SDN, the US Consolidated Screening List (US CSL), the EU Consolidated Sanctions List, the UK Sanctions List, the UN Security Council Consolidated List, France's registre national des gels, Poland's national sanctions list (MSWiA), and the Swiss SECO consolidated list.

Our reports provide a specific timestamp and version for each list checked. This detail confirms the recency of the data used for your screening and supports your record-keeping for due diligence. With sanctionlistcheck.com, you can maintain current screening practices without the burden of constant manual downloads, parsing, and integration of new sanctions list versions.

Pricing

Our flexible pricing allows you to choose a plan that fits your screening volume, with all fees handled as a one-time charge.