Analyze Semrush Exports with Google Spreadhsheet
If like me you don’t like to work directly in Semrush, you can use this Google Spreadsheet.
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.
Step 2 : Get your Semrush export
Try to limit your export size by excluding low volume keywords or really badly ranked ones.
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.
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.
Source : Hannah Rampton‘s awesome tools