Improved import from spreadsheet via clipboard

AnkiWeb addon 2027558490

Adds cards in bulk by copying a specially formatted spreadsheet to the clipboard, then importing it with specified notetype, deck, fields, and per-card or global tags.
AI-generated summary; may contain mistakes.

card-creation import

Open on AnkiWeb Forum topic Find alternatives

AnkiWeb

Votes: 1 (👍 1 · 👎 0)
Updated: 2021-11-08
Anki versions: 2.1.43~
License: Not found (this does not mean that the addon has no license)
Virus scan: No ClamAV match A match does not prove malware. No match does not prove that the code is safe.
Description language: en

Maintenance

abandoned

Last update or commit: 2021-11-08 (1819 days before the snapshot).

GitHub

No GitHub repository linked.

Will it work on my Anki?

Version branches

Min Anki	Max Anki	Updated
2.1.43	+	2021-11-08

History across monthly snapshots

Loading…

Similar addons

AnkiBulk

Bulk-adds many notes at once via an editable table or YAML text view, exporting to the clipboard for LLMs or spreadsheets, using existing notes as context.

card-creation note-management

Spreadsheet Import Plus

Imports XLSX spreadsheets directly into Anki, auto-matching field names and letting each field be processed as text, HTML, or Markdown.

card-creation import

CSV Import Plus

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.

card-creation import tagging deck-management

Copy Text Field to Clipboard

Adds right-click Browser options to copy a selected field from multiple notes to the clipboard, either as clean plain text with header and Note ID or as raw HTML.

export note-management

TSV Clipboard Import

Imports notes from tab-separated clipboard text via a menu option or customizable shortcut, opening Anki's standard import dialog to select deck and note type.

card-creation import shortcuts

Quick Template Copy fork

Copies pre-formatted information from selected Anki Browser notes using customizable per-note-type templates, hotkeys, tag placeholders, and escaped HTML for Word/Excel compatibility.

export formatting shortcuts fork-or-reupload

Description

First, credit where credit is due. This was inspired by 'Add Note From Clipboard' (1749692420), which was later updated/forked by a third party as 1580846175. This add-on allows you to add cards in bulk from a properly formatted spreadsheet. Simply format your spreadsheet as shown below, select all of the data, copy it to the clipboard, and then go to Anki and use Tools->'Import From Clipboard' or use the shortcut, which is Ctrl+1 by default. Use this at your own risk. This works for me on both Windows 10 and Ubuntu 21.10, with Anki 2.1.43 and Python 3.9 installed. It may be necessary for you to install Python because this add-on uses the csv module, which doesn't seem to be distributed with Anki. I haven't tested on a system without Python so I don't know exactly what errors may occur. It most likely won't cause any harm and will only throw ModuleNotFoundError without further action, but again, use this at your own risk. Format your spreadsheet as follows: A B C D E 1 ###ANKICLIPBOARDIMPORT### ru_vocab_note ru_vocab_deck L28 noun 2 3 ru_with_accents russian english tags 4 RUS1ACC RUS1 ENG1 tag1 tag2 extra_tags_one_per_cell 5 RUS2ACC RUS2 ENG2 tag3 tag4 Cell A1 must have the string ###ANKICLIPBOARDIMPORT### exactly. Cell B1 is the name of the notetype you're using. Cell C1 is the name of the deck you're adding to. Cell D1 is a space separated list of tags to be added to every card. Row 2 is ignored, so you can either leave it blank or use it for formulas or whatever. Row 3 contains your field names. If you have one named 'tags' then whatever is in that column will be added as tags on a per-card basis, in addition to the tags in cell D1. Rows 4 and higher are your data. For extra tagging flexibility, you can also add per-card tags to the end of the row in columns without fields named in Row 3. Feel free to use formulas. Anki will get the evaluated data just fine. Useful if, for example, you want to keep stress marks in your Russian vocab to help with pronunciation, but you also want to use a formula to strip them out so that you can use a type field in your cards without having to type stress marks.