A Google Spreadsheets add-on that makes working with data from Wikipedia and Wikidata a joy.
See the output of the functions in this Google spreadsheet.
Here's a screenshot:
Find the Wikipedia Tools in the Google Add-on Store and install them by clicking on the blue "+ Free" button.
Once the add-on is installed, click "Add-ons" > "Wikipedia Tools" > "Show documentation" in the Google Sheets menu bar to see a sidebar with the full documentation and examples.
The documentation can also be browsed online without installing the addon.
Copyright 2016 Thomas Steiner (@tomayac)
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.