SeoTools v6: Faster, more stable and no ads!

by Niels Bosma

TL;DR We've been working on SeoTools 6.0 for quite a while and there's a lot of new updates. This is probably the largest update we've ever released! Dowload the latest version of SeoTools! Async and Caching MAJOR UPDATE: Most functions incl. Connectors are now asynchronous meaning that they can be stopped and can run in parallell (if the external data source permits it) and won't make it seem like Excel freezes. This translates into a HUGE boost in...

15 Excel tips every SEO professional must know

by Victor Sandberg

Whether its basketball, pubic speaking, or SEO, mastering the fundamentals is key. Sure, you may be able to alter a data set manually or copy a strange looking formula, but if you want to be prepared for the challenges of tomorrow, this article will get you a long way. Mikkel Sciegienny at Spreadsheeto has been involved with SEO for five years and in this blog post he will share 15 important tips for mastering Excel. 15 Excel tips every SEO...

SeoTools 5.1

by Niels Bosma

Time for a new release! SeoTools now ships with an installer making installation and upgrades a lot easier! Download SeoTools 5.1 Google Search Console Google actually released a really good API for retrieving search data! Now you can access this directly in Excel with SeoTools. Read more Use Google’s Search Console API & Pivot Tables To Supercharge Your Long-Tail SEO Sistrix First connector created by William! Implemented most of the Sistrix API. If you're a Sistrix customer, this...

Pull social metrics for multiple accounts

by Niels Bosma

We often get this question: How can I pull social metrics for multiple twitter/facebook/linkedin accounts at a time? Instead of having to input the url manually for each pull. This is actually quite easy: In the wizard of a connector or integration generate the query as a formula and then replace the literal url with a reference to the first cell in the column of urls. Then use Excel's autofill feature to populate the rest of the cells....

Securely compare customer lists from two parties

by Niels Bosma

Say you're negotiating a deal with an external party and to be able to move forward you need to know how many customers do we have in common? Neither party is at this stage interested in sending their list of customers. My solution to this problem is by using the new MdFive function in SeoTools 5.0. MD5 which stands for Message Digest algorithm 5 is a widely used cryptographic hash function that was invented by Ronald Rivest in 1991....