Multi-Field Record Linker

Compare records using weighted text, number and date rules, then accept or reject individual candidate links.

On-device No sign-up Free to use

Review record links controls

Showing an example. Edit to see your own.

?

Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

Drop your CSV file here

or choose one from your device

One file · CSV and TSV only

    ?

    Paste UTF-8 CSV with headers, or choose a file below. Up to 2 MiB.

    Drop your CSV file here

    or choose one from your device

    One file · CSV and TSV only

      ?

      2 to 8 rules: text uses normalized character-bigram Dice similarity; exact compares normalized strings; number/date scores fall linearly to zero at the tolerance. Dates use tolerance days.

      ?

      ?

      Fill accept or reject in the downloaded review template, then paste it here. Keep complete candidate IDs. Blank decisions remain proposed; accepted links are one-to-one.

      Processed in your browser. Your inputs stay on this device.

      Result

      Showing an example.

      The exact name match and a one-year age difference produce a weighted similarity of 0.9333.

      Alex Smith, age 30 versus Alex Smith, age 31 scores 0.9333 with name weight 2 and age weight 1, tolerance 5. Name contributes 1.000 and age 0.800; the pair remains proposed.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/multi-field-record-linker · 20 November 2026

      Was this helpful?

      How to use Multi-Field Record Linker

      1. Provide two CSV tables with distinct id values and the fields to compare, using pasted text or their files.
      2. Declare two to eight weighted rules and a minimum similarity. Review which fields use text, exact, number or date comparison and set tolerances where required.
      3. Run the comparison and inspect each candidate's field scores. The combined score is rule similarity, not a probability that two people or records are identical.
      4. Download record-review-template.csv, enter accept or reject beside complete candidate IDs, then paste it into Reviewed decisions CSV and rerun with unchanged data and settings.
      5. Download the reviewed pair report and unlinked-records.json. Accepted links are one-to-one; source records are never merged or deleted.

      Example: Multi-Field Record Linker

      The exact name match and a one-year age difference produce a weighted similarity of 0.9333.

      You add
      First records: id,name,age A1,Alex Smith,30 Second records: id,name,age B1,Alex Smith,31 Matching rules JSON: [{"field":"name","type":"text","weight":"2"},{"field":"age","type":"number","weight":"1","tolerance":"5"}] Minimum weighted similarity: 0.7
      You get
      Alex Smith, age 30 versus Alex Smith, age 31 scores 0.9333 with name weight 2 and age weight 1, tolerance 5. Name contributes 1.000 and age 0.800; the pair remains proposed.

      Supported inputs and limits

      • Up to 150 rows per side, 80 CSV columns and 2 MiB per input; at most 3,000 candidate pairs.
      • Text similarity uses NFKC normalization, outer trim, lowercase and character-bigram Dice scores, with 300 characters per compared text field.
      • Numeric/date similarities fall linearly to zero at the positive entered tolerance.
      • Blank fields score zero.
      • Weights are positive.
      More details

      Accept only one counterpart per record.

      Scores do not estimate identity probability and no source rows are merged.

      JSON numeric literals are limited to 128 characters and must retain their decimal value through browser Number conversion; integers outside the safe integer range and unsupported precision are refused.

      Where your input is processed

      This tool does not upload your inputs. See the limits for anything saved on your device.

      Questions about Multi-Field Record Linker

      How does this differ from matching a single key?

      Every pair is scored across at least two declared fields. Each field has its own method and weight, so a near name can be assessed alongside a date or a numeric tolerance.

      What does a score of 0.9333 mean?

      It is the weighted average of the rule similarities, rounded for display. It does not mean there is a 93.33 percent chance that the records identify the same person.

      Can I accept two counterparts for one record?

      This review uses one-to-one accepted links. An overlapping approval is refused so that an ambiguous match cannot silently resolve several source records.

      Page updated · Project managed by Tony Hines · Report a problem with Multi-Field Record Linker