How to Add CSV Data Without Duplicating Table Columns

Kshitij P. · 2025-08-18 10:57:38.599225+00

Why duplicating a table - I see this, this is something which creates new columns, which I dont want. I do have the columns ready, Just want to add the CSV data to duplicate my table. How can this be fixed

How to Add CSV Data Without Duplicating Table Columns | Clay

5 comments

· Sorted by Oldest

Clay
APP
·
·
When you duplicate a table, only the header structure is copied - the data isn't transferred automatically. To add your CSV data to the existing table with your ready columns: 1. In your table, click Actions → Import 2. Choose Import from CSV 3. Upload your CSV file 4. Select Add to existing table and pick your duplicated table 5. Map the CSV columns to align with your existing Clay table columns 6. Select Add to table This will add only the data from your CSV without creating new columns.
Sources: Upload CSV to your table - Clay University Upload CSV to your table - Clay University
Kshitij P.
·
·
Some of the columns dont show up while mapping ( Webhooks, AI prompts, Write to Table and Lookups)
Clay
APP
·
·
When importing CSV data to an existing table, certain column types like Webhooks, AI prompts, write to table, and Lookups don't appear in the mapping interface because these are Clay-specific enrichment and automation columns that can't be populated directly from CSV data. During CSV import mapping, you can only map to basic data columns (Text, Number, Date, etc.) that can accept raw data values. The advanced Clay features you mentioned need to be configured separately after your CSV data is imported. Import your CSV data to the available mappable columns first, then set up your enrichment columns afterward.
Sources: Upload CSV to your table - Clay University Import CSV [Clay 101] - Clay University Import CSV [Clay 101] - Clay University
Kshitij P.
·
·
How can I populate the data of webhook in a duplicate table ?
Clay
APP
·
·
To populate webhook data in your duplicate table, use the "write to table" integration: 1. Click "Add Enrichment" in the top right corner 2. Search for "Write to Table" and select it 3. Map your existing webhook data fields to the corresponding columns in your duplicate table This transfers the webhook data from your original table to the duplicate table structure.