So I exported a full list of 40K rows with companies etc, and then filtered and added new columns outside Clay. Can I easily import the new columns to Clay to the respective row? How do I go about?
Yes, you can import your modified CSV back into Clay to add the new columns to existing rows: 1. In your table, click Actions → Import → Import from CSV 2. Upload your modified CSV file 3. Select Add to existing table and choose your current table 4. Map the columns - this step lets you align your CSV columns with Clay table fields, including your new columns 5. Click Add to table During the mapping step, Clay will automatically detect all columns from your CSV, allowing you to add the new columns while matching existing data to the correct rows.
To import new columns from your modified CSV back into Clay: 1. Click Actions → Import → Import from CSV in your existing table 2. Upload your modified CSV file 3. Select "Add to existing table" and choose your current table 4. Map the columns - Clay will automatically detect all columns from your CSV, including the new ones you added 5. Click "Add to table" to complete the import During the mapping step, you can align your CSV columns with Clay table fields and add the new columns while matching existing data to the correct rows.
When importing a CSV to add columns to existing rows, Clay needs a way to match your CSV rows to existing table rows. If it's trying to add 40K new rows instead of updating existing ones, the issue is likely in the column mapping step. During the mapping process, you need to map at least one column that contains identical data between your CSV and existing table (like company names, emails, or IDs) so Clay can match and update the correct rows rather than creating duplicates. Make sure you're selecting "Add to existing table" and properly mapping your identifier columns during the import process.
Most titles (row 1) is identical to what’s in the table
During the column mapping step, you need to ensure Clay can match your CSV rows to existing table rows. Since your titles (row 1) are identical, map at least one column that contains identical data between your CSV and existing table - like company names, emails, or unique identifiers. When you select "Add to existing table" and reach the mapping step, assign columns from your CSV to the correct Clay table fields, ensuring you map your identifier columns properly so Clay can update existing rows rather than creating duplicates. This matching process prevents Clay from adding 40K new rows and instead updates your existing rows with the new columns you added.
How do I map? I don’t see that option
After selecting "Add to existing table" and uploading your CSV, you'll reach Step 3: "Match CSV Columns to Clay Table Fields." In this mapping step, assign columns from your CSV to the correct Clay table fields - this is where you ensure at least one column contains identical data (like company names or IDs) between your CSV and existing table so Clay can match rows instead of creating duplicates. The mapping interface lets you align your CSV columns with Clay table fields, ensuring proper row matching for updates rather than additions.
Here is the Google Sheets I’m trying to add as csv with the new columns K and L: https://docs.google.com/spreadsheets/d/1a4wgriUHTwYRiyJcYTm_G3OG1boGvER4vX3Ywxpdvjc/edit?usp=sharing
Hi Daniel, thank you for reaching out. The easiest way to carry this out would be downloading this table into a csv and then re-uploading it into Clay. Could you let me know if that works for you?
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
