Features of !SEMTools
↑ Navigate Excel tasks and !SEMTools add-in features ↑

PPC advertising

Google Ads work in Excel: negative keywords and match types, grouping and cleaning search queries, search term analysis and ad metrics.

Excel word combinations generator

A free tool to generate linear combinations of phrases from words right in Excel. Multiply word lists instantly, like popular online generators.

I made a word combination generator - a simple tool in Excel to combine words and phrases. I'll show you how to use it. Sometimes you need to generate multiple…

N-gram analysis in Excel

Count unique words in text and list them with frequency, analyze n-grams of search queries, find negative keywords. All about n-gram analysis in Excel.

For search advertising and SEO, n-gram analysis is one of the most effective approaches. For a long time, implementing reliable n-gram algorithms was practical…

N-gram analysis in PPC

What n-gram analysis is and how it helps in PPC: preventing DSA cannibalization, finding user intents and ineffective word combinations in search terms with Excel.

In semantic text analysis, n-gram analysis is one of the key methods. It reveals all unique words and word combinations in a text and counts how often each…

SEM & SEO tools

Excel tools for SEO and PPC specialists: scraping search suggestions and meta tags, n-gram and semantic analysis, keyword combinations, custom metrics.

SEM & SEO tools are set aside in !SEMTools so as not to mix them with the more common functions that any Excel user needs. This group contains the functions for…