How to Copy Rows from One Table to Another in Excel

Ralph H. · 2025-03-17T21:48:25.160422+00:00

Hey everyone, I'm trying to copy from one master table of companies, only 5 rows to another table, how can I do this?

To copy 5 rows from one master table of companies to another table in Clay, you can use our "write to table" feature. Here's how: 1. In your source table, click on "Actions" > "Add Enrichment". 2. Search for and select "Write to Table". 3. Choose your destination table. 4. Map the columns you want to copy from the source to the destination table. 5. To limit it to 5 rows, use the "Only run if" condition. Set it to run only for the first 5 rows (e.g., "Row Number is less than or equal to 5"). This will transfer the data for the first 5 rows from your master table to the new table.

Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University

2 comments