Excel is unavoidable for SEOs. There are many excellent keyword research tools and data sources available, but eventually you’ll find yourself exporting something into Excel or using it to fine tune your dataset. With this in mind, it’s beneficial to spend some time learning the most practical and commonly used formulas for SEO. We’ll walk you through some of our favorites and how we use them below.
Formulas
Concatenate
This allows you to combine two things, whether it be two cells or 1 cell + words.
We use it the most when exporting data from Google Analytics. Google Analytics doesn’t export the domain name with the landing page slug, so sometimes we need to add the domain to the slug.