Lets say I was given an excel file with a list of all URL's and their respective canonical settings. Is there a better way of combing through the data to find sub-optimized canonicals than sifting through them one by one?

Imagine an excel file with 3000 URLs.

I can easily tell which of the url's have canonicals with tools but i find it somewhat more difficult to automate the discovery of sub-optimized canonicals such as pointing to a version that is not the prefered page, pointing to the homepage by default etc.

I can only imagine doing so manually but the thought of doing so is just dreaful.

Surely there is an easier way?

submitted by /u/DeepKaizen
[link] [comments]

from Search Engine Optimization: The Latest SEO News https://www.reddit.com/r/SEO/comments/qka464/lets_say_i_was_given_an_excel_file_with_a_list_of/>