Do you ever have Wikipedia data you need in a spreadsheet? Using Google Sheets you don’t have to copy and paste. Instead, use the ImportHTML function in Google Sheets and get the data from

Wikipedia.

Scraping data can save you tons of time. Copy and paste aren’t always easy from a web page into a spreadsheet. Google sheets has a function that will pull a Wikipedia table into the worksheet. The function is ImportHTML.  Here is a sample of the function below.

Here is the Wikipedia web page. https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)

There are multiple tables on the webpage. Some of the tables do not look like tables.

Google Sheets iconOpen Google Sheets and put in the function below. You copy and paste the URL information from Google.

Notice the URL and the word table have quotes around them. The number 2 means table number 2.

=ImportHtml(“https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)”, “table”, 2)

 

 

chris menard on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor

I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I’m not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I’ve created come from questions asked during MS Office training.


Pin It on Pinterest