Spreadsheets & data · ONLINE TOOL

Smart Semantic Matcher

Match two reference datasets by meaning, codes and context with business rules, ambiguity, human validation and exception reports.

Local + external resources✦ Local AIWorkToolset Pro
USE CASES

When to use Smart Semantic Matcher?

Match two reference datasets by combining label meaning, reference/code and context, with exclusion/blocking rules, explicit ambiguity and human validation.

  • Map department names across systems while considering codes and business units
  • Match multilingual skills or categories without hiding ambiguous cases
  • Prepare a reference-data migration with a mapping plan and exception report
  • Review an existing mapping before importing it into a new system
CONCRETE EXAMPLE

Two department taxonomies

Sample file
BEFORE
A: code HR01 · Human Resources Directorate · Administration
B: code HR-1 · HR Directorate · Administration
→
AFTER
Combined score 94% · semantic 96% · reference 88% · context 100% · Auto-match; close cases remain in the Review queue
PRIVACY

The file stays local while the engine can download resources

User content is not uploaded to WorkToolset for processing. A library, WebAssembly engine or AI model may be downloaded on first use depending on the tool.

GOOD TO KNOW

Limitations to know

  • Semantic similarity does not prove business equivalence between reference datasets.
  • Strict rules can block a match despite semantic proximity and must reflect real business rules.
  • Human validation remains essential for ambiguous or high-impact migrations.
  • Datasets are capped at 200 rows per side to keep browser processing interactive.
HOW IT WORKS

A straightforward workflow.

  1. 1Prepare the required input and choose useful options.
  2. 2Review previews, warnings and limitations before export.
  3. 3Download a new copy or report: the original stays unchanged.
PRIVACY

Frequently asked questions

Are my files uploaded to WorkToolset?

No. This tool runs locally in your browser.

Is my original file modified?

No. WorkToolset creates a new copy or export.

Do I need an account?

This tool is part of WorkToolset advanced features.

or with email
WORKTOOLSET PRO

When work needs verification, explanation or evidence, Pro takes over.

AUDITAudit & verificationScores · priorities · recommendations
≈Reconciliation & local AIAmbiguity · exceptions · sources
SAFEPrivacy & QAPreflight · accessibility · sharing
PDFEvidence & reportsSHA-256 · manifest · CSV · JSON · PDF
Scale afterwards, when neededAI Workbench with local content analysis, universal production queue, specialized batch processing, recipes, workflows, Studio sessions and projects remain included in Pro.
100 presets · 50 projects · 20 templates · 500 favorites

Payments, taxes and invoices are managed by Paddle. Your documents are never part of payment data.

⌕Esc
Search by name, task, or format. Simple typos are tolerated; Ctrl+K also finds Studios, workflows, guides, and business solutions.