Split Comma-Delimited Text into Multiple Rows in Excel | Clay

Split Comma-Delimited Text into Multiple Rows in Excel

How do I turn a comma-delimited text within a cell into multiple rows within the same column? I have multiple linkedin urls from a search result that I would like separated into rows.

13 comments

Channeled
APP
·
·
To split comma-delimited LinkedIn URLs within a cell into multiple rows in the same column, you can use our "write to table" feature. Here's how: 1. Use the "Extract Data From Values" option to process the CSV data. 2. Add the correct column using the "/" (Forward Slash) command. 3. Apply a custom extraction Regex: [^,"]+"?[^,"]+ This will split the values into a list. Once complete, you can send the newly created list to the desired column or table using the "write to table" feature. If you need further assistance, please don't hesitate to ask for more details or request human support.
Source: Write to Other Table | Documentation | Clay University
Channeled
APP
·
·
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Joel M.
·
·
can I use a formula to split a concatenated list from one cell to multiple rows?
Channeled
APP
·
·
Yes, you can use a formula to split a concatenated list from one cell into multiple rows. Here's how: 1. Use the "Extract Data From Values" feature to process your concatenated list. 2. Add a new column using the "/" (Forward Slash) command. 3. Apply a custom extraction Regex: [^,"]+"?[^,"]+ This will split the values into a list. 4. Once you have the list, use our "write to table" feature to map each item individually to rows in a destination table. Alternatively, you can use the AI formula generator to create a custom formula for your specific needs. If you need more detailed guidance, please ask and I'll be happy to provide step-by-step instructions.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Formula generator | Documentation | Clay University
Channeled
APP
·
·
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Joel M.
·
·
https://app.clay.com/workspaces/9621/workbooks/wb_otUSpKSMizr7/tables/t_sXF9eWra8aNF/views/gv_idDPC72YtaSm
Joel M.
·
·
I am trying to use a formula to split the concatenated linkedin urls into rows that correspond with their respective company name. For example, row 1 has 5 linkedin urls that match the google search criteria. I want those moved to rows in a new table along with the company they work for so I can enrich the list further.
LuisArturo
·
·
Hey there Joel thanks for reaching out, in this case I would recommend using a Write to table integration here in order to get these all into their own rows. Herre is a loom showing you how we could do this. https://www.loom.com/share/d316dbd8a08d417abf2d696e7c2caf90?sid=aaabe159-4ac6-42a0-a0a0-d7c60d0f1b89
Joel M.
·
·
Thank you!
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Joel M.!