Josh
(Josh Cohen)
June 5, 2014, 7:27am
1
It is now possible to import data from websites into Google docs with an =ImportHtml() function. Open a Google Spreadsheet and paste the following line into a cell:
=ImportHtml("http://en.wikipedia.org/wiki/List_of_Greek_gods", "table", 3)
It should load a table.
The function is =ImportHtml() and the parameters are: url, list or table, and index.
More info:
Imports data from a table or list within an HTML page. Sample Usage IMPORTHTML("http://en.wikipedia.org/wiki/Demographics_of_India","table",4) IMPORTHTML(A2,B2,C2) Syntax IMPORTHTML(url, query, i
Once you have data in a spreadsheet you can export it as a .csv file and then import it into Anki .
1 Like
bruno
June 5, 2014, 8:35am
2
That’s great ! It seems even more handy than what you previously found http://blog.mnemotechnics.org/create-anki-flashcards-from-webpages-4548.html .
With the same idea of importing web content to anki, I think you might appreciate http://import.io .
I am sure that there are plenty applications to turn the web into anki decks.
I did that to import wikipedia stuff into anki GitHub - brumar/WikiImport: Anki addon to import all the first paragraphe from a wikipedia category , anki plug-in here : https://ankiweb.net/shared/addons/
Josh
(Josh Cohen)
June 5, 2014, 9:05pm
3
Good idea to use Import.io . I’ve been using it for another project for a client and it seems to work well.
Here are a couple of other GUI-based scraper tools that might be worth experimenting with: