Improved import from spreadsheet via clipboard

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.

---

Liên kết hỗ trợ

• Contact Author
• Contact Author

---

Reviews (1)

👍 2022-12-03

Thank you very much! Five minutes of figuring out what the names of the fields in the spreadsheet should be in my case. It works! Here are the fields for my cards: https://capture.dropbox.com/CddVod4mCsyRl7my