How bulk NPI lookup works

From spreadsheet rows to review-ready NPI matches.

Four steps turn messy provider and organization records into confidence-rated matches you can review before using them elsewhere.

  1. 1

    Upload your file

    Upload any CSV, including a claims roster, referral list, or CRM export. The first row should contain headers. Tables can hold up to 50,000 rows, and large files import in chunks.

    No template required. Files with inconsistent, real-world formatting are fine.

    Drop your CSV here

    First row is headers · large files import in chunks

    provider_roster.csv184 rows · ready
  2. 2

    Map your columns

    Choose the columns that hold names, addresses, phone numbers, and specialties. Any combination works, even an organization name with a state. Unmapped columns stay with the row as added context.

    Pick a type filter if you need one: Auto, Type 1 (individuals), or Type 2 (organizations). The filter is enforced inside the engine.

    • providerorganization_name
    • addr_1address
    • citycity
    • zippostal_code
    NPI type
    AutoType 1Type 2
  3. 3

    Run the investigation

    Each row starts with a registry search that expands nicknames and former names. Public web evidence handles information the registry cannot see. NPPES then verifies candidate NPIs before the system returns high-confidence results.

    Straightforward rows use a deterministic path and resolve immediately at full confidence.

    resolution sequence

    NPPES

    registry discovery

    Web

    supporting public evidence

    Pages

    evidence review

    Verify

    check digit + registry

    Candidates have to survive verification and the name-identity gate. Rows return a confidence-rated match or a clear no-match with reasoning.

  4. 4

    Review and export

    Results appear in the grid as they finish. Open any row to see the chosen NPI, matched registry record, confidence, candidates, and source URLs. Rerun any result you want to check again.

    One click exports your original columns with the results, ready for a claims system or data warehouse.

    Cascade Heart & Vascular

    Bend, OR · Type 2

    High

    Chosen NPI

    1663984528

    CASCADE HEART AND VASCULAR LLC · street match

    Also considered

    1934762505: different organization, same plaza

    1772049387: name gate failed

    2 sources citedExport CSV ›

Inside the engine

The name gate
comes first.

The matching rule that keeps wrong answers out is simple. The chosen NPI's registered name must represent your entity, meaning the same person or the same organization. Only then do location signals come into play, selecting among candidates and setting the confidence grade.

A same-name record at a different address can still be a match, since organizations may hold multiple NPIs across locations and people move. A different name at the same address is treated as a co-tenant until the evidence says otherwise.

Supporting evidence after the name gate passes

  • Street match→ high confidence
  • ZIP match
  • City + state match
  • State only
  • Phone matchdigit-for-digit

If your file carries no address signal at all, confidence is capped at medium.

The deliverable

One file, fully accounted for.

Every completed row exports with its verdict, reasoning, and sources, so the person who reviews the file six months from now knows why each NPI was chosen.

Run your first batch free

resolved_provider_roster.csv

  • Resolved NPI
  • Status
  • Confidence
  • Matched name
  • Matched address
  • Full reasoning
  • All candidate NPIs
  • Source URLs
  • Error detail (if any)
  • …joined to every original column

Watch your own file resolve.

20 free credits every month, results in minutes. Curious what it costs at scale?

Start for freeSee pricing ›