Select Page

Analyze Semrush Exports with Google Spreadhsheet

If like me you don’t like to work directly in Semrush, you can use this Google Spreadsheet.

semrush_explorer_hugoakhtari

How Does it work ?

Step 1 : Make a copy of the Spreadsheet

Click on the button above or here to make a copy of your own.

step1_semrush_explorer_hugoakhtari

Step 2 : Get your Semrush export

Try to limit your export size by excluding low volume keywords or really badly ranked ones.

step2_semrush_explorer_hugoakhtari

Step 3 : Copy Paste the Semrush export in the dedicated tab

Delete the existing content before pasting your raw export in the “PASTE SEMRUSH EXPORT HERE” tab.

step3_semrush_explorer_hugoakhtari

Step 4 : Analyze your results by using filters

You can include or exclude keywords and URL patterns. It works with REGEX so you can use a pipe | to filter several patterns.

You can also filter on a position range (e.g: keywords between pos. 1 to 5) as well as a minimul volume.

All the KPIs (Total Volume, Number of keywords and Average Position) update according to your filters.

step4_semrush_explorer_hugoakhtari

Source :  Hannah Rampton‘s awesome tools