Pairing People and Companies from Separate Tables Using CSV Data

Matt · 2025-06-19 17:27:53.110864+00

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
·
·
no it doesn't work
Matt
·
·
https://app.clay.com/workspaces/531579/workbooks/wb_0sxpk0yRrAhznEqgj5W/tables/t_0sy43lqYQVqpVohyJJ8/views/gv_0sy43lrZwtEHDsir4J8
Adil Aijaz
·
·
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 Aijaz
·
·
the idea would be to have a joining key (say the linkedin url of the company) show up in both tables
Adil Aijaz
·
·
and then you use the "Lookup" function to bring fields from the company table to the people table
Matt
·
·
i have the linkedin company url in both tables but can't match it
Matt
·
·
actually it still doesnt work
Matt
·
·
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 Aijaz
Adil Aijaz
·
·
you wanna dedupe users or companies? Is this dataset imported by Clay or did you upload a cSV?
Matt
·
·
users
Matt
·
·
its a csv
Adil Aijaz
·
·
dedupe on their linkedin url
Adil Aijaz
·
·
if you don't have it, then their email
Adil Aijaz
·
·
if you don't have that, then a concatenation of their full name and company ULR

23 comments