There are a number of useful Python libraries for SEO tasks ... extract only those pages that are indexable, I will use a built-in Pandas function to include only those URLs in my DataFrame.

you can use Python’s replace method and provide a list. Extracting a substring within Excel requires the usage of the LEFT, MID, or RIGHT functions, depending on where the substring is located ...