Find where URLs are redirecting to. You can choose a CSV, choose a column (you can only do 1 at a time) and resolve the URLs and then download the updated CSV.

The resolved URLs will only show the first redirect in case there is a redirect chain.