How to Split Multiple LinkedIn URLs into Separate Columns

Vlada M. · 2025-10-23 20:42:07.42367+00

Hey team, I need help! I have a column with multiple LinkedIn URLs separated by commas, like this: https://www.linkedin.com/in/giorgiomolinaro, https://www.linkedin.com/in/matteo-moretto-4210b21a4, https://www.linkedin.com/in/roberta-b-3159863a I want to split these into separate columns — one LinkedIn URL per column (e.g. LinkedIn 1, LinkedIn 2, LinkedIn 3). How can I do that? I tried using the formula generator, but I couldn't get the output I wanted... Made different tweaks and still hitting the wall. Any advice? TY!!

How to Split Multiple LinkedIn URLs into Separate Columns | Clay

5 comments

· Sorted by Oldest

Clay Support
APP
·
·
The formula generator creates a single output column, not multiple separate columns. To split your comma-separated LinkedIn URLs into individual columns (LinkedIn 1, LinkedIn 2, LinkedIn 3), here's what to do:
Method 1: Extract individual URLs using formulas
1.
Create separate formula columns for each URL position
2.
Use formulas like: • LinkedIn 1: Extract the first URL from the list • LinkedIn 2: Extract the second URL from the list • LinkedIn 3: Extract the third URL from the list
Method 2: Use "Add as column" feature
1.
Click on a cell containing your comma-separated URLs
2.
In the Cell details panel, hover over the individual URL values
3.
Click "Add as column" to create a new column for each URL [1]
Alternatively, if you want to process the comma-separated data first, use Extract Data From Values with the regex [^,"]+"?[^,"]+ to split the values into a list, then map them to separate columns. [2]
Clay Support
APP
·
·
If you still need help splitting your LinkedIn URLs into separate columns, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Vlada M.
·
·
yes
Clay Support
APP
·
·
To split your comma-separated LinkedIn URLs into separate columns:
Method 1: Use "Add as column"
1.
Click on a cell with your comma-separated URLs
2.
In the Cell details panel, hover over each individual URL
3.
Click "Add as column" for each URL to create separate columns
Method 2: Extract and write to table
1.
Use Extract Data From Values on your column
2.
Add the column using the / command
3.
Apply this regex: [^,"]+"?[^,"]+ to split values into a list
4.
Use write to table to send each URL to separate columns [1]
Which method would work better for your workflow?
Clay Support
APP
·
·
If you need any more help with splitting your LinkedIn URLs into separate columns, please let me know. Would you like to share more about your workflow or any specific challenges you’re facing with these methods?

Clay Support
APP
·
·
The formula generator creates a single output column, not multiple separate columns. To split your comma-separated LinkedIn URLs into individual columns (LinkedIn 1, LinkedIn 2, LinkedIn 3), here's what to do:
Method 1: Extract individual URLs using formulas
1.
Create separate formula columns for each URL position
2.
Use formulas like: • LinkedIn 1: Extract the first URL from the list • LinkedIn 2: Extract the second URL from the list • LinkedIn 3: Extract the third URL from the list
Method 2: Use "Add as column" feature
1.
Click on a cell containing your comma-separated URLs
2.
In the Cell details panel, hover over the individual URL values
3.
Click "Add as column" to create a new column for each URL [1]
Alternatively, if you want to process the comma-separated data first, use Extract Data From Values with the regex [^,"]+"?[^,"]+ to split the values into a list, then map them to separate columns. [2]
Clay Support
APP
·
·
If you still need help splitting your LinkedIn URLs into separate columns, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Vlada M.
·
·
yes
Clay Support
APP
·
·
To split your comma-separated LinkedIn URLs into separate columns:
Method 1: Use "Add as column"
1.
Click on a cell with your comma-separated URLs
2.
In the Cell details panel, hover over each individual URL
3.
Click "Add as column" for each URL to create separate columns
Method 2: Extract and write to table
1.
Use Extract Data From Values on your column
2.
Add the column using the / command
3.
Apply this regex: [^,"]+"?[^,"]+ to split values into a list
4.
Use write to table to send each URL to separate columns [1]
Which method would work better for your workflow?
Clay Support
APP
·
·
If you need any more help with splitting your LinkedIn URLs into separate columns, please let me know. Would you like to share more about your workflow or any specific challenges you’re facing with these methods?