How to Use Write to Table Without Creating Columns in Data Transfer

Benjamin L. · 2026-01-13T20:15:31.552Z

How does the write to table function work? is there a way I can send all table data but without creating the columns when I send the data

How to Use Write to Table Without Creating Columns in Data Transfer | Clay

11 comments

· Sorted by Oldest

Clay Support
APP
·
·
The "Write to Table" function has been updated - it's now called "Send table data" and works through Actions → Send table data. [1]
You can send data in two ways:
- Send row: Transfers specific columns as-is to another table
- Send row for each item in a list: Flattens lists so each item becomes its own row [2]
For your second question - yes! When you send data, it creates a source column in the destination table. You then manually map fields by clicking into the source cell, hovering over fields, and clicking "Add to column" or "Map to existing column". This gives you control over which columns get created rather than auto-creating them all.
The legacy "Write to Other Table" columns are still available when adding enrichments, but the new Send table data method is the recommended approach.
Clay Support
APP
·
·
Did that answer your question?
Benjamin L.
·
·
For me it's auto-creating them all. I send the table data and it's creating the columns in the new table automatically
Clay Support
APP
·
·
That's expected behavior! Send table data creates a source column in the destination table, but it doesn't automatically create individual columns for each field. [1]
You need to manually map the data from that source column. Click into the source cell, hover over each field you want, then click "Add to column" to create new columns or "Map to existing column" to use existing ones. [2] This gives you control over which columns actually get created rather than auto-generating everything.
Clay Support
APP
·
·
Was that helpful?
Benjamin L.
·
·
No I'm telling you it's creating the individual columns for each field automatically without me pressing "Add to column"
Clay Support
APP
·
·
I'm sorry for the confusion and understand this is frustrating. I'll connect you to a human agent who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

image.png(93 kB)
Benjamin L.
·
·
In the interim, my goal is to import 5-10 CSVs as tables which are company sources. I then want to combine these into one table, while mapping the columns to existing columns in my new table to then run enrichments on that data. What feature best serves this use case?
Daniela D.
·
·
Hey Benjamin! Apologies for the confusion. Happy to help. The "send table data" action auto-creates column for the first source created. If additional sources are created and they follow the same field path as the fields in the first source, they will automatically be mapped to the existing columns. If they don't follow the same field path, you'll need to manually map them to existing columns. Here's a quick guide on the "send table data" action:https://www.clay.com/university/guide/send-table-data For your use-case, if the CSVs have not been imported into Clay, it is best to import them into a new table using the "import CSV" option. When importing CSVs to an existing table, there'll be an option to map columns in your CSV to existing columns in the Clay table. Let me know if this helps!
Daniela D.
·
·
Hey Benjamin. Just saw your message in the other thread. We're looking into the issues raised in the video and will follow up with an update.

Clay Support
APP
·
·
The "Write to Table" function has been updated - it's now called "Send table data" and works through Actions → Send table data. [1]
You can send data in two ways:
- Send row: Transfers specific columns as-is to another table
- Send row for each item in a list: Flattens lists so each item becomes its own row [2]
For your second question - yes! When you send data, it creates a source column in the destination table. You then manually map fields by clicking into the source cell, hovering over fields, and clicking "Add to column" or "Map to existing column". This gives you control over which columns get created rather than auto-creating them all.
The legacy "Write to Other Table" columns are still available when adding enrichments, but the new Send table data method is the recommended approach.
Clay Support
APP
·
·
Did that answer your question?
Benjamin L.
·
·
For me it's auto-creating them all. I send the table data and it's creating the columns in the new table automatically
Clay Support
APP
·
·
That's expected behavior! Send table data creates a source column in the destination table, but it doesn't automatically create individual columns for each field. [1]
You need to manually map the data from that source column. Click into the source cell, hover over each field you want, then click "Add to column" to create new columns or "Map to existing column" to use existing ones. [2] This gives you control over which columns actually get created rather than auto-generating everything.
Clay Support
APP
·
·
Was that helpful?
Benjamin L.
·
·
No I'm telling you it's creating the individual columns for each field automatically without me pressing "Add to column"
Clay Support
APP
·
·
I'm sorry for the confusion and understand this is frustrating. I'll connect you to a human agent who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

image.png(93 kB)
Benjamin L.
·
·
In the interim, my goal is to import 5-10 CSVs as tables which are company sources. I then want to combine these into one table, while mapping the columns to existing columns in my new table to then run enrichments on that data. What feature best serves this use case?
Daniela D.
·
·
Hey Benjamin! Apologies for the confusion. Happy to help. The "send table data" action auto-creates column for the first source created. If additional sources are created and they follow the same field path as the fields in the first source, they will automatically be mapped to the existing columns. If they don't follow the same field path, you'll need to manually map them to existing columns. Here's a quick guide on the "send table data" action:https://www.clay.com/university/guide/send-table-data For your use-case, if the CSVs have not been imported into Clay, it is best to import them into a new table using the "import CSV" option. When importing CSVs to an existing table, there'll be an option to map columns in your CSV to existing columns in the Clay table. Let me know if this helps!
Daniela D.
·
·
Hey Benjamin. Just saw your message in the other thread. We're looking into the issues raised in the video and will follow up with an update.