LogoHow To CSV

Natural Join

Upload a dataset to begin

Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv

Free users: Up to 1MB per file.
Sign in to upload files up to 10MB.
Upgrade for even larger files.

AboutNatural Join

Perform SQL-style joins or VLOOKUP between two files.Category: Transformation & Logic
Looking up customer names into an orders file using a shared customer IDLeft-joining a product catalog onto a sales export by exact SKU codeCombining two exported reports that share a precise transaction ID column
The Natural Join tool is compatible with:.If a first pass here leaves unmatched rows because the key spellings differ slightly, rerun those leftovers through Fuzzy Join instead; Smart Merge can then reconcile any remaining overlapping records.
Pick a key column in each file and a join type (inner, left, right, or outer), and the tool matches rows where the key values are byte-for-byte identical, exactly like a SQL JOIN or an Excel VLOOKUP/INDEX-MATCH. Because matching is exact, it is fast and deterministic even on large files, but it requires the key values to already be clean and consistently formatted on both sides.

Frequently Asked Questions:

What's the difference between this and Fuzzy Join?

Natural Join expects exact key matches (SQL-style join or VLOOKUP-style lookup), while Fuzzy Join tolerates spelling differences.

What join types are supported?

SQL-style joins and VLOOKUP-style lookups between two files on a matching key column.


The right choice for developers and analysts joining on IDs or codes that are guaranteed to match exactly.