This is a tool for anyone who works with link data on a regular basis, and needs the domain from many URL strings.
With this add-in all you have to do is press Ctrl+shift+D and any URL you’ve highlighted is zapped into a domain – easy!
I work with link data almost every day, and it frustrates me that the domain isn’t part of most databases exports. Most sources (both free and paid for) don’t provide a root domain to reference. This is especially annoying if you’re working from Bing Webmaster Tools or Google Search Console data, and you end up with long lists of individual pages.
Whether you’re trying to group backlinks by domain, or doing a URL audit on a big site, this tool will save you time and a lot of repetitive labour.
Normally to turn a list of URLs into domains you’d have to do a series of find and replace tasks. E.g.:
So I use a bit of visual basic that does these procedures faster than humanly possible, and takes the chore away with just one macro shortcut.
This will be useful to anyone working in SEO, so I thought I’d share it. It’s easy to install (see below) and becomes a permanent part of your Excel. Converting URL strings will become a simple reflex after a few goes.
How to use:
How to install: