3 ms·
Data Scraping Wikipedia with Google Spreadsheets
- EastSmith 18y ago"So to recap, we have scraped some data from a wikipedia page into a Google spreadsheet using the =importHTML formula, published a handful of rows from the table as CSV, consumed the CSV in a Yahoo pipe and created a geocoded KML feed from it, and then displayed it in a Yahoo map." Hilarious!
- Jasber 18y agoOr you could just use DBpedia: http://dbpedia.org/About http://dbpedia.org/About
- pedalpete 18y agothe purpose isn't to show getting data from wikipedia. this can be done with any html table
- blakeweb 18y agoFantastic. Such a cleaner method than copy-pasting table data from web pages into excel to visualize and manipulate it, which I've done countless times doing market research.
- theschwa 18y agodoes any one know of a way to incorporate google spreadsheets with ajax rendered table data?
- zandorg 18y agoMy BSc dissertation was on a simplified English dialect (language) which can be translated into triplets (or data items) while still being readable as English. However, I never really finished the editor it required which hooked up to a parser to show you the triplets as you type. Also, I'm bad at getting traction on my ideas.
- PJGoldwing 18y agoBravo! One of the most useful submissions to HN in a while. This is the kind of thing that gives my faith in tech a little boost - "throwing sheep at your friends on facebook" or cute productivity apps that reduce your productivity are not.