Back to tools

Data Studio

Join Spreadsheets and Compare Table Fields for Free

Join two spreadsheets free online by key, compare changed fields and choose left, inner, right or full joins. Review repeated keys, expanded rows and unmatched records.

Start using
Local & online features

YOUR WORKSPACE

Multi-table Joins and Comparisons

Choose your input to begin
  1. Add input
  2. Choose options
  3. Process
  4. Use your result
Loading tool…
Full instructions and common questions

Multi-table Joins and Comparisons

Join two spreadsheets free online by key, compare changed fields and choose left, inner, right or full joins. Review repeated keys, expanded rows and unmatched records.

How to use

  1. Import at least two CSV, TSV, JSON or XLSX tables, or load the comparison sample. Select two different original tables as left and right.
  2. Choose a shared key. Difference comparison requires unique, nonblank keys on both sides. Review duplicates before cleaning, exporting and reimporting.
  3. Compare differences or choose a left, inner, right or full join. Joins expand duplicate-key matches; blank keys never match each other.
  4. Check source tables, changed fields and row counts, then download CSV, Excel or JSON. Adopting a difference list makes that list the next working input.

Try an example

The comparison sample has three original A rows and four B rows. Compare by ID to find two items: DEMO-002 changes from 200 to 250, and DEMO-004 appears only on the right.

Limits and privacy

Imports allow up to 50 files, 50 MB, 100,000 rows, 300 fields and 2 million cells; result limits also apply. One-to-many joins can expand results considerably. Comparisons and joins always use the selected original tables, not automatically adopted working data. Field comparisons do not infer semantic equivalence.

Common questions

Does comparison automatically use my cleaned result?

No. It uses retained original tables. Download cleaned output and reimport it when comparing cleaned versions.

Why are duplicate keys rejected in difference comparison?

They create multiple possible counterparts for a record. Review the business rule or use one-to-many joining to inspect relationships.

Explore tools

Free use and requirements

Use the local functions for free without a KitNelo account. Optional Gemini generation sends the supplied text to Google and requires a configured server API key; provider fees and quotas can apply.

Repeated keys can expand row counts. Check match cardinality and unmatched rows before accepting the joined table.

Read KitNelo data and privacy details

Free online functions: steps and checks

Join Two Spreadsheets by Key for Free

Load the two tables and select the corresponding key columns to match their records. Review duplicates and unmatched keys before accepting the output, since repeated values can create multiple matches and expand the number of joined rows.

Compare CSV Table Fields for Free

Match two CSV tables by their selected keys and inspect differences in the fields you want to compare. Check that key formatting and column mappings agree so whitespace, identifiers or mismatched fields do not create misleading changes.

Perform Left, Inner, Right or Full Joins for Free

Choose a join type to control which matched and unmatched records appear in the result. Review the output row count and missing fields, paying particular attention to one-to-many matches before exporting a combined table.

Related tools for your next step

Browse this tool category

Practical guides

Simplified Chinese