Sheets2Anki is an add-on that synchronizes your Anki decks with a Google Sheets document published as CSV.
Features Basic & Cloze Support Automatically detects Cloze formatting ({{c1::…}}) to create Cloze cards, otherwise creates Basic cards. Tag Assignment If you include a tags column, those tags are assigned to each card in Anki. Removes Deleted Cards Cards removed in Google Sheets are also removed in Anki. (No reverse sync: removing a card in Anki doesn’t delete it in Sheets.) Usage
Check out this template Google Sheets document to see different examples and the format you can use with Sheets2Anki.
Publish a Google Sheet as CSV In Google Sheets: File > Publish to the web (select “CSV”). Copy the published CSV URL. Add a New Remote Deck in Anki Tools > Manage Remote Deck > Add New Remote Deck. Paste the URL and name the deck. Sync Decks Tools > Manage Remote Deck > Sync Remote Decks. Any changes in the sheet (added, updated, or removed cards) will appear in Anki. Important Notes No Reverse Sync Deletions and edits in Anki won’t affect the Google Sheet. For permanent removal of a card, delete it in the sheet first. Beta Status Sheets2Anki is in beta. Expect further updates and improvements. Requirements Anki 2.1.x Basic model with fields Front, Back Cloze model with fields Text, Extra Further Info
For documentation, examples, or to report issues, please visit the GitHub repository.
Liên kết hỗ trợ
Reviews (7)
👍 2026-01-19
so useful!! been looking for something like this thank you so much!!
👍 2025-12-05
Muy bueno
👍 2025-09-23
It has stopped working for me… same for everyone else? Posted on Github in case someone may be able to help
👍 2025-08-30
Thanks
👍 2025-06-01
Thanks! It’s really helpful. Could you add a feature that can facilitate to use ‘field’ sometime?
👍 2025-05-18
Amazing addon, thank you! Very useful for batch loading.
👍 2025-04-04
Automatically uploaded, thanks.
