Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Merging Manually Found Data into Find People Table | Clay

Merging Manually Found Data into Find People Table

·Nov 18, 2025 04:27 PM·

I have a find people table. what is the best way for me to merge in data that I have manually found that Clay missed?

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
You can add your manually found data to your existing table by importing a CSV file. Go to Actions → Import in your table, then click Import from CSV and select your file. [1]
You'll be able to map the columns from your CSV to match your existing Clay table columns, then click Add to table to merge the data in. [2]
If you need to combine data from different columns after importing, you can use the Merge Columns feature by clicking Add Column → Merge columns and creating a formula to combine the data.
Clay Support
APP
·
·
Did that answer your question?
Nathen H.
·
·
my find people table references a companies source table and I lose the first name last name from the find people source
Clay Support
APP
·
·
When your Find People table is linked to a companies table, the first and last names should still be available in your people table. If they're missing, you can use the Formulas feature to extract them from existing data.
Go to Add Column → Formulas and create formulas to extract first names (first word) and last names (second word) from any combined name fields you have.
You can also rerun the lookup column that connects to your companies table to refresh the data and ensure all linked information syncs properly. [1]
If the names aren't in any existing columns, you might need to merge in your manual data using Actions → Import → Import from CSV to add the missing first and last name information. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with merging or extracting data in your Find People table, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?