Free Spreadsheet For Grabbing Entities From Wikipedia

Four weeks ago I sent out a note showing you how you can quickly identify which pages are internally linking to a Wikipedia page using Wikipedia itself. The topics of these pages are potentially relevant entities to the topic of the initial page.

If you missed that note, you can read it here.

I shared this idea in a Facebook group, and David Gossage from SEO Greetings, took the idea and built a Google Sheet he is sharing that will automate the process for you.

You can read about it here.

And make sure you sign up for his newsletter while you are there. Form is in the footer.

Then make sure you grab a copy of the free spreadsheet following the link at the bottom of the page or by clicking here.

All you have to do is put your topic into one of the cells in column A. The rest of the sheet will automatically populate for you.

Thanks David for the great free tool.

Here is a video version of today’s tip:

Tools I Use:

๐Ÿ”Žย  SemrushCompetitor and Keyword Analysis

โœ”ย  Monday.comFor task management and organizing all of my client work

๐Ÿ—„ย  FraseContent optimization and article briefs

๐Ÿ“† Akiflow – Manage your calendar and daily tasks

๐Ÿ‘‘ย  ContentKing AppSite crawler, monitoring, and audit tool

๐Ÿ“ˆ SEOPress โ€“ Itโ€™s like Yoast, if Yoast wasnโ€™t such a mess.

Sign Up So You Don't Miss the Next One:

vector representation of computers with data graphs
Subscription Form

Past tips you may have missed...