Improved import from spreadsheet via clipboard

AnkiWeb addon 2027558490

Imports Anki cards in bulk from copied spreadsheet data formatted with a special header, notetype, deck, tags, field names, and rows.
AI-generated summary; may contain mistakes.

card-creation import

Open on AnkiWeb Forum topic Ask about alternatives

AnkiWeb

Rating: 1 (👍 1 · 👎 0)
Updated: 2021-11-08
Anki versions: 2.1.43~
Description language: en

Maintenance

abandoned

Last update or commit was 1788 days before the snapshot (2021-11-08).

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

Spreadsheet Import Plus

Imports XLSX spreadsheets into Anki with auto-matched fields, per-field text/HTML/markdown handling, and a required versioned sheet layout.

card-creation import formatting

Paste TSV / Excel / Sheets Row to Fields (Auto Fill & Tags)

Pastes tab-separated spreadsheet rows into Anki fields sequentially, assigns extra columns to tags, supports cursor-based insertion, HTML, newlines, and a toolbar button or shortcut.

card-creation import tagging shortcuts

csv import plus

Streamlines CSV and pasted-text imports into Anki with auto-detection, note-type suggestions, quick import, deck locking, history, and tag support.

card-creation import tagging deck-management

AnkiBulk

Quickly adds many Anki notes by filling a table or YAML, copying data to external tools, and pasting results back for bulk creation.

card-creation export note-management

🚀 JSON Bulk Importer - from AnkiVN with ❤️

Bulk imports, updates, and exports Anki cards via JSON, with automatic note type creation, media embedding from URLs, and per-card deck/tag options.

card-creation import export note-management

field_injection_extraction

Bulk exports and imports selected Anki note fields via TSV, supporting HTML or plain text, replace/prepend/append modes, exact NID matching, tags, review, and undo.

import export note-management

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.