AnkiWeb addon 1871608121
1 other version of this addon exists. Compare versions ↓
Synchronizes Anki decks one-way from a published Google Sheets CSV, creating, updating, and removing Basic or Cloze cards and assigning tags, without reverse syncing.
Open on AnkiWeb GitHub Find alternatives
stale
| Min Anki | Max Anki | Updated |
|---|---|---|
| 2.1.1 | + | 2025-03-13 |
Loading…
The original addon and its forks. The best value in each column is in bold.
| Version | Works on Anki 26.09.3 | Maintenance | Last activity | Votes | Approval | GitHub stars | Notes |
|---|---|---|---|---|---|---|---|
| Google Sheets to Anki this addon original | supported | stale | 13 Mar 2025 | 👍 6 · 👎 1 | 49% | 17 | beta |
| ↳ Sheets2Anki - Sync GoogleSheets with Anki database. | supported | active | 5 Jun 2026 | 👍 0 · 👎 0 | – | 9 |
Forks can add features or work in a different way. Read the description before you change to another version. Fork detection is incomplete, so other versions can exist.
Syncs Anki decks with published Google Docs as the source of truth, adding, updating, or deleting cards while preserving update history.
Two-way Google Sheets sync for vocabulary decks, writing review stats back to the sheet and gating reverse cards until forward cards mature.
Imports CSV or pasted text into Anki with auto-detected delimiters and note types, searchable deck selection, quick imports, subdeck creation, tag handling, and session history browsing or deletion.
Batch imports multiple Excel, CSV, TSV and TXT files into Anki, auto-creating filename-based decks and subdecks, with field mapping, configurable duplicate handling, and Excel text color support.
Imports XLSX spreadsheets directly into Anki, auto-matching field names and letting each field be processed as text, HTML, or Markdown.
Turns Anki into a markdown notebook where you write papers, organize them in folders, and generate Basic, reversible, and cloze cards from plain-text lines.
Sheets2Anki is an add-on that synchronizes your Anki decks with a Google Sheets document published as CSV.
{{c1::...}}) to create Cloze cards, otherwise creates Basic cards.tags column, those tags are assigned to each card in Anki.Check out this template Google Sheets document to see different examples and the format you can use with Sheets2Anki.
File > Publish to the web (select "CSV").Tools > Manage Remote Deck > Add New Remote Deck.Tools > Manage Remote Deck > Sync Remote Decks.Front, BackText, ExtraFor documentation, examples, or to report issues, please visit the GitHub repository.
Sheets2Anki is an Anki add-on that synchronizes your Anki decks with a published Google Sheets CSV. Your Google Sheets document serves as the source of truth: when you sync, cards are created, updated, or removed in your Anki deck to reflect the sheet’s contents. This add-on is currently in beta, so features and behavior may still change.
{{c1::...}}) in the question field for Cloze cards. Other questions become Basic cards.tags column in your sheet, those tags will be assigned to the cards in Anki.Important: This add-on is in beta and currently supports only Basic and Cloze note types. Future updates may improve or extend functionality.
No Reverse Sync:
All changes flow from Google Sheets to Anki. If you delete or modify a card in Anki, it will not update the sheet. To permanently remove a card, remove it from the sheet before syncing again.
Syncing vs. Disconnecting a Remote Deck:
Tools > Manage Remote Deck > Disconnect Remote Deck. This "unlinks" Anki from the sheet. The local deck remains and can be edited freely in Anki as a normal deck.Use this example Google Sheets document as a starting template.
question, answer, and tags columns as needed.{{c1::essential}}) for Cloze cards.Download the .ankiaddon File:
.ankiaddon.Install in Anki:
Tools > Add-ons > Install from file.....ankiaddon file.Add a New Remote Deck:
Tools > Manage Remote Deck > Add New Remote Deck.Sync Decks:
Tools > Manage Remote Deck > Sync Remote Decks to update Anki from the sheet.Disconnect a Remote Deck:
Tools > Manage Remote Deck > Remove Remote Deck.Front and Back.Text and Extra.Confirm these models exist before syncing.
question, answer, tags) and ensure required note models exist.{{c1::...}}) is correct and the Cloze model has Text and Extra fields, see Example Google Sheets Document above.Sheets2Anki is in beta. Basic and Cloze types are supported now, but more features and improvements may follow as the project evolves. Keep an eye on this repository for updates.