sheet2api
p/sheet2api
Turn any Spreadsheet into an API
Richard O'Dwyer
Wikipedia Article Table to API — Every Wikipedia article table is now an API
Featured
13
Paste in a link to any Wikipedia article which contains some tables and it will create a fully working JSON REST API for each table within the article.
Replies
Best
Marcin Jasiukowicz 🅨
First I've tried it on a list of rocket launches, but it tells me there is no table on this page (https://en.wikipedia.org/wiki/19...). It looks really cool regardles, and I'm looking forward to it supporting more complicated table layouts! Maybe fuse the data from Semantic wiki?
Richard O'Dwyer
@yasiupl Those tables are in an incompatible format, by chance.
Marcin Jasiukowicz 🅨
@richardodwyer Poor luck, that was really my first try :P Could your api possibly use wikidata in the future? I think most of the tables are generated from wikidata anyways.
Richard O'Dwyer
Hi all, this is a free tool I created for fun really. Paste in a link to any Wikipedia article which contains some tables and it will create a fully working JSON REST API for each table within the article.
Andy Cloke
Cool idea! I tried it with https://en.wikipedia.org/wiki/Ol... (https://sheet2api.com/tools/wiki...) and it seemed to only find 1/3 tables that are on that page though.
Richard O'Dwyer
@andycloke Some tables on Wikipedia aren't in a format where it can work (without me doing more work than I want to). E.g. "Appearances and goals by club, season and competition" on that page. That's life.
Muꞃċaꝺ̇ Mac Neaċꝺainn
A neat experiment, and a nice little peephole into a future when literally everything in Wikipedia is sourced from an underlying knowledgebase. Some day...
Artur Mkrtchyan
@richardodwyer this is really cool! Will save tone of time for many developers.
Richard O'Dwyer
@arturmkrtchyan Thanks. Although this is basically a 'toy' tool. It makes you think, there must be so much data being maintained by people in all these tables on Wikipedia. You could probably use it for a real product (so long as the Wiki page it's linked to is well looked after)
Zac Brown
great idea!