I’ve been working on a userscript for the last few hours to bulk-add alternate answers from a spreadsheet, much like you can bulk-add the words in the first place. This is a necessity for me, due to the way I’ve decided to structure my latest Swedish course (essentially - for the example columns, I’m using the “alternate answer” for the English translation, which means that it’s hidden by default unless you click “more” even though the columns are set to “always show”). That said, I think everyone probably wants this.
The basics are done - it works and it seems to work quite well, from my initial testing. I just need to test it some more and make sure that I’m not going to be hammering their API too much. Then I need to hack a Memrise-like UI together for it (matching the UI for the bulk-add words feature).
The only caveat is that you need to have a separate worksheet for each column’s alternate answers but even if you have many columns - this is a million times better than adding them manually, one by one.
I’ve prepared a spreadsheet that shows you how you can layout your spreadsheet (or at least how I plan to lay out mine). As you can see, there is a separate worksheet for each column’s alternate answers and these are dynamically linked (in both directions). If you add a word to the master sheet, it will show up in all of the alternate answer sheets and if you add an alternate answer, it will show up in the master sheet. You won’t be able to edit this spreadsheet however you can File > Make a Copy
if you want to play with it.
I’ve also created a Github repository for this userscript (and others) to live at but there is nothing there, yet. Feel free to follow or star the project, if you’d like Github to notify you when stuff happens. I’ll keep you updated here too, though. Oh and… if you have any ideas, suggestions etc. then please…