The GTM Provider Directory
Enrichment

I have a column that contains a comma-separated list of URLs (e.g. https://a.com,https://b.com).

April 2026

Quick Answer

Use Extract Data From Values to convert your comma-separated URLs into a true list: 1. Add a new column and select Extract Data From Values 2. Reference your URL column using the Forward Slash (/) command 3. Apply this custom extraction Regex: `[^,"]+` This regex will split the values into a proper list format and automatically trim whitespace. [[clay.com](https://www.clay.com/university/guide/write-to-table-integration-overview?8913605e_page=2]) [[documentation](https://university.clay.com/docs/write-to-table-integration-overview]) Once you have the list, you can run enrichments on each URL i

○
Up to date
1 months ago

1 Answer

Use Extract Data From Values to convert your comma-separated URLs into a true list: 1. Add a new column and select Extract Data From Values 2. Reference your URL column using the Forward Slash (/) command 3. Apply this custom extraction Regex: [^,"]+ This regex will split the values into a proper list format and automatically trim whitespace. [clay.com [documentation Once you have the list, you can run enrichments on each URL individually. The Extract Data From Values method is the Clay-native approach specifically designed for converting comma-separated data into lists, unlike formulas which tend to return strings. Before trying other approaches, I'd recommend using Sculptor (our built-in AI tool in the top-right corner) to help set this up quickly - it's free and can generate the exact workflow you need.

GTM StackCommunity Insight