Sometimes the best SEO tools are free.
Look no further than Google Sheets.
While it’s not great at plotting ranking data (inverting the y-axis is always ugly), there are numerous ways to use Google Sheets for SEO.
Here are 11 of the formulas and tips I find myself using for SEO on an almost daily basis – for keyword management, internationalization, content/URL management and dashboards.
Google Sheets formulas for keyword management
- V LOOKUP
- CONCATENATE
- FLATTEN
- LOWER
=VLOOKUP(text,[range to search],[column number to return],[true/false])
V LOOKUP (documentation)
VLOOKUP, which stands for “vertical lookup”, is arguably one of the very first Google Sheet formulas for SEO anyone learns when getting into the game.
VLOOKUP allows you to essentially combine two data sets on common values, an almost lowbrow JOIN in SQL if you will.
I generally use this formula to enrich information about keyword sets by adding search volume, PPC data or adding downstream metrics like signups.
The end directive true/false specifies how exact you want the match to be, TRUE means not an exact match, and FALSE means exact matches only.
Tip: LOCK the range you’re searching against using $ ($E$3:$E$5 in the below example) so you can drag and carry the same formula across many rows.
=CONCATENATE(A1,A2,A3)
CONCATENATE (documentation)
- =CONCATENATE(A1,A2,A3) you have the option to concatenate columns
- =CONCATENATE(A1,” I’m additional text”) or literal words and characters
Concatenate is one of the most...
Read Full Story: https://searchengineland.com/google-sheet-formulas-seo-386150
Your content is great. However, if any of the content contained herein violates any rights of yours, including those of copyright, please contact us immediately by e-mail at media[@]kissrpr.com.
