Spreadsheets & data · ONLINE TOOL

Audit relationships across data files

Audit multiple CSV/Excel files for likely keys, cardinalities, orphan rows, duplicates, join risk, projected row counts and SQL templates without raw values.

Local processingWorkToolset Pro

USE CASES

When to use Audit relationships across data files?

Audit multiple tables before consolidation: identify likely keys, measure cardinalities, orphan rows and duplicates, then simulate join volume and risk without exporting key values.

Understand a received file set before consolidation
Detect a many-to-many relationship that would explode a JOIN
Measure orphan rows before reconciliation
Generate a JOIN SQL template to adapt

CONCRETE EXAMPLE

Five business exports

BEFORE

Customers, orders, payments, branches and products with no documentation

→

AFTER

Likely keys + 1→N/N→1 relationships + orphans + expansion factor + JOIN SQL + PDF report

PRIVACY

Your data stays in the browser

Processed content is not uploaded to WorkToolset. Required libraries may be loaded by the site, but the file stays in the browser.

GOOD TO KNOW

Limitations to know

A statistical match does not prove a business relationship: every key requires human validation.
Projected join volumes are estimates calculated on the analyzed sample.
PRO analysis samples up to 25,000 rows per table and 500,000 rows total; reports contain no raw key values.

HOW IT WORKS

A straightforward workflow.

1Prepare the required input and choose useful options.
2Review previews, warnings and limitations before export.
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.