Pairing People and Companies from Separate Tables Using CSV Data

Matt S. · 2025-06-19T17:27:48.012Z

I have a list of companies in another table. i have list of people in another table. can i populate my fields in the people table (extracted from a csv) and pair with the company table and populate my fields?

Pairing People and Companies from Separate Tables Using CSV Data | Clay

Channeled
APP
·
·
Import your CSV to the people table: 1. In your people table, click Actions → Import 2. Select Import from CSV and upload your file 3. Map CSV columns to Clay table fields 4. Click Add to table Link with company data: Clay automatically links Find Companies and Find People tables, allowing you to extract company attributes directly into your people table. You can pull enriched company data (tech stack, revenue, location, etc.) into your people table using lookup columns. When you add new company data later, simply rerun the lookup column in your people table to sync updated information.
Sources: Sources | Documentation | Clay University Upload CSV to your table - Clay University How to import your CSV into Clay | Documentation | Clay University Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University
Matt S.
·
·
no it doesn't work
Matt S.
·
·
https://app.clay.com/workspaces/531579/workbooks/wb_0sxpk0yRrAhznEqgj5W/tables/t_0sy43lqYQVqpVohyJJ8/views/gv_0sy43lrZwtEHDsir4J8
Adil A.
·
·
if you want fields from the column table to show up in the people table, you will have to use "Clay Lookup Single Row in Other Table"
Adil A.
·
·
the idea would be to have a joining key (say the linkedin url of the company) show up in both tables
Adil A.
·
·
and then you use the "Lookup" function to bring fields from the company table to the people table
Matt S.
·
·
i have the linkedin company url in both tables but can't match it
Matt S.
·
·
actually it still doesnt work
Matt S.
·
·
is there a smart way to dedup accounts? I am tryingto dedup from linkedin user ids from the linkedin profile urls (for people) but i am not sure if it's accurate. Adil A.
Adil A.
·
·
you wanna dedupe users or companies? Is this dataset imported by Clay or did you upload a cSV?
Matt S.
·
·
users
Matt S.
·
·
its a csv
Adil A.
·
·
dedupe on their linkedin url
Adil A.
·
·
if you don't have it, then their email
Adil A.
·
·
if you don't have that, then a concatenation of their full name and company ULR

23 comments