I've got a spreadsheet with about 7000 rows of data. I have a URL for each row, but the URL is entered as a search query that redirects to the appropriate result:
URL-LINK - www.shopcwi.com/searchresults.aspx?SearchTerm=A1032
When following this URL, it immediately redirects you to the item URL:
This is the URL I need to use for the
=IMPORTXML function, but I really don't want to copy the redirect URLs one by one 7000 times. Is there an easy way, formula, script, w/e to pull the URL that the search query URL redirects to?
I've tried searching every variation of this question I can think of with no success. I'm at a total loss. I know enough about scripting to modify things to suit my needs usually, but I can't find a starting point, and I'm not knowledgeable enough to do it from scratch. I'm hoping there's some easy solution like a formula, or perhaps an external URL redirect checker (which I've also been trying to search for) where you can upload a list of URLs and it will export a list of destination URLs.