How to Split a Comma-Separated List of URLs From a Column Into Separate Rows in Google Sheets
![](https://highviewapps-main-site.s3.amazonaws.com/media/blog/thumbnails/links.jpg.800x400_q85_crop-smart.jpg)
If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:
=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))
The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.
Here's what the formula does:
-
JOIN(",", Sheet1!B2:B)
: This part of the formula combines all …