Free template

The company → LEI crosswalk, in your spreadsheet

Map SEC companies — by name, ticker, or CIK — to their GLEIF Legal Entity Identifier, without writing a lookup by hand. Every match is tiered and scored, so you can see which edges a regulator asserts and which are just surfaced. Grab the template, or pull it live into Excel or Google Sheets.

Excel template An .xlsx with the sample crosswalk on one tab and a “refresh with live data” recipe on the next.Sample CSV The raw crosswalk shape — company → ticker → CIK → LEI, tiered and scored. Open it anywhere; import it into any sheet.

Open data (CC0 / U.S. public domain). No signup, no tracking cookies. Built from SEC EDGAR + GLEIF — the same edges you can query on the crosswalk dataset.

What's in it

One row per asserted identity, keyed by a typed identifier. Every edge carries its tier and a confidence score — so a fuzzy name match never masquerades as fact.

authoritativeA regulator asserts the link (SEC registration / Form N-CEN). Exact by construction.
confirmedExact normalised-name match between EDGAR and GLEIF (~95% precision).
candidateA name-only fuzzy match — surfaced for you to judge, not asserted.

Columns: company_name, ticker, key_type, key, lei, legal_name, jurisdiction, method, tier, confidence, as_of.

Keep it fresh

The download is a point-in-time snapshot — and a static crosswalk rots as companies register, rename, and merge. Wire your sheet to the maintained feed and it updates itself.

Google Sheets — one cell:

=IMPORTDATA("https://openlake.meridian.online/samples/crosswalk-sample.csv")

Excel — Power Query (Data › Get Data › From Web):

let
    Source = Csv.Document(
        Web.Contents("https://openlake.meridian.online/samples/crosswalk-sample.csv"),
        [Delimiter=",", Encoding=65001]
    ),
    Promoted = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    Promoted

Heads up: the live URL above points at the static sample for now. The always-current, maintained crosswalk feed — the paid tier — is in the works. Tell us you want it and we'll email you the moment it's live.

The datasets are free to browse, query, and take anywhere. What you pay for is the maintained join — resolved, scored, and always current. See the crosswalk plans →