Free keyword search volume tool using the SEMrush API to return bulk keyword search volume data directly from the SEMrush API!
A totally free keyword search tool that can check volume in bulk, with a few extra features, built right into a Google Sheet. You’ll need an SEMrush API key to use this tool.
Get this SEO tool for free!
Click the "Free Download" button below...
Instantly receive a link to access this free SEO tool.
Send download link to:
Bitcoin
Donate Bitcoin to support RankTank
Scan the QR code or copy the address below into your wallet to send some Bitcoin to keep RankTank free forever!
Get this SEO tool for free!
You can also Make a Copy of this Google Sheet SEO tool, help fix and improve it for others.
Tutorial Video
Know Issues
1. The SEMrush API key validation does not show API credits left. (Fixed in latest version)
16 comments
[…] to the ones above, they have free tools for getting email alerts about important SEO changes, checking keyword search volume, and conducting a basic SEO site audit. If the pro membership of $149 a month is more than […]
Unfortunately it’s not working anymore. The search volume doesn’t appear in the cell. :/
[…] #1 Top Rated […]
Thanks for your tool. It is really helpfull
Thanks for giving these tools!
Nice & Helpful
Thank you very much your tool
Thanks for sharing!
I think the tool is broken. I cant find anything properly. Please check and set up properly.
Hi Pankaj, please make sure you have a SEMrush API key to use this sheet :P. You can obtain a free SEMrush trial here: https://link.ranktank.org/semrush-trial
I believe this tool is broken, https://www.ranktank.org/bulk-keyword-search-volume-tool/
Cells A4 and C1 both have an error stating “this function is not allowed to reference a cell with NOW(),RAND(), or RANDBETWEEN()”
It was working last moth, maybe Google Sheets made a change on their end?
Hi John, NOW() is no longer supported by Google Sheets in this context. I made a temporary and hacky fix to make the sheet work again. 🙂
Just fab mate! Couldn’t find this anywhere! Thank you
All the sudden I am having a problem. I am getting a message telling me safari quit working please reload. Any advise?
Anyway to add the keyword difficulty score in here? I need a way to pull that to check lists of 10K or so keywords.
Where does SEM Rush get their monthly search volume data from?