Importing data from WikiData into Google Sheets with IMPORTXML
Friday, October 8, 2021
Here comes another tip for leveraging one of the most important inventions in the 20th century, the spreadsheet1. Say you have a list of the number of GDPR fines and the country where they were issued, and you would want to know what the fine/population ratio is. The easiest and quickest way be to go to Google it, and copy/paste the first table you find into a new Sheet. Then using the =VLOOKUP function to grab the population for each.