How to setup Tlds in SeoTools.config.xml

by Niels Bosma

I got a question in the SeoTools Community Forum on how to setup a .fr TLD in SeoTools.config.xml and decided to make a blog post about it. This post assumes some knowledge in regular expressions. If you don’t know this already, regular expression are extremely powerful and really useful when working with SEO. Start by reading An SEO’s Guide to RegEx. In SeoTools.config.xml you can add additional TLDs to support functions that use whois...

Working with regular expressions in Excel

by Niels Bosma

Regular expressions can be very useful for validating and manipulating data. Unfortunately there’s no built in support for regular expressions in Excel. You can use VBA but I think that’s a bit too messy. In my Excel plugin SeoTools, I’ve added four methods: =RegexpIsMatch(string input; string expr) Matches an input string with a regular expression and returns true if there’s a match. =RegexpFind(string input; string expr; int group) Takes a regular expression and retrieves...

Using Excel for finding available domain names

by Niels Bosma

Using a good domain name for a project can be key for a successful web project. I terms of SEO it is for example (at the moment at least) good to have the most important search phrase that you’re targeting in your domain name (read more on this. Finding available domain names is hard. And not all TLDs are equally good. In my project SeoTools (Excel extension that adds functions to your excel workbook) I’ve added two functions...

Excel plugin for finding duplicate content in cells

by Niels Bosma

When working with onpage SEO you need to write unique content to keep googlebot happy. Especially if you operate a web page that has a lot of verticals and regions and each combination have it’s own landingpage. Writing really unique content in scale is very difficult and with really unique content I mean never using the same sentence twice. We use Excel for writing content for landingpages. The problem that I wanted to solve is that given two texts...