Import Wikipedia Data To Google Sheets

How to import Wikipedia data to Google Sheets
Reading Time: 4 minutes

Wikipedia needs no introduction. What you perhaps don’t know is that you can import Wikipedia data to Google Sheets using its free API. This includes page information, page citations, aggregated featured articles, events, births and deaths on a particular day, and many others.

Here’s a quick guide on how to import Wikipedia data to Google Sheets:
Step 1: Install Amigo Data add-on
Step 2: Choose a Wikipedia endpoint
Step 3: Enter the endpoint API URL in Amigo Data
Step 4: Preview the data and click IMPORT

How to import Wikipedia data to Google Sheets

Let’s see how to import Wiki data to Google Sheets step by step:

Step 1: Install the Amigo Data add-on

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace. Click here.

Alternatively, you can get it from Google Sheets itself.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo Data and install

Step 2: Choose a Wikipedia endpoint

Go to the Wikipedia API documentation page and choose an endpoint for the data to import from Wikipedia.

The endpoints can be found under their respective headings. For example, page information under Page content; events and featured contents under Feed; article citations list under Citation; and so on.

Let us import the wikipedia list of (famous) people born on a particular day, for the purpose of this tutorial.

Follow the steps below to get the endpoint.

  • On the API documentation page, expand the Feed heading and click the Events on this day option.
List of endpoints to import Wikipedia data to Google Sheets
  • Then click the Try it out button
Testing the endpoint in the API documentation page
  • Change the Type of events parameter from all to births, and fill the month and the date, in MM and DD format, and click Execute.

For example, to get the list of famous figures born on leap day, we use enter 02 in the mm string and 29 in the dd string.

The parameters for the datapoint
  • Copy the Request URL under Responses. This is the endpoint.
The endpoint URL

The endpoint to import Wikipedia data to Google Sheets is:

https://en.wikipedia.org/api/rest_v1/feed/onthisday/births/02/29

Step 3: Enter the endpoint in Amigo Data

Now, go back to Google Sheets and launch Amigo Data.

Click Extensions→Amigo Data–Connect

Launching the Amigo Data extension in Google Sheets

Select Custom API from the list of sources

List of sources to connect

Paste the endpoint in the API URI bar

API URL bar to paste the endpoint

Step 4: Preview the data and import

After entering the endpoint in Amigo Data API URL bar, click the PREVIEW button.

Then flatten all the data points, delete all those that are not required, and then click the IMPORT button.

The Wikipedia data will be imported into Google Sheets in a few seconds.

Snippet of the data imported from Wikipedia to Google Sheets

And that’s how we import Wikipedia data to Google Sheets in a few steps using Amigo Data.

To import other types of event data, we just need to change the event type and the month and the date.

Endpoint for events on January 1

Or we can simply change the endpoint URL ourselves. So, for example, the endpoint for events on January 1 will be

https://en.wikipedia.org/api/rest_v1/feed/onthisday/events/01/01

Deaths on Christmas endpoint

And for famous people who died on Christmas day, the endpoint is:

https://en.wikipedia.org/api/rest_v1/feed/onthisday/deaths/12/25

List of people who share birthday with you

You can likewise import the list of all renowned people who share the same birthday as you by using the births event.

This is the endpoint:

https://en.wikipedia.org/api/rest_v1/feed/onthisday/births/your_birth_month/your_birth_date

Other endpoints from Wikimedia

There are other kinds of here are other kinds of Wikipedia information that we can import to Google Sheets, such as daily or monthly page view counts of a particular article, top pages on a specific date, and top-visited pages in a particular country.

Endpoint pageview count of Albert Einstein’s English Wikipedia page in September 2022:

https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia/all-access/all-agents/Albert_Einstein/daily/2022090100/2022093000

Endpoint for most visited pages on October 2, 2022:

https://wikimedia.org/api/rest_v1/metrics/pageviews/top/en.wikipedia/all-access/2022/10/02

For more examples on page views, you can visit this page: https://wikitech.wikimedia.org/wiki/Analytics/AQS/Pageviews

For an exhaustive list of endpoints on various metrics, visit the official Wikimedia API documentation.

Setting refresh schedule

To get the information updated periodically, click the report, toggle on the Refresh Schedule and select the schedule–hourly, daily, weekly or custom days.

Then click Save & Run

Alerts via email or Slack

You can get the report sent to your email or a Slack channel so that you do not even have to open the spreadsheet to keep track of what’s happening.

To set up an alert, click Get Alerts→Add alert data+. Edit the details and click Set Alert.

Conclusion

We can easily import Wikipedia data to Google Sheets using Amigo Data–and also data from Wikimedia that are not directly available on Wikipedia such as page metrics.

See also

There are plenty of things that you can use Amigo Data for, such as importing data from Yahoo Finance, US Patent and Trademark Office, and Spotify, or exporting Google Ads data, YouTube Analytics data, and Facebook Ads data.

You can find all these and many more on our blog.

Some related articles you may be interested in:

https://blog.tryamigo.com/import-bscscan-data-to-google-sheets/

https://blog.tryamigo.com/import-indian-government-open-data-to-google-sheets/

https://blog.tryamigo.com/import-accuweather-data-to-google-sheets/