How to Use Wikipedia Data in App Lab

Follow

Wikipedia has lots of data that you might be interested to use in App Lab as a dataset. From the latest election results, to the table of Oscar winners, the possibilities are endless. The process to get this Wikipedia data into App Lab is quick and easy, all you need is to follow the following steps.

Step 1: Find the Wikipedia URL that includes a table. For example the URL https://en.wikipedia.org/wiki/List_of_multiple_Olympic_gold_medalists includes a table of top medal recipients:

Screen_Shot_2022-02-25_at_4.21.27_PM.png

 

Step 2: Go to https://wikitable2csv.ggor.de/ and insert the Wikipedia page URL, then press "Convert".

Screen_Shot_2022-02-25_at_4.22.11_PM.png

 

Step 3: Press “Download” to get the .csv for the table(s) you are interested in, noting that many Wikipedia pages include more than one table that you can choose from. 

Screen_Shot_2022-02-25_at_4.22.21_PM.png

 

Step 4: Open your App Lab project, and click on the Data tab in the top left corner

mceclip0.png

 

Step 5: Enter a name for your dataset and click "Add":

mceclip1.png

 

Step 6: On the next screen, choose “Import csv” and select your .csv file that was downloaded in Step 3:

mceclip3.png

 

Step 7: Choose “Overwrite existing data.” Since this is a brand new table, you won’t lose any data when you do this. Your dataset is now live in your project, to pull and display data from.

mceclip4.png

 

Now you’re ready to use Wikipedia data in your app!

 

 

 

 

 

 

 

Powered by Zendesk