# Find how your tables connect

> Drop the tables together. Keys, links and rows that point nowhere appear as you drop them.

Drop several CSV or Excel tables to find keys, foreign keys and orphan rows, then get a diagram, SQL and Mermaid. Runs in your browser. Free.

- Tool: [Find table relationships](https://fixmint.cc/find-table-relationships)
- Category: [Spreadsheets & data](https://fixmint.cc/spreadsheets)
- Fixes: How do these tables connect?
- Runs in the browser: files and text stay on the device, no sign-up, free.

## How to find how your tables connect

1. Drop two or more CSV or Excel files, or add a pasted table.
2. Read the links, the keys and the orphan rows, then look at the diagram.
3. Copy the SQL sketch or the Mermaid diagram text.

## Questions

### What is a link here?

A column in one table whose values are found in a key column of another table. A key is a column with a value on every row and no repeats. The tool reports a link when at least 90% of the distinct values are found, and marks it Likely when the names agree, such as customer_id and customers.id.

### What are orphan rows?

Rows whose link value is filled in but is not in the key column of the other table, for example an order for a customer ID that does not exist. Fix or remove them before you add the foreign key.

### Is my data uploaded?

No. The files are read by your browser and the analysis runs on your device. Nothing is sent anywhere.

## Related tools

- [Join spreadsheets](https://fixmint.cc/join-spreadsheets): VLOOKUP keeps breaking
- [CSV column profiler](https://fixmint.cc/csv-column-profiler): Need stats for every column
- [Data type checker](https://fixmint.cc/data-type-checker): Column has mixed formats
- [CSV cleaner](https://fixmint.cc/csv-cleaner): Messy CSV with blanks and copies