Import Website Data into Google Spreadsheets (and Anki) with =ImportHtml()

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:

Once you have data in a spreadsheet you can export it as a .csv file and then import it into Anki.

1 Like

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/

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: